SpringBoot2.3+Mybatis+Mysql多数据源配置

最近在做一个SpringBoot项目时需要关联两个数据库，于是乎我就研究了下关于springboot的多数据源配置，记录配置过程，分享一下

一、基础配置

（这里只展示主要配置）

1. JDK1.8
2. springBoot2.3.4.RELEASE
3. mybatis2.1.0
4. mysql-connector-java 8.0.21
5. maven仓库设置阿里云镜像
   
   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 https://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.3.4.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.zxy.wyn</groupId>
    <artifactId>mutipart-DataSource</artifactId>
    <version>v1.0</version>
    <name>mutipart-DataSource</name>
    <description>多数据源项目案例</description>

    <properties>
        <java.version>1.8</java.version>
        <mybatis.version>2.1.0</mybatis.version>
        <fastjson.version>1.2.60</fastjson.version>
        <collections4.version>4.1</collections4.version>
    </properties>

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

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>

        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>${mybatis.version}</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>${fastjson.version}</version>
        </dependency>

        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-collections4</artifactId>
            <version>${collections4.version}</version>
        </dependency>

    </dependencies>

    <build>
        <finalName>Mutipart-DataSource</finalName>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
            <plugin>
                <artifactId>maven-compiler-plugin</artifactId>
                <configuration>
                    <target>${java.version}</target>
                    <source>${java.version}</source>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

二、yml文件中的datasource配置

server:
  port: 80

spring:
  datasource:
    sys:
      # 多个路径，可以通过逗号分开，如classpath:mapper/sys/*.xml,classpath:mapper/bus/*.xml
      mapper-locations: classpath:mapper/sys/*.xml
      driver-class-name: com.mysql.cj.jdbc.Driver
      jdbc-url: jdbc:mysql://127.0.0.1:3306/user-center?characterEncoding=utf-8&useSSL=false
      username: root
      password: 123456
    file:
      # 多个路径，可以通过逗号分开，如classpath:mapper/sys/*.xml,classpath:mapper/bus/*.xml
      mapper-locations: classpath:mapper/file/*.xml
      driver-class-name: com.mysql.cj.jdbc.Driver
      jdbc-url: jdbc:mysql://127.0.0.1:3306/file-center?characterEncoding=utf-8&useSSL=false
      username: root
      password: 123456

logging:
  level:
    com.xzz.wyy: debug
  file:
    path: d:/log/mutipart/

这里要注意两个关键字： jdbc-url***和***driver-class-name
另外，我将mapper配置文件地址，放在mapper-locations中，通过@Value动态获取

三、撸代码

1. 创建datasourceConfig

创建BasicDataSourceConfig，加入公共方法

创建SysDataSourceConfig

创建FileDataSourceConfig：

2. 项目结构及数据库结构展示

3.接口调用效果

http://localhost/fileSettings
调用file-center数据库的file_bucket_setting表，查询结果：

http://localhost/users
调用user-center数据库的sys-user表，查询结果：

四、总结

以上只把核心代码展示出来，如果想参考源码，请点击此处下载代码样例
另外数据库请参考resource/sql中的样例