druid mysql yml_SpringBoot-配置Druid-yml方式

1.首先导入依赖

1.8

5.1.47

1.1.14

org.springframework.boot

spring-boot-starter

org.springframework.boot

spring-boot-starter-test

test

org.junit.vintage

junit-vintage-engine

org.springframework.boot

spring-boot-starter-jdbc

org.springframework.boot

spring-boot-starter-web

mysql

mysql-connector-java

${mysql.version}

com.alibaba

druid-spring-boot-starter

${druid.version}

2.application.yml配置文件

spring:

datasource:

url: jdbc:mysql://ip:port/dbname?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false

username: root

password: password

driver-class-name: com.mysql.jdbc.Driver

type: com.alibaba.druid.pool.DruidDataSource

druid:

#初始化大小

initialSize: 5

#最小值

minIdle: 5

#最大值

maxActive: 20

#最大等待时间，配置获取连接等待超时，时间单位都是毫秒ms

maxWait: 60000

#配置间隔多久才进行一次检测，检测需要关闭的空闲连接

timeBetweenEvictionRunsMillis: 60000

#配置一个连接在池中最小生存的时间

minEvictableIdleTimeMillis: 300000

validationQuery: SELECT 1 FROM DUAL

testWhileIdle: true

testOnBorrow: false

testOnReturn: false

poolPreparedStatements: true

# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，

#'wall'用于防火墙，SpringBoot中没有log4j，我改成了log4j2

filters: stat,wall,log4j2

#最大PSCache连接

maxPoolPreparedStatementPerConnectionSize: 20

useGlobalDataSourceStat: true

# 通过connectProperties属性来打开mergeSql功能；慢SQL记录

connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

# 配置StatFilter

web-stat-filter:

#默认为false，设置为true启动

enabled: true

url-pattern: "/*"

exclusions: "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*"

#配置StatViewServlet

stat-view-servlet:

url-pattern: "/druid/*"

#允许那些ip

allow: 127.0.0.1

login-username: admin

login-password: 123456

#禁止那些ip

deny: 192.168.1.102

#是否可以重置

reset-enable: true

#启用

enabled: true

3.然后输入你配置的url、账号、密码进入这里(比如输入http://localhost:8080/druid)