<dependencies>
    <!-- Mybatis Plus -->
    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>最新版本</version>
    </dependency>
    
    <!-- Dynamic Datasource -->
    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
        <version>最新版本</version>
    </dependency>

    <!-- Druid -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid-spring-boot-starter</artifactId>
        <version>最新版本</version>
    </dependency>

    <!-- MySQL驅(qū)動(dòng)程序 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>最新版本</version>
    </dependency>
</dependencies>

spring:
  #數(shù)據(jù)源配置
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.cj.jdbc.Driver
    druid:
      statViewServlet:
        enabled: true
        # 設(shè)置白名單，不填則允許所有訪問(wèn)
        allow:
        url-pattern: /druid/*
        # 控制臺(tái)管理用戶名和密碼
        login-username: helloworld
        login-password: 123456
    dynamic:
      druid:
        initial-size: 10  # 連接池初始大小
        max-active: 100   # 連接池最大連接數(shù)
        min-idle: 10      # 連接池最小空閑連接數(shù)
        max-wait: 60000   # 獲取連接的最大等待時(shí)間，單位為毫秒
        pool-prepared-statements: true  # 是否緩存PreparedStatement，默認(rèn)為true
        max-pool-prepared-statement-per-connection-size: 20  # 每個(gè)連接緩存Statement的最大數(shù)目
        time-between-eviction-runs-millis: 60000  # 連接回收器運(yùn)行的時(shí)間間隔，單位為毫秒
        min-evictable-idle-time-millis: 300000  # 連接在池中最小空閑的時(shí)間，達(dá)到此值后將被移除，單位為毫秒
        test-while-idle: true   # 空閑連接檢測(cè)是否可用，默認(rèn)為true
        test-on-borrow: false   # 取連接時(shí)檢測(cè)連接是否可用，默認(rèn)為false
        test-on-return: false   # 還連接時(shí)檢測(cè)連接是否可用，默認(rèn)為false
        validationQuery: "select 1"  # 驗(yàn)證連接的SQL語(yǔ)句
        filters: stat,wall    # 連接過(guò)濾器，用于統(tǒng)計(jì)和防火墻功能
        stat:
          log-slow-sql: true  # 是否打印慢SQL日志
          slow-sql-millis: 1000  # 慢SQL的閾值時(shí)間，單位為毫秒
          merge-sql: false   # 是否合并SQL，默認(rèn)為false
        wall:
          multi-statement-allow: true  # 是否允許一次執(zhí)行多條語(yǔ)句，默認(rèn)為true
      primary: test1 #主數(shù)據(jù)源，在代碼中不指定數(shù)據(jù)源時(shí)默認(rèn)為該主數(shù)據(jù)源
      datasource:
        test1: #數(shù)據(jù)源 test1
          url: jdbc:mysql://localhost:3306/test1
          username: root
          password: root
        test2: #數(shù)據(jù)源 test2
          url: jdbc:mysql://localhost:3306/test2
          username: root
          password: root

@Mapper
public interface UserMapper extends BaseMapper<User> {
    // 定義數(shù)據(jù)庫(kù)操作方法
}

<!-- UserMapper.xml -->
<mapper namespace="com.example.mapper.UserMapper">
    <!-- 編寫(xiě)SQL語(yǔ)句 -->
</mapper>

public interface UserService extends IService<User> {
    /**
     * 從test1數(shù)據(jù)庫(kù)中獲取用戶信息
     */
    List<User> getUsersFromTest1Db() ;

    /**
     * 從test2數(shù)據(jù)庫(kù)中獲取用戶信息
     */
    List<User> getUsersFromTest2Db() ;
}

@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {

    @Autowired
    private UserMapper userMapper;

    @DS("test1") // 指定數(shù)據(jù)源為 test1
    public List<User> getUsersFromTest1Db() {
        return userMapper.selectList(null);
    }

    @DS("test2") // 指定數(shù)據(jù)源為 test2
    public List<User> getUsersFromTest2Db() {
        return userMapper.selectList(null);
    }

}

@RestController
public class UserController {

    @Autowired
    private UserService userService;

    @GetMapping("/test1-list")
    public List<User> user1List() {
        // 調(diào)用UserService的getUsersFromTest1Db方法獲取用戶列表并返回
        return userService.getUsersFromTest1Db();
    }

    @GetMapping("/test2-list")
    public List<User> user2List() {
        // 調(diào)用UserService的getUsersFromTest2Db方法獲取用戶列表并返回
        return userService.getUsersFromTest2Db();
    }

}

@MapperScan("com.hw.mapper")
@SpringBootApplication
public class HelloWorldApplication {

    public static void main(String[] args) {
        SpringApplication.run(HelloWorldApplication.class, args);
    }

}

mybatis-plus:
  # 指定 Mapper XML 文件所在路徑
  mapper-locations: classpath*:mapper/*.xml