项目中有时不止要使用一个数据库,今天就记录一下在pringboot项目中配置多个数据源,进行动态切换
首先看配置文件
spring.datasource.db01.jdbc-url=jdbc:mysql://localhost:3306/xx?characterEncoding=UTF-8&useSSL=false&serverTimezone=CTT
#spring.datasource.url=jdbc:mysql://localhost:3306/guangfucloud?characterEncoding=UTF-8&useSSL=false&serverTimezone=CTT
spring.datasource.db01.username=root
spring.datasource.db01.password=root
spring.datasource.db01.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.db01.connectionTimeout=40000
spring.datasource.db01.minimumIdle=5
spring.datasource.db01.maximumPoolSize=10
spring.datasource.db01.autoCommit=true
spring.datasource.db01.idleTimeout=60000
spring.datasource.db01.poolName=DatebookHikariCP
spring.datasource.db01.maxLifetime=260000
spring.datasource.db02.jdbc-url=jdbc:mysql://localhost:3306/yy?characterE