SpringBoot整合MyBatis多数据源

一、依赖如下：

二、添加Druid Spring Boot Starter

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.22</version>
</dependency>

三、多数据源配置
1、application.properties中的配置

spring.datasource.a.url=jdbc:mysql:///demo1?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8
spring.datasource.a.username=root
spring.datasource.a.password=******
spring.datasource.a.type=com.alibaba.druid.pool.DruidDataSource

spring.datasource.b.url=jdbc:mysql:///demo2?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8
spring.datasource.b.username=root
spring.datasource.b.password=******
spring.datasource.b.type=com.alibaba.druid.pool.DruidDataSource

2、提供两个DataSource:

@Configuration
public class DataSourceConfig {
    
    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.a")
    DataSource dsA() {
        return DruidDataSourceBuilder.create().build();
    }

    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.b")
    DataSource dsB() {
        return DruidDataSourceBuilder.create().build();
    }
}

3、MyBatis配置

@Configuration
@MapperScan(basePackages = "com.mybatis.mapper1",sqlSessionFactoryRef = "sqlSessionFactory1",sqlSessionTemplateRef = "sqlSessionTemplate1")
public class MyBatisConfigA {
    
    @Resource(name = "dsA")
    DataSource dataSource;
    
    @Bean
    SqlSessionFactory sqlSessionFactory1() {
        SqlSessionFactory sessionFactory = null;
        try {
            SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
            bean.setDataSource(dataSource);
            bean.setTypeAliasesPackage("com.mybatis.entity");
            sessionFactory = bean.getObject();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return sessionFactory;
    }
    
    @Bean
    SqlSessionTemplate sqlSessionTemplate1() {
        return new SqlSessionTemplate(sqlSessionFactory1());
    }
}

@Configuration
@MapperScan(basePackages = "com.mybatis.mapper2", sqlSessionFactoryRef = "sqlSessionFactory2", sqlSessionTemplateRef = "sqlSessionTemplate2")
public class MyBatisConfigB {

    @Resource(name = "dsB")
    DataSource dataSource;

    @Bean
    SqlSessionFactory sqlSessionFactory2() {
        SqlSessionFactory sessionFactory = null;
        try {
            SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
            bean.setDataSource(dataSource);
            bean.setTypeAliasesPackage("com.mybatis.entity");
            sessionFactory = bean.getObject();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return sessionFactory;
    }

    @Bean
    SqlSessionTemplate sqlSessionTemplate2() {
        return new SqlSessionTemplate(sqlSessionFactory2());
    }
}

4、mapper创建
com.mybatis.mapper1中的mapper:

@Repository
public interface UserMapperA {
    List<User> getAllUsers();
}

对应的XML文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mybatis.mapper1.UserMapperA">
    <select id="getAllUsers" resultType="user">
        select * from t_user
    </select>
</mapper>

com.mybatis.mapper2中的mapper:

@Repository
public interface UserMapperB {
    List<User> getAllUsers();
}

对应的XML文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mybatis.mapper2.UserMapperB">
    <select id="getAllUsers" resultType="user">
        select * from t_user
    </select>
</mapper>

这样不同Mapper就可以操作不同的数据源。