springboot配置多資料庫

#資料源配置
jdbc:
  #系統庫
  master:
    host: *
    port: *
    db: *
    user: *
    passwd: *
  slave:
    host: *
    port: *
    db: *
    user: *
    passwd: *
  #格式化SQL語句（true：開啟[有性能損失]，false：關閉）
  p6spy: true
           

spring:
  #啟動banner
  banner:
    location: classpath:config/banner.txt
  #預設配置檔案
  profiles:
    active: dev
  servlet:
    multipart:
      #檔案上傳大小設定
      enabled: true
      max-file-size: 1024MB
      max-request-size: 1024MB
  #熱部署
  devtools:
    restart:
      enabled: false
  #排除DruidDataSourceAutoConfigure類
  autoconfigure:
    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
  #資料源
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      stat-view-servlet:
        loginUsername: admin
        loginPassword: Ppnn13y
      initial-size: 3
      max-active: 8
      min-idle: 1
      max-wait: 6000
      min-evictable-idle-time-millis: 30000
      max-evictable-idle-time-millis: 30000
      time-between-eviction-runs-millis: 60000
      validation-query: select 1
      validation-query-timeout: -1
      test-on-borrow: false
      test-on-return: false
      test-while-idle: true
      pool-prepared-statements: true
      filters: stat,wall
    dynamic:
      #預設資料庫
      primary: master
      #格式化SQL語句（true：開啟[有性能損失]，false：關閉）
      p6spy: ${jdbc.p6spy}
      datasource:
        master:
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://${jdbc.master.host}:${jdbc.master.port}/${jdbc.master.db}?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
          username: ${jdbc.master.user}
          password: ${jdbc.master.passwd}
        slave:
          driver-class-name: oracle.jdbc.driver.OracleDriver
          url: jdbc:oracle:thin:@//${jdbc.slave.host}:${jdbc.slave.port}/${jdbc.slave.db}
          username: ${jdbc.slave.user}
          password: ${jdbc.slave.user}
           

@DS("slave")
@Override
public List<V3Apmsg> findV3ApmsgList(String queryDate,String limit) {
    return v3ApmsgMapper.selectData(DateUtils.toDate(queryDate,DateUtils.YYYY_MM_DD_HH_MM_SS),limit);
}
           

https://www.cnblogs.com/aizen-sousuke/p/11756279.html