springboot 多数据源

添加数据源：

##spring.datasource.master.driverClassName=com.mysql.jdbc.Driver
#spring.datasource.master.url=jdbc:mysql://localhost:3306/ssm
#spring.datasource.master.username=root
#spring.datasource.master.password=1234
#
#
#
##spring.datasource.slave.driverClassName=com.mysql.jdbc.Driver
#spring.datasource.slave.url=jdbc:mysql://localhost:3306/ssm1
#spring.datasource.slave.username=root
#spring.datasource.slave.password=1234

数据源配置：

数据源test1

@Configuration
@MapperScan(basePackages = "com.example.demo.test1",sqlSessionFactoryRef = "masterSqlSessionFactory")
public class DataSourceConfig {

    @Bean(name = "masterDataSource")
    @ConfigurationProperties("spring.datasource.master")
    @Primary
    public DataSource masterDataSource(){
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "masterSqlSessionFactory")
    @Primary
    public SqlSessionFactory sqlSessionFactory(@Qualifier("masterDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean();
        sessionFactoryBean.setDataSource(dataSource);
//        sessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver()
//        .getResources("classpath*:mapper/master/*.xml"));
        return sessionFactoryBean.getObject();
    }
    @Bean("masterTransactionManager")
    @Primary
    public DataSourceTransactionManager masterTransactionManager(@Qualifier("masterDataSource")DataSource dataSource) {
    	return new DataSourceTransactionManager(dataSource);
    }
    @Bean("masterSqlSessionTemplate")
    public SqlSessionTemplate masterSqlSessionTemplate(@Qualifier("masterSqlSessionFactory")SqlSessionFactory sessionFactoryBean) {
    	return new SqlSessionTemplate(sessionFactoryBean);
    }
}

数据源test2

@Configuration
@MapperScan(basePackages = "com.example.demo.test2",sqlSessionFactoryRef = "slaveSqlSessionFactory")
public class DataSourceConfig2 {
    @Bean(name = "slaveDataSource")
    @ConfigurationProperties("spring.datasource.slave")
    public DataSource slaveDataSource(){
        return DataSourceBuilder.create().build();
    } 
 
    @Bean(name = "slaveSqlSessionFactory")
    public SqlSessionFactory sqlSessionFactory(@Qualifier("slaveDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean();
        sessionFactoryBean.setDataSource(dataSource);
        sessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources("classpath*:mapper/slave/*.xml"));
        return sessionFactoryBean.getObject();
    }
    
    @Bean("slaveTransactionManager")
    public DataSourceTransactionManager slaveTransactionManager(@Qualifier("slaveDataSource")DataSource dataSource) {
    	return new DataSourceTransactionManager(dataSource);
    }
    @Bean("slaveSqlSessionTemplate")
    public SqlSessionTemplate slaveSqlSessionTemplate(@Qualifier("slaveSqlSessionFactory")SqlSessionFactory sessionFactoryBean) {
    	return new SqlSessionTemplate(sessionFactoryBean);
    }
}

根据数据源的配置，在指定包下创建mapper,controller使用不同的数据源