MybatisPlus配置多数据源

前言

今天团队里一个刚毕业的新人，手里的一个任务是把项目改成多数据源的，弄了好久没弄出来，找我帮忙，我之前也没做过，所以记录一下踩过的坑。

编写数据源配置类

我这边用的是静态的多数据源配置

第一个数据源配置

• 注意，@Primary注解表明这是主库
• MybatisSqlSessionFactoryBean 不要用错，如果没加Mybatis，那么MybatisPlus的原生方法都会失效
• 要加分页的配置

package com.xxx.xxx.configuration;

import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;
import org.apache.ibatis.session.SqlSessionFactory;
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 javax.sql.DataSource;

@Configuration
@MapperScan(basePackages = "com.xxx.xxx.stats.mapper.xxx",sqlSessionFactoryRef = "sepdamSqlSessionFactory")
public class SepdamDataSourceConfig {
  @Primary
  @Bean(name = "sepdamDataSource")
  @ConfigurationProperties("spring.datasource.sepdam")
  public DataSource sepdamDataSource(){
    return DataSourceBuilder.create().build();
  }

  @Bean(name = "sepdamSqlSessionFactory")
  public SqlSessionFactory sqlSessionFactory(@Qualifier("sepdamDataSource") DataSource dataSource) throws Exception {
    MybatisSqlSessionFactoryBean sessionFactoryBean = new MybatisSqlSessionFactoryBean();
    sessionFactoryBean.setDataSource(dataSource);
    sessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/**/*.xml"));
    Interceptor interceptor = new PageInterceptor();
    Properties properties = new Properties();
    //数据库
    properties.setProperty("helperDialect", "mysql");
    //是否将参数offset作为PageNum使用
    properties.setProperty("offsetAsPageNum", "true");
    //是否进行count查询
    properties.setProperty("rowBoundsWithCount", "true");
    //是否分页合理化
    properties.setProperty("reasonable", "false");

    interceptor.setProperties(properties);
    sessionFactoryBean.setPlugins(new Interceptor[] {interceptor});
    return sessionFactoryBean.getObject();
  }
}

第二个数据源配置类

• 注意：与第一个配置类相比，不能有@Primary注解，因为只能有一个主库
• 其他与第一个配置类一样即可，注意细节，mapper的位置，xml的位置，配置文件中数据源的名称等

package com.xxx.xxx.configuration;

import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;
import com.github.pagehelper.PageInterceptor;
import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.session.SqlSessionFactory;
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.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;
import java.util.Properties;

@Configuration
@MapperScan(basePackages = "com.xxx.xxx.stats.mapper.db2",sqlSessionFactoryRef = "db2SqlSessionFactory")
public class DataSource2Config {
  @Bean(name = "db2DataSource")
  @ConfigurationProperties("spring.datasource.sepdam2")
  public DataSource db2DataSource(){
    return DataSourceBuilder.create().build();
  }

  @Bean(name = "db2SqlSessionFactory")
  public SqlSessionFactory sqlSessionFactory(@Qualifier("db2DataSource") DataSource dataSource) throws Exception {
    MybatisSqlSessionFactoryBean sessionFactoryBean = new MybatisSqlSessionFactoryBean();
    sessionFactoryBean.setDataSource(dataSource);
    sessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/**/*.xml"));
    Interceptor interceptor = new PageInterceptor();
    Properties properties = new Properties();
    //数据库
    properties.setProperty("helperDialect", "mysql");
    //是否将参数offset作为PageNum使用
    properties.setProperty("offsetAsPageNum", "true");
    //是否进行count查询
    properties.setProperty("rowBoundsWithCount", "true");
    //是否分页合理化
    properties.setProperty("reasonable", "false");

    interceptor.setProperties(properties);
    sessionFactoryBean.setPlugins(new Interceptor[] {interceptor});
    return sessionFactoryBean.getObject();
  }
}