之前看到項(xiàng)目中配置數(shù)據(jù)庫是spring.datasource.*
spring.datasource.url=jdbc:mysql://localhost:3306/***
spring.datasource.username=root
spring.datasource.password=12345678
spring.datasource.driver-class-name=
后來在自己負(fù)責(zé)的項(xiàng)目中發(fā)現(xiàn)是spring.datasource.druid.*
spring.datasource.druid.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.druid.url=jdbc:mysql://127.0.0.1:3306/***
spring.datasource.druid.username=root
spring.datasource.druid.password=12345678
后來自己搜索一下DruidDataSource數(shù)據(jù)源
添加依賴
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.20</version>
</dependency>
如果需要特定配置信息,只能使用spring.datasource.druid.*配置,具體如下:
#初始化大小
spring.datasource.druid.initial-size=5
#最大連接數(shù)
spring.datasource.druid.max-active=20
#最小連接數(shù)
spring.datasource.druid.min-idle=5
#獲取連接等待超時時間
spring.datasource.druid.max-wait=10000
spring.datasource.druid.validation-query=select 1
spring.datasource.druid.validation-query-timeout=2
spring.datasource.druid.test-on-borrow=true
spring.datasource.druid.test-on-return=true
spring.datasource.druid.test-while-idle=true
#配置監(jiān)控統(tǒng)計(jì)攔截的filters,去掉后監(jiān)控界面SQL無法統(tǒng)計(jì),‘wall’用于防火墻
spring.datasource.druid.filters= stat,wall