springboot 通过注解方式配置多数据源

配置maven依赖

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

主启动类排除Druid自动配置

@SpringBootApplication(exclude = DruidDataSourceAutoConfigure.class)

yml 配置

server:
  port: 8888

spring:
  # 设置数据源

  datasource:
    dynamic:
      primary: db1 # 主数据源
      datasource:

        db1:
          type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: oracle.jdbc.OracleDriver
          url: jdbc:oracle:thin:@ip:1526:SID
          username: JIUSER
          password: JIUSER

        #1.JDBC
        db2:
          type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: oracle.jdbc.driver.OracleDriver
          url: jdbc:oracle:thin:@ip:1523:SID
          username: cimes
          password: cimes
      druid:
        initial-size: 5
        min-idle: 5
        max-active: 20
        max-wait: 60000
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 30000
        validation-query: SELECT 1 FROM DUAL
        test-while-idle: true
        test-on-borrow: true
        test-on-return: false

mybatis:
  # mapper文件路径
  mapper-locations: classpath:mapper/*.xml
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

使用非主数据源@DS(“db2”) ,主数据源不写默认就是

@Mapper
@DS("db2")
public interface SfcusnDao {


    ResoutModel selectByUsnKey(String USN);

}