一、Springboot使用Durid快速开始

1、 添加依赖

<!--druid连接池-->
<dependency><groupId>com.alibaba</groupId><artifactId>druid-spring-boot-starter</artifactId><version>1.1.17</version>
</dependency>
<!--集成mysql数据库-->
<dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.38</version>
</dependency>
<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-configuration-processor</artifactId><optional>true</optional>
</dependency>

2、添加配置项

(1) durid连接池配置

spring:# 数据库配置datasource:username: ${database.username}password: ${database.password}url: ${database.url}driver-class-name: ${database.dirver}type: com.alibaba.druid.pool.DruidDataSource## 方式一：durid配置druid:initial-size: 5min-idle: 5max-active: 20max-wait: 60000# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒time-between-eviction-runs-millis: 60000# 配置一个连接在池中最小生存的时间，单位是毫秒min-evictable-idle-time-millis: 300000# 启动时验证数据库是否链接validation-query: SELECT 1 FROM DUAL# 连接池声明式预编译 pool-prepared-statements: true#   配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙max-pool-prepared-statement-per-connection-size: 20filters: stat,walluse-global-data-source-stat: true# 通过connectProperties属性来打开mergeSql功能；慢SQL记录connect-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000# 配置统计监控stat-view-servlet:login-username: adminlogin-password: 123456reset-enable: falseurl-pattern: /druid/* allow: 182.168.0.1 # 添加IP白名单deny: 192.168.0.1 # 添加IP黑名单# 配置统计监控web-stat-filter:  # 通过：http://localhost:8888/druid/login.html进入拦截界面url-pattern: /*  # 添加过滤规则exclusions: "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"  # 忽略过滤格式