JAVA多数据源配置

1 pom依赖

<!--oracle驱动-->
<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.3</version>
</dependency>

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

2 application.yml 数据源配置 dynamic

datasource:

    dynamic:
        primary: dm
        strict: false
        datasource:
            dm:
                url: jdbc:dm://{ip}:{端口}/
                username: ***
                password: ***
                driver-class-name: dm.jdbc.driver.DmDriver

            oracle:
                url: jdbc:oracle:thin:@{ip}:{端口}:ORCL
                username: ***
                password: ***
                driver-class-name: oracle.jdbc.OracleDriver

3 在引用第二数据源的Mapper接口添加 @DS("引用数据源名称")

@Mapper
@DS("oracle")
public interface Mapper {}