Springboot多数据源连接

搭建好Springboot+Druid+Mybatis+Oracle框架

具体创建步骤在另外一篇文章上有些写
详见：Springboot+Druid+Mybatis+Oracle整合

导入依赖

<!-- https://mvnrepository.com/artifact/com.baomidou/dynamic-datasource-spring-boot-starter -->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
    <version>3.5.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc -->
      <dependency>
          <groupId>org.xerial</groupId>
          <artifactId>sqlite-jdbc</artifactId>
          <version>3.8.11.2</version>
     </dependency>

修改yml配置文件

spring:
  mvc:
    static-path-pattern: classpath:/**
  # 配置 Oracle
  datasource:
    dynamic:
      primary: ds1   # 设置默认的数据源或者数据源组,默认值即为master,如果你主从默认下主库的名称就是
      strict: false # 严格匹配数据源，默认fasle，true未匹配到指定数据源的时候抛异常
      datasource:
        ds1:
          username: username
          password: password
          driver-class-name: oracle.jdbc.OracleDriver
          url: jdbc:oracle:thin:@127.0.0.1:1521/db1
        ds2:
          username: username
          password: password
          driver-class-name: oracle.jdbc.OracleDriver
          url: jdbc:oracle:thin:@127.0.0.1:1521/db2

如何使用

在service层方法上加上 @DS(“xxx”)注解即可指定数据库

   @DS("ds1")
    public User QueryUSerSD1(String id) {
        return userMapperSd1.GetUserDS1(id);
    }

    @DS("ds2")
    public User QueryUSerSD2(String id) {
        return userMapperSd2.GetUserDS2(id);
    }