一、配置pom.xml文件
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>3.5.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.29</version>
</dependency>
二、apploaction.yml 配置文件
spring:
datasource:
dynamic:
primary: master
strict: false
datasource:
master: #第一个主数据库
url: jdbc:mysql://127.0.0.1:3306/ceshi_one?characterEncoding=UTF8&autoReconnect=true&serverTimezone=GMT&allowMultiQueries=true
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: root
master1: #第二个数据源
url: jdbc:mysql://127.0.0.1:3306/ceshi_two?characterEncoding=UTF8&autoReconnect=true&serverTimezone=GMT&allowMultiQueries=true
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: root
三、使用方法
第一个数据库源
@DS("master")
@Override
public Spadmin findOne() {
QueryWrapper<Spadmin> objectQueryWrapper = new QueryWrapper<>();
objectQueryWrapper.eq("id",1);
return spadminMapper.selectOne(objectQueryWrapper);
}
第二个数据源
@DS("master1")
@Override
public Spadmin findOne() {
QueryWrapper<Spadmin> objectQueryWrapper = new QueryWrapper<>();
objectQueryWrapper.eq("id",1);
return spadminMapper.selectOne(objectQueryWrapper);
}