SpringbootDruid阿里巴巴druid连接池配置

• 引入依赖

	com.alibaba

	druid-spring-boot-starter

	1.1.20



 





	log4j

	log4j

	1.2.17

• yml配置

#配置数据源的属性

spring:

  datasource:

    druid:

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

      url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=true&serverTimezOne=UTC

      username: root

      password: 123456

      max-active: 20

      max-wait: 5000

      initial-size: 1

      filters: stat,log4j,wall

      validationQuery: SELECT "x"   #验证连接

      enable: true

   #监控配置

      stat-view-servlet:

        enabled: true

        login-username: root

        login-password: 123456

        allow:

        deny:

        url-pattern: /druid/*

#      web-stat-filter:

#        enabled: true

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