Springboot-多数据源的配置(MybatisPlus官方提供的方式)

一、导入配置多数据源的相关依赖

    <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中的方法成功操作不同的数据库!