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); } }