springboot双数据源

1.设置主数据源

@Configuration
@MapperScan(basePackages="***.dao.m", sqlSessionFactoryRef="mainSqlSessionFactory")
public class DataSourceMainConfig
{
	@Primary													//表示这个数据源是默认数据源
	@Bean("mainDataSource")										//将这个对象放入Spring容器中
	@ConfigurationProperties(prefix="spring.datasource.main")	//读取配置文件中的参数，并指定参数名的前缀
	public DataSource getDataSource()
	{
		return DataSourceBuilder.create().build();
	}
	
	@Primary
	@Bean("mainSqlSessionFactory")
	public SqlSessionFactory mainSqlSessionFactory(@Qualifier("mainDataSource") DataSource datasource) throws Exception
	{
		SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
		bean.setDataSource(datasource);
		bean.setMapperLocations( new PathMatchingResourcePatternResolver().getResources("classpath:***/mapper/m/*.xml"));	//xml位置
		return bean.getObject();
	}
	
	@Primary
	@Bean("mainSqlSessionTemplate")
	public SqlSessionTemplate mainSqlSessionTemplate(@Qualifier("mainSqlSessionFactory") SqlSessionFactory sessionfactory)
	{
		return new SqlSessionTemplate(sessionfactory);
	}
}

2.设置第二个数据源

@Configuration
@MapperScan(basePackages="***.dao.s", sqlSessionFactoryRef="secondSqlSessionFactory")
public class DataSourceVocConfig
{
	@Bean("secondDataSource")										//将这个对象放入Spring容器中
	@ConfigurationProperties(prefix="spring.datasource.second")	//读取配置文件中的参数，并指定参数名的前缀
	public DataSource getDataSource()
	{
		return DataSourceBuilder.create().build();
	}
	
	@Bean("secondSqlSessionFactory")
	public SqlSessionFactory vocSqlSessionFactory(@Qualifier("secondDataSource") DataSource datasource) throws Exception
	{
		SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
		bean.setDataSource(datasource);
		bean.setMapperLocations( new PathMatchingResourcePatternResolver().getResources("classpath:***/mapper/s/*.xml"));	//xml位置
		return bean.getObject();
	}
	
	@Bean("secondSqlSessionTemplate")
	public SqlSessionTemplate vocSqlSessionTemplate(@Qualifier("secondSqlSessionFactory") SqlSessionFactory sessionfactory)
	{
		return new SqlSessionTemplate(sessionfactory);
	}
}