1.引入jar包
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>6.0.6</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>${mybatis-plus.version}</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.17</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>${dynamic-datasource.version}</version>
</dependency>
- .properties文件配置多数据
--主库
spring.datasource.dynamic.primary=aaadb --名字随便定义
spring.datasource.dynamic.datasource.reportdb.driver-class-name=
spring.datasource.dynamic.datasource.reportdb.url=
spring.datasource.dynamic.datasource.reportdb.username=
spring.datasource.dynamic.datasource.reportdb.password=
---从库
spring.datasource.dynamic.datasource.从库数据源名称.driver-class-name=
spring.datasource.dynamic.datasource.从库数据源名称.url=
spring.datasource.dynamic.datasource.从库数据源名称.username=
spring.datasource.dynamic.datasource.从库数据源名称.password=
3.Mapper文件
//主库的Mapper
@Mapper
public interface entityMapper extends BaseMapper<Entity> {
}
//从库的Mapepr
@Mapper
@DS("从库数据源名称")
public interface entityMapper extends BaseMapper<Entity> {
}