<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.2.2</version>
</dependency>
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
    <version>3.5.1</version>
</dependency>

spring:
  application:
    name: quartz
  datasource:
    dynamic:
      #設(shè)置默認的數(shù)據(jù)源或者數(shù)據(jù)源組
      primary: system 
      strict: false
      datasource:
        system:
          driverClassName: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://127.0.0.1:3307/system?useUnicode=true&useSSL=false&zeroDateTimeBehavior=convertToNull&characterEncoding=UTF-8&allowMultiQueries=true&serverTimezone=Asia/Shanghai
          username: root
          password: lhzlx
        log:
          driverClassName: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://127.0.0.1:3307/log?useUnicode=true&useSSL=false&zeroDateTimeBehavior=convertToNull&characterEncoding=UTF-8&allowMultiQueries=true&serverTimezone=Asia/Shanghai
          username: root
          password: lhzlx
    # hikari連接池
    type: com.zaxxer.hikari.HikariDataSource
    hikari:
      #最大連接數(shù)，小于等于0會被重置為默認值10；大于零小于1會被重置為minimum-idle的值
      maximum-pool-size: 10
      #最小空閑連接，默認值 10，小于0或大于maximum-pool-size，都會重置為maximum-pool-size
      minimum-idle: 2
      #連接超時時間:毫秒，小于250毫秒，否則被重置為默認值30秒
      connection-timeout: 60000
      #空閑連接超時時間，默認值600000ms（10分鐘），大于等于max-lifetime且max-lifetime>0，會被重置為0；
      #不等于0且小于10秒，會被重置為10秒。
      #只有空閑連接數(shù)大于最大連接數(shù)且空閑時間超過該值，才會被釋放(自動釋放過期鏈接)
      idle-timeout: 600000
      #連接最大存活時間.不等于0且小于30秒，會被重置為默認值30分鐘.設(shè)置應(yīng)該比mysql設(shè)置的超時時間短
      max-lifetime: 640000
      #連接測試查詢
      connection-test-query: SELECT 1
#mapper 別名掃描
mybatis:
  mapper-locations: classpath*:mappers/*.xml
  type-aliases-package: com.lhz.demo.model.entity
  #數(shù)據(jù)庫類型
  configuration.database-id: mysql
  #自動駝峰轉(zhuǎn)換
  configuration.map-underscore-to-camel-case: true

@Mapper
public interface LogMapper {
    List<TbLog> selectAll();
}

@Mapper
@DS("log")
public interface SysMapper {
    List<TbSystem> selectAll();
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lhz.demo.mapper.LogMapper">
    <select id="selectAll" resultType="com.lhz.demo.model.entity.TbLog">
        select * from tb_log
    </select>
</mapper>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lhz.demo.mapper.SysMapper">
    <select id="selectAll" resultType="com.lhz.demo.model.entity.TbSystem">
        select * from tb_system
    </select>
</mapper>

@Service
public class TestService {

    @Resource
    private SysMapper sysMapper;

    @Resource
    private LogMapper logMapper;

    /**
     * 不指定數(shù)據(jù)源，模式使用system數(shù)據(jù)源
     * @return
     */
    public Object sys() {
        return sysMapper.selectAll();
    }


    /**
     * 指定數(shù)據(jù)源查詢
     * @return
     */
    @DS("log")
    public Object log() {
        return logMapper.selectAll();
    }
}

@RestController
@RequestMapping("/test")
@Slf4j
public class TestController {

    @Resource
    private TestService testService;

    /**
     * 查詢system庫
     * @return
     */
    @GetMapping("/sys")
    public Object sys() {
        return testService.sys();
    }


    /**
     * 查詢log庫
     * @return
     */
    @GetMapping("/log")
    public Object log() {
        return testService.log();
    }
}

啟動項目分別訪問`http://localhost:9090/test/sys`與`http://localhost:9090/test/log`均有數(shù)據(jù)輸出，則表示配置成功；