添加数据源:
##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使用不同的数据源