springboot+mybatis多数据源配置

目录结构(比较懒..达到效果就算了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,还有一个是瞎鸡儿写的
最后.贪玩蓝月.启动**