5步配置Springboot+Mybatisplus+druid 实现配置多数据源

在做springboot项目中，会用到多个库，借助于druid连接池实现配置多个数据库表 

1.pom文件

<?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>

    <groupId>bj.cy.aj</groupId>
    <artifactId>Workpase</artifactId>
    <version>1.0-SNAPSHOT</version>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.1.RELEASE</version>
    </parent>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.11</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-core</artifactId>
            <version>3.4.3.1</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.56</version>
        </dependency>
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.5</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.3</version>
        </dependency>

        <!--mybatis-plus扩展包-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-extension</artifactId>
            <version>3.4.3.1</version>
        </dependency>

        <!-- MybatisPlus 多数据源自动装配 -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>


        <!-- Druid自动装配 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.21</version>
        </dependency>

    </dependencies>
</project>

2.在yml文件中配置

server:
    port: 8081


## druid连接池配置
spring:
    datasource:
        dynamic:
            #默认数据源
            primary: master
            datasource:
                # 主库配置 master
                master:
                    username: root
                    password: xxxx
                    driver-class-name: com.mysql.cj.jdbc.Driver
                    url: xxxxxxxxxxxxxxxxxxxxxxxx
                    initial-size: 1
                    max-active: 10
                    min-idle: 1
                    max-wait: 60000
                    pool-prepared-statements: true
                    max-pool-prepared-statement-per-connection-size: 5
                    time-between-eviction-runs-millis: 60000
                    min-evictable-idle-time-millis: 300000
                    test-while-idle: true
                    test-on-borrow: false
                    test-on-return: false
                    stat-view-servlet:
                        enabled: true
                        url-pattern: /druid/*
                    filter:
                        stat:
                            log-slow-sql: true
                            slow-sql-millis: 1000
                            merge-sql: false
                        wall:
                            config:
                                multi-statement-allow: true
                # 从库配置 slave
                slave:
                    username: root
                    password: root
                    driver-class-name: com.mysql.cj.jdbc.Driver
                    url: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
                    initial-size: 1
                    max-active: 10
                    min-idle: 1
                    max-wait: 60000
                    pool-prepared-statements: true
                    max-pool-prepared-statement-per-connection-size: 5
                    time-between-eviction-runs-millis: 60000
                    min-evictable-idle-time-millis: 300000
                    test-while-idle: true
                    test-on-borrow: false
                    test-on-return: false
                    stat-view-servlet:
                        enabled: true
                        url-pattern: /druid/*
                    filter:
                        stat:
                            log-slow-sql: true
                            slow-sql-millis: 1000
                            merge-sql: false
                        wall:
                            config:
                                multi-statement-allow: true

3.新建  DataSourceContextHolder类

package bj.cy.aj.Config;

/**
 * @desc  建立DataSourceContextHolder类
 */
public class DataSourceContextHolder {
    private static final ThreadLocal<String> contextHolder = new InheritableThreadLocal<String>();

    /**
     *  设置数据源
     * @param db
     */
    public static void setDataSource(String db){
        contextHolder.set(db);
    }

    /**
     * 取得当前数据源
     * @return
     */
    public static String getDataSource(){
        return contextHolder.get();
    }

    /**
     * 清除上下文数据
     */
    public static void clear(){
        contextHolder.remove();
    }
}

4.主库和从库已经配置好了

如果想在service中切换数据库使用注解

@DS("slave")

即可切换数据库

5.在启动注解配置

@SpringBootApplication(exclude = DruidDataSourceAutoConfigure.class)