SpringBoot整合mybatis-plus实现多数据源的动态切换且支持分页查询
1、引入Maven依赖
2、添加application.properties配置文件
3、添加DataSourceConfig配置类
4、添加DynamicDataSource配置类
5、添加DynamicDataSourceContextHolder配置类
6、应用案列
SpringBoot整合mybatis-plus实现多数据源的动态切换且支持分页查询
1、引入Maven依赖
2、添加application.properties配置文件
3、添加DataSourceConfig配置类
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus</artifactId>
<version>3.2.0</version>
</dependency>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.2.16</version>
</dependency>
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.6</version>
</dependency>
#mybatis-plus配置
mybatis-plus.mapper-locations=classpath:mapper/*Mapper.xml
mybatis-plus.type-aliases-package=com.example.domain
#多数据源的配置
# master DB properties:
spring.datasource.url=jdbc:postgresql://localhost:5432/postgres
spring.datasource.username=postgres
spring.datasource.password=postgres
spring.datasource.driver-class-name=org.postgresql.Driver
#slave DB properties
spring.datasource.master.url=jdbc:oracle:thin:@127.0.0.1:1521/orcl
spring.datasource.master.username=system
spring.datasource.master.password=system
spring.datasource.master.driver-class-name=oracle.jdbc.OracleDriver
评论0