springboot 配置多数据源

最新推荐文章于 2022-08-14 09:10:19 发布

Bingove

最新推荐文章于 2022-08-14 09:10:19 发布

阅读量144

点赞数

文章标签： SpringBoot 多数据源配置

本文链接：https://blog.csdn.net/Bingove/article/details/93977712

版权

/**
 * Mysql 主数据源
 *
 * @author cuixw
 * @date 12/11/2017
 */
/*@Configuration
@MapperScan(basePackages = MasterDataSourceConfig.PACKAGE, sqlSessionFactoryRef = "masterSqlSessionFactory")
public class MasterDataSourceConfig {
    private Logger logger = LoggerFactory.getLogger(MasterDataSourceConfig.class);

    *//**
     * 精确到 master 目录，以便跟其他数据源隔离
     *//*
    static final String PACKAGE = "com.xhs.center.dao.master";
    static final String MAPPER_LOCATION = "classpath:mapper/master/*.xml";


    @Primary
    @Bean(name = "masterDataSource")
    @ConfigurationProperties("spring.datasource.druid.master")
    public DataSource masterDataSource() {
        logger.info("初始化 MySQL 数据源");
        return DruidDataSourceBuilder.create().build();
    }

    @Bean(name = "masterTransactionManager")
    @Primary
    public DataSourceTransactionManager masterTransactionManager() {
        return new DataSourceTransactionManager(masterDataSource());
    }

    @Bean(name = "masterSqlSessionFactory")
    @Primary
    public SqlSessionFactory masterSqlSessionFactory(@Qualifier("masterDataSource") DataSource masterDataSource)
            throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(masterDataSource);
        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources(MasterDataSourceConfig.MAPPER_LOCATION));
        return sessionFactory.getObject();
    }
}

/**
 * Criminal 数据源
 *
 * @author sqs
 * @date 2018年3月26日
 */
@Configuration
@MapperScan(basePackages = CriminalDataSourceConfig.PACKAGE, sqlSessionFactoryRef = "criminalSqlSessionFactory")
public class CriminalDataSourceConfig {
    private Logger logger = LoggerFactory.getLogger(CriminalDataSourceConfig.class);

    /**
     * 精确到 criminal 目录，以便跟其他数据源隔离
     */
    static final String PACKAGE = "com.xhs.center.dao.a";
    static final String MAPPER_LOCATION = "classpath:mapper/a/*.xml";

    @Bean(name = "criminalDataSource")
    @ConfigurationProperties("spring.datasource.druid.criminal")
    public DataSource criminalDataSource() {
        logger.info("初始化第二个 MySQL 数据源");
        return DruidDataSourceBuilder.create().build();
    }

    @Bean(name = "criminalTransactionManager")
    public DataSourceTransactionManager criminalTransactionManager() {
        return new DataSourceTransactionManager(criminalDataSource());
    }

    @Bean(name = "criminalSqlSessionFactory")
    public SqlSessionFactory criminalSqlSessionFactory(@Qualifier("criminalDataSource") DataSource criminalDataSource)
            throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(criminalDataSource);
        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources(CriminalDataSourceConfig.MAPPER_LOCATION));
        return sessionFactory.getObject();
    }


}