目录结构(比较懒..达到效果就算了233):
resources/application.properties
**接下来我们需要分别配置两个数据源
MapperScan还是很重要哒.比如我们searchDao需要用到master的数据源.(taotao库).我们要吧basepackage指向它,还有sqlSessionTemplate的引用
下面我没有配置MapperLocations的原因是我直接用了注解.我比较懒emmm**
@Configuration
@MapperScan(basePackages = "com.wangzai.master", sqlSessionTemplateRef = "masterSqlSessionTemplate")
public class MasterDatasourceConfig {
/**
* 配置数据数据源 master
*
* @return
*/
@Bean(name = "masterDatasource")
@ConfigurationProperties(prefix = "spring.datasource.master")
@Primary
public DataSource masterDatasource() {
return DataSourceBuilder.create().build();
}
/**
* 配置session工厂
*
* @param dataSource
* @return
* @throws Exception
*/
@Bean(name = "masterSqlSessionFactory")
@Primary
public SqlSessionFactory masterSqlSessionFactory(@Qualifier("masterDatasource") DataSource dataSource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
// bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:"));
return bean.getObject();
}
/**
* 配置事务管理器
*
* @param dataSource
* @return
*/
@Bean(name = "masterTransactionManger")
@Primary
public DataSourceTransactionManager masterTransactionManger(@Qualifier("masterDatasource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
/**
* 模版
*
* @param sqlSessionFactory
* @return
* @throws Exception
*/
@Bean(name = "masterSqlSessionTemplate")
@Primary
public SqlSessionTemplate masterSqlSessionTemplate(@Qualifier("masterSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
return new SqlSessionTemplate(sqlSessionFactory);
}
}
另外一个数据源slave
@Configuration
@MapperScan(basePackages = "com.wangzai.slave" ,sqlSessionTemplateRef = "slaveSqlSessionTemplate")
public class SlaveDatasourceConfig {
/**
* 配置数据数据源 slave
* @return
*/
@Bean(name = "slaveDatasource")
@ConfigurationProperties(prefix = "spring.datasource.slave")
// @Primary
public DataSource slaveDatasource(){
return DataSourceBuilder.create().build();
}
/**
* 配置session工厂
* @param dataSource
* @return
* @throws Exception
*/
@Bean(name = "slaveSqlSessionFactory")
// @Primary
public SqlSessionFactory slaveSqlSessionFactory(@Qualifier("slaveDatasource") DataSource dataSource) throws Exception{
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
// bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:"));
return bean.getObject();
}
/**
* 配置事务管理器
* @param dataSource
* @return
*/
@Bean(name = "slaveTransactionManger")
// @Primary
public DataSourceTransactionManager slaveTransactionManger(@Qualifier("slaveDatasource") DataSource dataSource){
return new DataSourceTransactionManager(dataSource);
}
/**
* 模版
* @param sqlSessionFactory
* @return
* @throws Exception
*/
@Bean(name = "slaveSqlSessionTemplate")
// @Primary
public SqlSessionTemplate slaveSqlSessionTemplate(@Qualifier("slaveSqlSessionFactory")SqlSessionFactory sqlSessionFactory) throws Exception{
return new SqlSessionTemplate(sqlSessionFactory);
}
}
然后两个dao就可以随意查询了,但是注意上面数据源的注入,dept可以查询slave,master可以查询taotao
**上面截图还有一个文件是pojo,还有一个是瞎鸡儿写的
最后.贪玩蓝月.启动**