SpringBoot2.0+与Mybatis-puls整合多数据源（dynamic-datasource-spring-boot-starter）

写在前面

在我们的项目中不可避免有时候和第三方对接中需要接入多数据源，一般来讲我们大多数是采用AOP方式去动态的调整数据源，也有通过Druid去配置主从数据源的，本篇文章主要介绍多个数据源分开使用的情况，我们采用的苞米豆团队的dynamic-datasource-spring-boot-starter 去实现多数据源

代码实现部分如下

首先贴出我们的entity，Service，

UserEntity

package org.wuyd.testdockgame.entity;

import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Builder;
import lombok.Data;
import java.io.Serializable;

/**
 * @author wuyd
 * 2019/7/11 10:33
 */
@Data
@Builder
@TableName("user")
public class UserEntity implements Serializable {
    @TableId("id")
    private Integer id;
    private String age;
    private String name;
    private String password;
    private String sex;
}

UserMapper

package org.wuyd.testdockgame.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.wuyd.testdockgame.entity.UserEntity;

/**
 * @author wuyd
 * 2019/7/11 10:40
 */
@Mapper
public interface  UserMapper extends BaseMapper<UserEntity> {
}

UserService

package org.wuyd.testdockgame.service;

import com.baomidou.mybatisplus.extension.service.IService;
import org.wuyd.testdockgame.entity.UserEntity;

/**
 * @author wuyd
 * 2019/7/11 10:42
 */
public interface UserService extends IService<UserEntity> {
}

两个实现类，不同数据源的UserServiceImpl

package org.wuyd.testdockgame.service.impl;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;
import org.wuyd.testdockgame.entity.UserEntity;
import org.wuyd.testdockgame.mapper.UserMapper;
import org.wuyd.testdockgame.service.UserService;

/**
 * @author wuyd
 * 2019/7/11 10:43
 */
@Service("userService1")
public class UserService1Impl extends ServiceImpl<UserMapper, UserEntity> implements UserService {
}

package org.wuyd.testdockgame.service.impl;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;
import org.wuyd.testdockgame.entity.UserEntity;
import org.wuyd.testdockgame.mapper.UserMapper;
import org.wuyd.testdockgame.service.UserService;

/**
 * @author wuyd
 * 2019/7/11 10:43
 */
@DS("db2")
@Service("userService2")
public class UserService2Impl extends ServiceImpl<UserMapper, UserEntity> implements UserService {
}

1.不用Druid的情况下

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.6.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>org.wuyd</groupId>
    <artifactId>test-dock-game</artifactId>
    <version>0.0.1</version>
    <packaging>war</packaging>
    <name>test-dock-game</name>
    <description>测试用项目</description>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.1.0</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
            <version>2.4.2</version>
        </dependency>

        <dependency>
            <groupId>p6spy</groupId>
            <artifactId>p6spy</artifactId>
            <version>3.8.0</version>
        </dependency>
    </dependencies>

</project>

配置文件

spring:
  datasource:
    p6spy: true
    dynamic:
      datasource:
        master:
          username: root
          password: 
          driver-class-name: com.mysql.jdbc.Driver
          url: jdbc:mysql://localhost:3306/test1?characterEncoding=utf8&useSSL=true
        db2:
          username: root
          password: 
          driver-class-name: com.mysql.jdbc.Driver
          url: jdbc:mysql://localhost:3306/test2?characterEncoding=utf8&useSSL=true

2.看结果

E:\dev\Java\jdk8\bin\java.exe -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:63232,suspend=y,server=n -XX:TieredStopAtLevel=1 -noverify -Dspring.profiles.active=dev -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -javaagent:C:\Users\wuyd.wuyd\.IntelliJIdea2019.1\system\captureAgent\debugger-agent.jar -Dfile.encod