mybatisplus多数据源配置

参考&＃xff1a;MybatisPlus 配置多源数据库

<dependency><groupId>mysqlgroupId><artifactId>mysql-connector-javaartifactId><version>5.1.37version><scope>runtimescope>dependency><dependency><groupId>org.postgresqlgroupId><artifactId>postgresqlartifactId><scope>runtimescope>dependency><dependency><groupId>com.baomidougroupId><artifactId>dynamic-datasource-spring-boot-starterartifactId><version>3.0.0version>dependency><dependency><groupId>com.baomidougroupId><artifactId>mybatis-plus-boot-starterartifactId><version>3.3.2version>dependency>

spring:datasource:dynamic:primary: master #设置默认的数据源或者数据源组,默认值即为masterstrict: false #设置严格模式,默认false不启动. 启动后在未匹配到指定数据源时候回抛出异常,不启动会使用默认数据源.datasource:master:url: jdbc:mysql://127.0.0.1:3306/hikari-cloud?useUnicode&＃61;true&characterEncoding&＃61;UTF-8&useLegacyDatetimeCode&＃61;false&serverTimezone&＃61;GMT%2B8username: xxxxxpassword: xxxxxdriver-class-name: com.mysql.jdbc.Driverhikari:max-lifetime: 60000slave_1:url: jdbc:mysql://127.0.0.1:3306/ms-test?useUnicode&＃61;true&characterEncoding&＃61;UTF-8&useLegacyDatetimeCode&＃61;false&serverTimezone&＃61;GMT%2B8username: xxxxxpassword: xxxxxdriver-class-name: com.mysql.jdbc.Driverhikari:max-lifetime: 60000mybatis-plus:mapper-locations: classpath:mapper/*.xmltype-aliases-package: com.hikari.cloud.data.entity

这样就配置完了&＃xff0c;只需要在调用的mapper添加&＃64;DS(“数据库名”)进行指定数据库的查询&＃xff0c;主数据库不需要配置

&＃64;Repository
&＃64;Mapper
&＃64;DS("slave_1")
public interface db2Mapper extends BaseMapper<db2> {}