1、配置application.yml
spring:
datasource:
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,去掉后监控界面 sql 无法统计,'wall'用于防火墙
#配置监控统计拦截的filter,stat:监控统计,log4j:日志统计 wall:防御sql注入
#如果允许是报错:java.lang.ClassNotFoundException:org.apache.Log4j.Priority
#导入log4j 依赖即可
filters: stat,wall,slf4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
Maven依赖
<dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.22</version> </dependency>
2、配置druidConifg Java配置类
@Configuration public class DruidConfig { //将自定义的 Druid数据源添加到容器中,不再让 Spring Boot 自动创建 @ConfigurationProperties(prefix = "spring.datasource") @Bean public DataSource druidDataSource() { return new DruidDataSource(); } //配置 Druid 监控管理后台的Servlet; @Bean public ServletRegistrationBean statViewServlet() { //配置/druid/*请求 StatViewServlet中可查看参数 ServletRegistrationBean<StatViewServlet> bean = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*"); //设置初始化参数值 Map<String, String> initParam = new HashMap<>(); //配置登录用户名 initParam.put(StatViewServlet.PARAM_NAME_USERNAME, "root"); //配置登录密码 initParam.put(StatViewServlet.PARAM_NAME_PASSWORD, "1234"); //如果不写,则默认所有ip都可以访问 initParam.put(StatViewServlet.PARAM_NAME_ALLOW, ""); //禁止访问的IP地址 initParam.put(StatViewServlet.PARAM_NAME_DENY, "192.168.1.1"); //设置初始化参数 bean.setInitParameters(initParam); return bean; } /**2、 * //配置 Druid 监控 之 web 监控的 filter * **/ @Bean public FilterRegistrationBean webStatFilter(){ FilterRegistrationBean beanFilter = new FilterRegistrationBean(); beanFilter.setFilter(new WebStatFilter()); //exclusions:设置哪些请求进行过滤排除掉,从而不进行统计 Map<String,String> initParams = new HashMap<>(); initParams.put("exclusions","*.js,*.css,/druid/*"); beanFilter.setInitParameters(initParams); //"/*" 表示过滤所有请求 beanFilter.setUrlPatterns(Arrays.asList("/*")); return beanFilter; } }
3、查看
http://localhost:8080/druid/