java的多数据源配置

1.pom依赖

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.28</version>
</dependency>
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.3.1</version>
</dependency>
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
    <version>3.3.1</version>
</dependency>

2.配置文件

spring:
  datasource:
    dynamic:
      primary: master #设置默认的数据源或者数据源组,默认值即为master
      strict: false #严格匹配数据源,默认false. true未匹配到指定数据源时抛异常,false使用默认数据源
      datasource:
        master:
          url: jdbc:mysql://localhost:3306/demo_01?useSSL=false&serverTimezone=GMT%2B8&characterEncoding=UTF-8
          username: root
          password: xxx
          driver-class-name: com.mysql.cj.jdbc.Driver # 3.2.0开始支持SPI可省略此配置
        slave:
          url: jdbc:mysql://localhost:3306/demo_02?useSSL=false&serverTimezone=GMT%2B8&characterEncoding=UTF-8
          username: root
          password: xxx
          driver-class-name: com.mysql.cj.jdbc.Driver

3.在需要切换数据源的serviceimpl类上加@DS注解,主数据源默认设置不用加

4.如果在加了@Transactional注解的类上调用加了@DS注解的类里的方法,需要在实体类上指明是那个库里的那张表

@TableName("schema_business.business_table")

或者

@Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRES_NEW)