依赖:
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>3.0.0</version>
</dependency>
yml配置:
spring:
datasource:
dynamic:
primary: data1 #默认主库名为data1
strict: false #不使用严格模式
datasource:
data1:
url: jdbc:mysql://127.0.0.1:3306/xxx?useSSL=false&serverTimezone=UTC&useUnicode=true&characterEncoding=utf8
username: xxx
password: xxxxxx
driver-class-name: com.mysql.cj.jdbc.Driver
data2:
url: jdbc:mysql://xxx:xxx/xxx?useSSL=false&serverTimezone=UTC&useUnicode=true&characterEncoding=utf8
username: xxx
password: xxxxxx
driver-class-name: com.mysql.cj.jdbc.Driver
上面的配置默认使用data1下的配置,如果需要使用data2下的配置,则在service实现类中添加@DS("data2") 即可,如:
@Service
@DS("data2")
public class XxServiceImpl extends ServiceImpl<XxMapper, Xx> implements XxService {
}