springboot-mybatis多数据源配置（超简单！）-CSDN博客

本文链接：https://blog.csdn.net/corleone_4ever/article/details/104287911

不知已经遇到多少次，需要多数据源的场景了，今天把常用配置写下来，非常简单。这里两个数据源命名为from和to

一、yml配置

这里springboot默认的数据源配置就不要写了，以免冲突

# 开发环境配置
server:
  # 服务器的HTTP端口，默认为80
  port: 80

# 日志配置
logging:
  level:
    xyz.hashdog: debug

datasynchronism:
  datasource:
    #获取
    from:
      driverClassName: com.mysql.jdbc.Driver
      url: jdbc:mysql://localhost:3306/from?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
      username: root
      password: root
      #写入
    to:
      driverClassName: com.mysql.jdbc.Driver
      url: jdbc:mysql://localhost:3306/to?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
      username: root
      password: root

二、第一个数据源 to的configbean配置

package xyz.hashdog.datasynchronism.config;

import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;

/**
 * @author th
 * @description: to数据源
 * @projectName hashdog
 * @date 2020/2/1217:41
 */
@Configuration
@MapperScan(basePackages = "xyz.hashdog.datasynchronism.to.dao", sqlSessionFactoryRef = "toFactory")
public class ToDruidConfig {
    /**
     * 封装数据源对象创建, 该方法就已经将数据源的各个数据封装到该对象中
     * @return
     */
    @Bean(name = "toDataSource")
    @Primary //必须要有, 说明该数据源是默认数据源
    @ConfigurationProperties(prefix = "datasynchronism.datasource.to") //读取的数据源前缀, 跟yml文件对应
    public DataSource toDataSource(){
        return new DruidDataSource();
    }

    /**
     * SqlSession对象创建
     * @param dataSource
     * @return
     * @throws Exception
     */
    @Bean(name = "toFactory")
    @Primary//必须要有, 说明该数据源是默认数据源
    public SqlSessionFactory toFactory(@Qualifier("toDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        //指定全限定别名
        bean.setTypeAliasesPackage("xyz.hashdog.datasynchronism.bean");
        bean.setDataSource(dataSource);
        //指定该SqlSession对应的mapper.xml文件位置
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/to/*.xml"));
        //开启驼峰转换
        SqlSessionFactory sqlSessionFactory = bean.getObject();
        org.apache.ibatis.session.Configuration configuration =  sqlSessionFactory.getConfiguration();
        configuration.setMapUnderscoreToCamelCase(true);
        return bean.getObject();
    }



}

三、第二个数据源from的configbean配置

package xyz.hashdog.datasynchronism.config;

import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;

/**
 * @author th
 * @description: TODO
 * @projectName hashdog
 * @date 2020/2/1217:38
 */
@Configuration
@MapperScan(basePackages = "xyz.hashdog.datasynchronism.from.dao", sqlSessionFactoryRef = "fromFactory")
class FromDruidConfig {

    @Bean(name = "fromDataSource")
    @ConfigurationProperties(prefix = "datasynchronism.datasource.from")
    public DataSource fromDataSource(){
        return new DruidDataSource();
    }

    @Bean(name = "fromFactory")
    public SqlSessionFactory fromFactory(@Qualifier("fromDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        //指定包别名
        bean.setTypeAliasesPackage("xyz.hashdog.datasynchronism.bean");
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/from/*.xml"));
        SqlSessionFactory sqlSessionFactory = bean.getObject();
        org.apache.ibatis.session.Configuration configuration =  sqlSessionFactory.getConfiguration();
        configuration.setMapUnderscoreToCamelCase(true);
        return bean.getObject();
    }
}