通用mapper 集成多数据源

通用mapper集成双数据源

一个动态数据源（多数据源动态切换） 一个非动态数据源

非动态

/**
 * 主数据源
 * 注意，要支持tk-mybatis扩展中间件，需要用tk.mybatis.spring.annotation.MapperScan注解
 */
@Configuration
@MapperScan(basePackages = {
   "com.company.push.push.**.mapper"}, sqlSessionTemplateRef = "userSqlSessionTemplate")
public class PushMybatisConfig {
   
    @Value("${push.mybatis.mapperLocations}")
    private String mainMapper;

    @Bean(name = "userDataSource")
    @Primary //必须加此注解，不然报错，下一个类则不需要添加
    @ConfigurationProperties(prefix = "push.datasource") //prefix值必须是application.properteis中对应属性的前缀
	public DataSource userDataSource() {
   
        return DataSourceBuilder.create().build();
    }

    /**
     * 配置事务管理器
     *
     * @param dataSource
     * @return
     */
    @Bean(name = "masterTransactionManger")
    @Primary
    public DataSourceTransactionManager masterTransactionManger(@Qualifier("userDataSource") DataSource dataSource) {
   
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean
    @Primary
    public SqlSessionFactory userSqlSessionFactory(@Qualifier("userDataSource") DataSource dataSource) throws Exception {
   
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setVfs(SpringBootVFS.class);
        bean.setTypeAliasesPackage("com.companyPush");
        ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        try {
   
            bean.setMapperLocations(resolver.getResources(mainMapper));
            return bean.getObject();
        } catch (Exception e) {
   
            e.printStackTrace