springboot+mybtis 多数据源配置

很多时候我们都需要进行多数据源的配置，但是springboot提供的是单数据源配置。
下面描述的是按分包方式区分不同数据源，即在同一包下的代码使用相同数据源，不同包下的代码使用不同数据源。

1. 相关依赖

        <!-- mybatis + druid -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>

2. 数据源配置类

第一个数据源

package com.daqo.digital.monitor.dao.mysql.config;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

/**
 * @Author: LiHui
 * @Date: 2021/6/1 9:26
 */
@Configuration
@MapperScan(basePackages= "com.daqo.digital.monitor.dao.mysql.digitalMonitorMapper",sqlSessionTemplateRef = "digitalMonitorSqlSessionTemplate")
public class DigitalMonitorDataSourceConfig {

    // 将这个对象放入Spring容器中
    @Bean(name = "digitalMonitorDataSource")
    // 读取application.properties中的配置参数映射成为一个对象
    // prefix表示参数的前缀
    @ConfigurationProperties(prefix = "spring.datasource.digital.monitor")
    //primary代表主库(默认数据源)
    @Primary
    public DataSource testDataSource(){
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "digitalMonitorSqlSessionFactory")
    @Primary
    // @Qualifier表示查找Spring容器中名字为digitalMonitorDataSource的对象
    public SqlSessionFactory testSqlSessionFactory(@Qualifier("digitalMonitorDataSource") DataSource dataSource) throws Exception{
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);

        bean.setTypeAliasesPackage("com.daqo.digital.monitor.dao.mysql.digitalMonitorMapper");
        org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        // 开启驼峰命名规则
        configuration.setMapUnderscoreToCamelCase(true);
        bean.setConfiguration(configuration);

        return bean.getObject();
    }

    @Bean(name = "digitalMonitorTransactionManager")
    @Primary
    public DataSourceTransactionManager testTransactionManager(@Qualifier("digitalMonitorDataSource") DataSource dataSource) throws Exception{
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "digitalMonitorSqlSessionTemplate")
    @Primary
    public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("digitalMonitorSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception{
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

第二个数据源

package com.daqo.digital.monitor.dao.mysql.config;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

/**
 * @Author: LiHui
 * @Date: 2021/6/1 9:27
 */
@Configuration
@MapperScan(basePackages= "com.daqo.digital.monitor.dao.mysql.daqoCloudMapper",sqlSessionTemplateRef = "daqoCloudSqlSessionTemplate")
public class DaqoCloudDataSourceConfig {

    @Bean(name = "daqoCloudDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.daqo.cloud")
    public DataSource testDataSource(){
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "daqoCloudSqlSessionFactory")
    public SqlSessionFactory testSqlSessionFactory(@Qualifier("daqoCloudDataSource") DataSource dataSource) throws Exception{
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);

        bean.setTypeAliasesPackage("com.daqo.digital.monitor.dao.mysql.daqoCloudMapper");
        org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        // 开启驼峰命名规则
        configuration.setMapUnderscoreToCamelCase(true);
        bean.setConfiguration(configuration);

        return bean.getObject();
    }

    @Bean(name = "daqoCloudTransactionManager")
    public DataSourceTransactionManager testTransactionManager(@Qualifier("daqoCloudDataSource") DataSource dataSource) throws Exception{
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "daqoCloudSqlSessionTemplate")
    public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("daqoCloudSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception{
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

3. 多数据源配置

application.properties

4. 数据源的相关代码所在的包