Druid(新版starter)在SpringBoot下的使用教程

  server.port=8080

  spring.application.name=springboot-test-exam1

  spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

  spring.datasource.driver-class-name=com.mysql.jdbc.Driver

  spring.datasource.url=jdbc:mysql://localhost:3306/databaseName?useSSL=false&characterEncoding=utf8

  spring.datasource.username=root

  spring.datasource.password=root

  spring.datasource.druid.initial-size=5

  spring.datasource.druid.min-idle=5

  spring.datasource.druid.maxActive=20

  spring.datasource.druid.maxWait=60000

  spring.datasource.druid.timeBetweenEvictionRunsMillis=60000

  spring.datasource.druid.minEvictableIdleTimeMillis=300000

  spring.datasource.druid.validationQuery=SELECT 1 FROM DUAL

  spring.datasource.druid.testWhileIdle=true

  spring.datasource.druid.testOnBorrow=false

  spring.datasource.druid.testOnReturn=false

  spring.datasource.druid.poolPreparedStatements=true

  spring.datasource.druid.maxPoolPreparedStatementPerConnectionSize=20

  spring.datasource.druid.filters=stat,wall,slf4j

  spring.datasource.druid.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

  spring.datasource.druid.web-stat-filter.enabled=true

  spring.datasource.druid.web-stat-filter.url-pattern=/*

  spring.datasource.druid.web-stat-filter.exclusions=*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*

  spring.datasource.druid.stat-view-servlet.url-pattern=/druid/*

  spring.datasource.druid.stat-view-servlet.allow=127.0.0.1,192.168.163.1

  spring.datasource.druid.stat-view-servlet.deny=192.168.1.73

  spring.datasource.druid.stat-view-servlet.reset-enable=false

  spring.datasource.druid.stat-view-servlet.login-username=admin

  spring.datasource.druid.stat-view-servlet.login-password=123456