阿里Druid连接池配置详解

1、添加依赖

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.10</version>
</dependency>

2、配置文件

spring:
  datasource:
    druid:
      url: jdbc:mysql://localhost:3306/webstore?serverTimezone=UTC
      username: root   #注意不要使用data-username和data-password
      password: 123456
      driver-class-name: com.mysql.cj.jdbc.Driver
      #开启sql语句自动加载，只认识名为： schema-all.sql和schema.sql和data-all.sql和data.sql的sql语句
  #    initialization-mode: always

      #   数据源其他配置
      initialSize: 5
      minIdle: 5
      maxActive: 20
      maxWait: 60000
      timeBetweenEvictionRunsMillis: 60000
      minEvictableIdleTimeMillis: 300000
      validationQuery: SELECT 1 FROM DUAL
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false
      poolPreparedStatements