mybatis-plus配置多数据源

引入依赖

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

yml配置

spring:
  datasource:
    dynamic:
      primary: source1 #默认数据源
      datasource:
        source1:   #根据这的名字来匹配数据源
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://localhost:3307/mybatisdb?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false
          username: root
          password: 123456
        source2:   #根据这的名字来匹配数据源
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://localhost:3307/mybatisdbfoll?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false
          username: root
          password: 123456

启动类

@MapperScan("com.springboot.mybatis.dao") //包扫描

dao

public interface UserDao extends BaseMapper<User> {
}

service

@DS("source1") //在service层使用；在方法和类上， 同时存在时方法优先于类
@Service
@Transactional
public class UserServiceImpl implements UserService {
    @Resource
    UserDao userDao;

    @Override
    public User selectUserById(Integer id) {
        User user =userDao.selectById(id);
        return user;
    }

    @Override
    @DS("source2") //数据源2 source2
    public User selectUserById2(Integer id) {
        User user =userDao.selectById(id);
        return user;
    }
}

测试类

@SpringBootTest
public class UserServiceTest {
    @Resource
    UserService userService;

    @Test
    public void test1(){
        User user1 = userService.selectUserById(1);
        User user2 = userService.selectUserById2(1);
        System.out.println("数据源1："+user1);
        System.out.println("数据源2："+user2);
    }
}

查询结果

数据源1：User(id=1, name=zs1, account=1111111, password=123456, phone=11111111111, email=1111111@163.com, state=0)
数据源2：User(id=1, name=zs1-foll, account=1111111, password=123456, phone=11111111111, email=1111111@163.com, state=0)