SpringBoot整合Druid

首先介绍一下Druid

整合过程！

1、首先引入maven依赖

<!-- https://mvnrepository.com/artifact/com.alibaba/druid --> <!--引入druid数据源--> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.8</version> </dependency>

2、在yml或者properties中配置druid属性（此处给出了全部的属性配置）

spring: datasource: username: root password: **** url: jdbc:mysql://192.111.111.111/JDBC driver-class-name: com.mysql.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，去掉后监控界面sql无法统计，'wall'用于防火墙 filters: stat,wall,log4j maxPoolPreparedStatementPerConnectionSize: 20 useGlobalDataSourceStat: true connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

3、编写config文件

@Configuration public class DruidConfig { // 配置yml属性 @ConfigurationProperties(prefix = "spring.datasource") @Bean public DataSource druid(){ return new DruidDataSource(); } // 配置监控 // 1、配置一个管理后台的servlet @Bean public ServletRegistrationBean statViewServlet(){ ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*"); Map<String,String> initParams = new HashMap<>(); initParams.put("loginUsername","admin"); initParams.put("loginPassword","111111"); initParams.put("allow","localhost");// 默认允许所有 // initParams.put("deny","111111"); bean.setInitParameters(initParams); return bean; } // 2、配置一个filter @Bean public FilterRegistrationBean webStatFilter(){ FilterRegistrationBean bean = new FilterRegistrationBean(); bean.setFilter(new WebStatFilter()); Map<String,String> initParams = new HashMap<>(); initParams.put("exclusions","*.js,*.css,/druid/*"); // initParams.put("loginPassword","111111"); // initParams.put("allow","localhost");// 默认允许所有 bean.setInitParameters(initParams); bean.setUrlPatterns(Arrays.asList("/*")); return bean; } }

配置完成。

这个时候再浏览器中输入  localhost:8080/druid/  便可以访问druid管理界面了

工具十分强大。感谢阿里爸爸