第一步：pom中添加依賴
<!--mybatis多數據源--><dependency><groupId>com.baomidou</groupId><artifactId>dynamic-datasource-spring-boot-starter</artifactId><version>2.5.6</version></dependency>第二步：配置application-dev.yml
spring:datasource:type: com.alibaba.druid.pool.DruidDataSourcedynamic:primary: mysql_sa #配置主數據源datasource:mysql_sa: # 數據源的名字，第一個數據源url: jdbc:mysql://localhost:3306/xxx?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghaiusername: xxxpassword: xxxdriver-class-name: com.mysql.cj.jdbc.Drivermysql_se: # 數據源的名字，第二個數據源url: jdbc:mysql://localhost:3306/xxxx?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghaiusername: xxxxpassword: xxxxdriver-class-name: com.mysql.cj.jdbc.Driverdruid:initial-size: 1max-active: 20min-idle: 1max-wait: 60000# 去除一下durid的自動裝配autoconfigure:exclude: org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration #去除Druid自動配置
第三步：修改啟動類
@SpringBootApplication(exclude = DruidDataSourceAutoConfigure.class)
public class xxxApplication {public static void main(String[] args) {SpringApplication.run(xxxApplication.class, args);}}第四步：使用@DS注解在Dao層指定數據庫
@Mapper
@DS("mysql_se")
public interface xxxDao extends BaseMapper<xxxEntity> {}
)
