springboot mybatis配置多数据源

最近在工程中用到多数据源，做个笔记

1.application.properties  配置文件

#mysql
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url =jdbc:mysql://xxxx:7028/autotest?useUnicode=true&characterEncoding=utf8
spring.datasource.username =xxxx
spring.datasource.password =xxxx


#oracle
oracle.datasource.url=jdbc:oracle:thin:@xxxx:1521:xxxx
oracle.datasource.username=xxxx
oracle.datasource.password=xxxx
oracle.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver

2.编写不同数据库的配置类

（1）MySQL配置类

package cn.it.config;


import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

import javax.sql.DataSource;

import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.tomcat.jdbc.pool.PoolProperties;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.BeanUtils;
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.Resource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;


@Configuration
@MapperScan(basePackages = "cn.it.mysqldao", sqlSessionTemplateRef = "sqlSessionTemplate") //basePackages 这个数据源DAO所在的包名
public class MsqlConfig {
	@Bean(name="poolProperties")
	@ConfigurationProperties(prefix = "spring.datasource")
	public PoolProperties poolProperties() {
		return new PoolProperties();
	}
	
	@Bean(name = "dataSource")
    @Primary  //自动装配时当出现多个Bean候选者时，被注解为@Primary的Bean将作为首选者  多个配置类中不能同时使用此注解
    public DataSource dataSource(@Qualifier("poolProperties") PoolProperties poolProperties) {
		PoolProperties properties = new PoolProperties();
		BeanUtils.copyProperties(poolProperties, properties);
		properties.setPassword(poolProperties.getPassword());
    	return new org.apache.tomcat.jdbc.pool.DataSource(properties);
    }
	
    @Bean(name = "sqlSessionFactory")
    @Primary
    public SqlSessionFactory sqlSessionFactory(@Qualifier("dataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        //设置驼峰
        configuration.setMapUnderscoreToCamelCase(true);
        bean.setConfiguration(configuration);
        bean.setDataSource(dataSource);
        List<String> mapperlocations = new ArrayList<String>();
        mapperlocations.add("classpath:mapperDB/*Mapper.xml"); //xml 所在路径
 
        List<Resource> resources = new ArrayList<Resource>();
        
        for(String location : mapperlocations) {
        	try {
        		Resource[] r = new PathMatchingResourcePatternResolver().getResources(location);
        		resources.addAll(Arrays.asList(r));
			} catch (Exception e) {
				// TODO: handle exception
			}
        }
        

        Resource[] r = new Resource[resources.size()];
        resources.toArray(r);
        bean.setMapperLocations(r);
        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) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

（2）oracle配置类

package cn.it.config;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

import javax.sql.DataSource;

import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.tomcat.jdbc.pool.PoolProperties;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.BeanUtils;
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.Resource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;



@Configuration
@MapperScan(basePackages = "cn.it.oracledao", sqlSessionTemplateRef = "oracleSqlSessionTemplate")
public class OracleConfig {
	@Bean(name="oraclePoolProperties")
	@ConfigurationProperties(prefix = "oracle.datasource")
	public PoolProperties oraclePoolProperties() {
		return new PoolProperties();
	}
	
	@Bean(name = "oracleDataSource")
    public DataSource oracleDataSource(@Qualifier("oraclePoolProperties") PoolProperties poolProperties) {
		PoolProperties properties = new PoolProperties();
		BeanUtils.copyProperties(poolProperties, properties);
		properties.setPassword(poolProperties.getPassword());
    	return new org.apache.tomcat.jdbc.pool.DataSource(properties);
    }
	
    @Bean(name = "oracleSqlSessionFactory")
    public SqlSessionFactory oracleSqlSessionFactory(@Qualifier("oracleDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        //设置驼峰
        configuration.setMapUnderscoreToCamelCase(true);
        bean.setConfiguration(configuration);
        bean.setDataSource(dataSource);
        List<String> mapperlocations = new ArrayList<String>();
        mapperlocations.add("classpath:mapperOracle/*Mapper.xml");
 
        List<Resource> resources = new ArrayList<Resource>();
        
        for(String location : mapperlocations) {
        	try {
        		Resource[] r = new PathMatchingResourcePatternResolver().getResources(location);
        		resources.addAll(Arrays.asList(r));
			} catch (Exception e) {
				// TODO: handle exception
			}
        }
        Resource[] r = new Resource[resources.size()];
        resources.toArray(r);
        bean.setMapperLocations(r);
        return bean.getObject();
    }

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

    @Bean(name = "oracleSqlSessionTemplate")
    public SqlSessionTemplate oracleSqlSessionTemplate(@Qualifier("oracleSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}