-
使用springboot默认的连接池
-
导入springboot data-jdbc依赖
org.springframework.boot spring-boot-starter-data-jdbc
-
配置文件配置连接池
spring: datasource: username: root password: 5201314 url: jdbc:mysql:///jqmb?serverTimezone=UTC driver-class-name: com.mysql.cj.jdbc.Driver
-
springboot默认的连接池
//java项目www fhadmin org
@Autowired
DataSource dataSource;
@Test
void contextLoads() {
System.out.println(dataSource.getClass());
System.out.println("____________________________________");
}
-
使用连接池druid
-
导入druid依赖
com.alibaba druid 1.0.18
-
配置文件配置druid的属性
#java项目www fhadmin org spring: datasource: username: root password: 5201314 url: jdbc:mysql:///jqmb?serverTimezone=UTC driver-class-name: com.mysql.cj.jdbc.Driver type: com.alibaba.druid.pool.DruidDataSource initialSize: 5 minIdle: 5 maxActive: 20 maxWait: 60000 timeBetweenEvictionRunsMillis: 60000 minEvictableIdleTimeMillis: 300000 validationQuery: SELECT 1 FROM DUAL testWhileIdle: true testOnBorrow: false testOnReturn: false poolPreparedStatements: true filters: stat,wall,log4j maxPoolPreparedStatementPerConnectionSize: 20 useGlobalDataSourceStat: true connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
-
配置类中对druid属性进行绑定
//java项目www fhadmin org
@Configuration
public class DataSource_Druid_Configure {
@ConfigurationProperties(prefix = "spring.datasource")
@Bean
public DruidDataSource getDataSour(){
return new DruidDataSource();
}
-
配置Druid的监控后台
//配置Druid的监控
//1、配置一个管理后台的Servlet
@Bean
public ServletRegistrationBean statViewServlet(){
ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
Map initParams = new HashMap<>();
initParams.put("loginUsername","admin");//登录用户名
initParams.put("loginPassword","123456");//登录密码
initParams.put("allow","");//默认就是允许所有访问
initParams.put("deny","192.168.15.21");//拒绝访问
bean.setInitParameters(initParams);
return bean;
}
//2、配置一个web监控的filter
@Bean
public FilterRegistrationBean webStatFilter(){
FilterRegistrationBean bean = new FilterRegistrationBean();
bean.setFilter(new WebStatFilter());
Map initParams = new HashMap<>();
initParams.put("exclusions","*.js,*.css,/druid/*");
bean.setInitParameters(initParams);
bean.setUrlPatterns(Arrays.asList("/*"));
return bean;
}
-
访问 localhost:8090/druid/login.html
-
如果sql监控失效需要导入log4j 依赖
log4j log4j 1.2.17