Pom文件引入相关jar,此处不再赘述,问百度。
application.properties:
spring.datasource.business.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.business.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.business.url =数据库地址
spring.datasource.business.username=账户
spring.datasource.business.password=密码
spring.datasource.business.initialSize=5
spring.datasource.business.minIdle=5
spring.datasource.business.maxActive=20
spring.datasource.business.maxWait=60000
spring.datasource.business.timeBetweenEvictionRunsMillis=60000
spring.datasource.business.minEvictableIdleTimeMillis=300000
spring.datasource.business.validationQuery=SELECT 1 FROM DUAL
spring.datasource.business.testWhileIdle=true
spring.datasource.business.testOnBorrow=false
spring.datasource.business.testOnReturn=false
spring.datasource.business.poolPreparedStatements=true
spring.datasource.business.maxPoolPrepare