高级配置Druid
1、引入Druid依赖
<dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.13</version> </dependency>
2、Druid全局配置
spring: datasource: username: root password: 123456 #使用MySQL连接驱动8.0以上版本,需要在url后面加上时区设置,GMT%2B8代表中国时区 url: jdbc:mysql://localhost:3306/caiyuanzi?serverTimezone=GMT%2B8 #新版本驱动包,使用com.mysql.cj.jdbc.Driver 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,logback maxPoolPreparedStatementPerConnectionSize: 20 useGlobalDataSourceStat: true connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
3、自定义配置类,将配置中的属性与DruidDataSource属性绑定
配置Druid监控