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>
修改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);
}