一、导入配置多数据源的相关依赖
<properties>
<dynamic-datasource.version>2.5.4</dynamic-datasource.version>
<mybatis.version>2.1.1</mybatis.version>
</properties>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>${dynamic-datasource.version}</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>${mybatis.version}</version>
</dependency>
二、编写docker-compose.yml文件
version: '3'
services:
# 主服务器
db-3310:
image: mysql:5.7.22
restart: always
container_name: db-3310
command:
--default-authentication-plugin=mysql_native_password
--character-set-server=utf8mb4
--collation-server=utf8mb4_general_ci
--explicit_defaults_for_timestamp=true
--lower_case_table_names=1
environment:
MYSQL_ROOT_PASSWORD: root
TZ: Asia/Shanghai
MYSQL_DATABASE: db_test
volumes:
- ./master/data/:/var/lib/mysql
- ./master/log/:/var/log/mysql
ports:
- 3310:3306
# 从服务器
db-3311:
image: mysql:5.7.22
restart: always
container_name: db-3311
command:
--default-authentication-plugin=mysql_native_password
--character-set-server=utf8mb4
--collation-server=utf8mb4_general_ci
--explicit_defaults_for_timestamp=true
--lower_case_table_names=1
environment:
MYSQL_ROOT_PASSWORD: root
TZ: Asia/Shanghai
MYSQL_DATABASE: db_test
volumes:
- ./slave/data/:/var/lib/mysql
- ./slave/log/:/var/log/mysql
ports:
- 3311:3306
三、Linux系统下运行docker-compose.xml文件
docker-compose.yml文件目录下执行以下命令
docker-compose up -d
生成以下容器
四、在application.yml配置文件中配置多数据源和mybatis相关配置
spring:
datasource:
dynamic:
primary: db-3310
datasource:
db-3310:
url: jdbc:mysql://47.100.57.52:3310/db_test?serverTimezone=Asia/Shanghai&characterEncoding=utf8
username: root
password: root
driver-class-name: com.mysql.cj.jdbc.Driver
db-3311:
url: jdbc:mysql://47.100.57.52:3311/db_test?serverTimezone=Asia/Shanghai&characterEncoding=utf8
username: root
password: root
driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
mapper-locations: classpath:mapper/**/*.xml
五、通过MybatisPlus插件逆向生成实体类(entity)、接口(mapper)、mapper.xml映射文件
六、编写Service层和实现类ServiceImpl,在方法或者类上使用@DS注解指定这个方法作用哪个数据库
package com.qf.zsm.springbootdynamicdatasource.service.impl;
import com.baomidou.dynamic.datasource.annotation.DS;
import com.qf.zsm.springbootdynamicdatasource.entity.Test;
import com.qf.zsm.springbootdynamicdatasource.mapper.TestMapper;
import com.qf.zsm.springbootdynamicdatasource.service.TestService;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import javax.annotation.Resource;
@Service
public class TestServiceImpl implements TestService {
@Resource
TestMapper testMapper;
@DS("db-3310")
@Override
@Transactional
public int addTest() {
Test test = new Test();
test.setName("张顺民");
int column = testMapper.insert(test);
return column;
}
@DS("db-3311")
public int addTest2(){
Test test = new Test();
test.setName("无间道");
int column = testMapper.insert(test);
return column;
}
}
七、生成测试类
package com.qf.zsm.springbootdynamicdatasource.service.impl;
import com.qf.zsm.springbootdynamicdatasource.service.TestService;
import lombok.extern.slf4j.Slf4j;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import javax.annotation.Resource;
@SpringBootTest
@Slf4j
class TestServiceImplTest {
@Resource
TestService testService;
@Test
void addTest() {
int i = testService.addTest();
log.info("受影响的行数:{}",i);
}
@Test
void addTest2() {
int i = testService.addTest2();
log.info("受影响的行数:{}",i);
}
}
测试结果:
同一个实现类ServiceImpl中的方法成功操作不同的数据库!