SpringBoot配置多数据源Mybatis/MybatisPlus/mysql

一、前言

项目开发过程中，单一数据源不能满足开发需求或者需要用到主从数据库的时候，引入多数据源配置在项目中显得尤为必要。下面简单介绍一种在spingboot中结合mybatis针对同类型的数据源mysql进行多数据源配置和应用

环境准备：

JDK 1.8
SpringBoot 2.5.1
Maven 3.6.3
MySQL 5.7

二、目录结构

三、引入数据库依赖

        <!--数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

四、添加数据源(yml)

#数据源连接信息
spring:
  datasource:
    primary:
      username: root
      password: mima12345
      jdbc-url: jdbc:mysql://192.168.10.102:3306/mingqian?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&serverTimezone=Asia/Shanghai
      driver-class-name: com.mysql.jdbc.Driver
    datasource2:
      username: root
      password: mima12345
      jdbc-url: jdbc:mysql://192.168.10.102:3306/mingqianbak?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&serverTimezone=Asia/Shanghai
      driver-class-name: com.mysql.jdbc.Driver

五、添加数据源的配置文件

• 主数据源

@Configuration
@MapperScan(basePackages = {
   "com.sunshine.mapper.primary"}, sqlSessionFactoryRef = "sqlSessionFactory")
public class PrimaryDataSourceConfig {
   

    @Bean(name = "dataSource")
    @ConfigurationProperties(prefix = "spring.datasource.primary")
    @Primary
    public DataSource dataSource() {
   
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "sqlSessionFactory")
    @Primary
    public SqlSessionFactory sqlSessionFactory(@Qualifier("dataSource") DataSource dataSource) throws Exception {
   
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/*.xml"));
        return bean.getObject();
    }

    @Bean(name = "transactionManager")
    @Primary
    public DataSourceTransactionManager transactionManager(@Qualifier("dataSource") DataSource dataSource) {
   
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "sqlSessionTemplate")
    @Primary
    public SqlSessionTemplate sqlSessionTemplate(@Qualifier("sqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
   
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

• 第二数据源

@Configuration
@MapperScan(basePackages = {
   "com.sunshine.mapper.datasource2"}, sqlSessionFactoryRef = "sqlSessionFactory2")
public class SecondDataSourceConfig {
   

   @Bean(name = "dataSource2")
   @ConfigurationProperties(prefix = "spring.datasource.datasource2")
   public DataSource dataSource() {
   
       return DataSourceBuilder.create().build();
   }

   @Bean(name = "sqlSessionFactory2"