【Mybatis-Plus】Mybatis-Plus多数据源（三）

　　参考官网：多数据源 | MyBatis-Plus (baomidou.com)

使用方法

　　1、引入dynamic-datasource-spring-boot-starter。

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
    <version>3.5.2</version>
</dependency>

　　2、配置数据源。

spring:
  datasource:
    dynamic:
      primary: master #设置默认的数据源或者数据源组,默认值即为master
      strict: false #严格匹配数据源,默认false. true未匹配到指定数据源时抛异常,false使用默认数据源
      datasource:
        master:
          url: jdbc:mysql://127.0.0.1:3306/test_mybatis_plus?allowPublicKeyRetrieval=true&useSSL=false
          username: root
          password: 123456
          driver-class-name: com.mysql.cj.jdbc.Driver
        slave_1:
          url: jdbc:mysql://127.0.0.1:3306/test_mybatis_plus2?allowPublicKeyRetrieval=true&useSSL=false
          username: root
          password: 123456
          driver-class-name: com.mysql.cj.jdbc.Driver


mybatis-plus:
  configuration:
    # 日志输出SQL
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  # mapper xml文件默认位置：classpath*:/mapper/**/*.xml
#  mapper-locations: classpath*:/mapper/**/*.xml
  # 配置类型别名对应的包
#  type-aliases-package: com.test.mybatisplus.entity

　　3、使用 @DS 切换数据源

　　　　@DS 可以注解在方法上或类上，同时存在就近原则 方法上注解 优先于 类上注解。

注解	结果
没有@DS	默认数据源
@DS("dsName")	dsName可以为组名也可以为具体某个库的名称

 

@DS("master")
public interface EmployeeMapper extends BaseMapper<Employee> {

}

@DS("slave_1")
public interface ProductMapper extends BaseMapper<Product> {

}

 

　　4、测试类

@SpringBootTest
public class SampleTest {

    @Autowired
    private EmployeeMapper employeeMapper;
    @Autowired
    private ProductMapper productMapper;


    @Test
    public void testSelectList() {
        System.out.println(("----- selectAll method test ------"));
        List<Employee> userList = employeeMapper.selectList(null);
        userList.forEach(System.out::println);
        List<Product> productList = productMapper.selectList(null);
        productList.forEach(System.out::println);
    }

}

　　5、运行测试效果

----- selectAll method test ------
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6bbab114] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@64364705 wrapping com.mysql.cj.jdbc.ConnectionImpl@4f486211] will not be managed by Spring
==>  Preparing: SELECT id,last_name,email,age FROM employee
==> Parameters: 
<==    Columns: id, last_name, email, age
<==        Row: 1, Jone, test1@baomidou.com, 18
<==        Row: 2, Jack, test2@baomidou.com, 20
<==        Row: 3, Tom, test3@baomidou.com, 28
<==        Row: 4, Sandy, test4@baomidou.com, 21
<==        Row: 5, Billie, test5@baomidou.com, 24
<==      Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6bbab114]
Employee(id=1, lastName=Jone, email=test1@baomidou.com, age=18)
Employee(id=2, lastName=Jack, email=test2@baomidou.com, age=20)
Employee(id=3, lastName=Tom, email=test3@baomidou.com, age=28)
Employee(id=4, lastName=Sandy, email=test4@baomidou.com, age=21)
Employee(id=5, lastName=Billie, email=test5@baomidou.com, age=24)
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@603cabc4] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1744457797 wrapping com.mysql.cj.jdbc.ConnectionImpl@6f347d7] will not be managed by Spring
==>  Preparing: SELECT id,name,price,version FROM t_product
==> Parameters: 
<==    Columns: id, name, price, version
<==        Row: 1, 外星人笔记本, 100, 2
<==      Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@603cabc4]
Product(id=1, name=外星人笔记本, price=100, version=2)
2024-01-19 23:29:43.903  INFO 41640 --- [ionShutdownHook] c.b.d.d.DynamicRoutingDataSource         : dynamic-datasource start closing ....
2024-01-19 23:29:43.903  INFO 41640 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : master - Shutdown initiated...
2024-01-19 23:29:43.918  INFO 41640 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : master - Shutdown completed.
2024-01-19 23:29:43.918  INFO 41640 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : slave_1 - Shutdown initiated...
2024-01-19 23:29:43.918  INFO 41640 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : slave_1 - Shutdown completed.
2024-01-19 23:29:43.918  INFO 41640 --- [ionShutdownHook] c.b.d.d.DynamicRoutingDataSource         : dynamic-datasource all closed success,bye