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