springboot配置Oracle数据库双数据源

<properties>
<druid.version>1.1.16</druid.version>
</properties>
	<!--双数据源配置-->
		<!-- Mybatis Plus -->
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-boot-starter</artifactId>
			<version>3.2.0</version>
		</dependency>

		<!-- dynamic-datasource -->
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
			<version>2.5.6</version>
		</dependency>
		<!-- druid -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid-spring-boot-starter</artifactId>
			<version>${druid.version}</version>
		</dependency>

application.yml

spring:
  # 数据源相关配置
  datasource:
    dynamic:
      # 主数据源
      primary: master
      datasource:
        # 数据源1
        master:
          url: jdbc:oracle:thin:@localhost:1521:ORCL
          type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: oracle.jdbc.OracleDriver
          username: ***
          password: ***
        # 数据源2
        db2:
          url: jdbc:oracle:thin:@localhost:1521:ORCL
          type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: oracle.jdbc.OracleDriver
          username: ***
          password: ***
      # druid 全局配置
      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-plus:
  # mapper文件路径
  mapper-locations: classpath:mapper/*/*.xml
#  # SQL日志输出
#  configuration:
#    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

启动类

DruidDataSourceAutoConfigure会注入一个DataSourceWrapper，其会在原生的spring.datasource下找url,username,password。而我们动态数据源的配置路径是变化的需要先排除

@SpringBootApplication(exclude = DruidDataSourceAutoConfigure.class)
public class MonitorApplication {

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

}

@Service
@DS("quartz")
public class TestServiceImpl {

@Autowired
  private JdbcTemplate jdbcTemplate;

  public List<Map<String, Object>> selectAll() {
    return  jdbcTemplate.queryForList("select * from user");
  }
  
  @Override
  @DS("slave_1")
  public List<Map<String, Object>> find() {
    return  jdbcTemplate.queryForList("select * from app_user");
  }
 



}

默认为主数据源，加注解可以指定到第二数据源。
可以加在服务层和mapper接口上。
最好不要同时加。