第一步:引入依赖
<!--Druid连接池-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.6</version>
</dependency>
<!--log4j-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
第二步:在yml中添加配置
type: com.alibaba.druid.pool.DruidDataSource #Druid连接池
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,去掉后监控界面sql无法统计,'wall'用于防火墙
filters: stat,wall,log4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
第三步:编写配置类
@Configuration
public class DruidConfig {
@ConfigurationProperties(prefix = "spring.datasource")
@Bean
public DataSource druid(){
return new DruidDataSource();
}
/**
* 配置servlet
*/
@Bean
public ServletRegistrationBean statViewServlet(){
ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
HashMap<Object, Object> hashMap = new HashMap<>();
hashMap.put("loginUsername","admin");
hashMap.put("loginPassword","1234");
hashMap.put("allow","");//允许访问所有
return bean;
}
/**
* 配置filter
*/
@Bean
public FilterRegistrationBean webStatFilter(){
FilterRegistrationBean bean = new FilterRegistrationBean(new WebStatFilter());
HashMap<Object, Object> HashMap = new HashMap<>();
HashMap.put("exclusions","*.js,*.css,/durid/*");
bean.setInitParameters(HashMap);
bean.setUrlPatterns(Arrays.asList("/*"));
return bean;
}
}
第四步:启动服务器并访问指定地址
http://localhost:8080/druid
结果:
![](https://i-blog.csdnimg.cn/blog_migrate/ae65c98bbf5b6a0445ce7f534f051092.png)