1. pom.xml添加依赖
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>2.5.4</version>
</dependency>
2.application.yml配置
spring:
datasource:
dynamic:
hikari:
connection-timeout: 30000
max-lifetime: 1800000
max-pool-size: 2
min-idle: 1
connection-test-query: select 1
pool-name: FebsHikariCP
primary: base
datasource:
base:
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://10.1.255.121:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
base1:
username: root
password: 222222
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
3.在对应使用数据源的代码处加注解@DS("数据源名称")