mybatis多数据源配置_SpringBoot整合多数据源配置实战

最新推荐文章于 2024-05-04 00:45:13 发布

weixin_39750854

最新推荐文章于 2024-05-04 00:45:13 发布

阅读量74

点赞数

文章标签： mybatis多数据源配置 springboot多数据源配置 springboot多数据源配置和切换 springboot配置双数据源 springboot配置多数据源 springboot配置数据源

本文链接：https://blog.csdn.net/weixin_39750854/article/details/111276179

版权

点击蓝色“今日Java”关注我哟

加个“星标”，不迷路哦

来源 | blog.csdn.net/fire_100/article/details/109469666整理 | 麦叔

近期在处理项目整合的task，涉及到多数据源配置，现将具体实践分享给大家。

配置多数据源

1.application.yml配置

first:
  datasource:
    password: *****
    url: *****
    username: *****
second:
  datasource:
    password: *****
    url: *****
    username: *****
12345678910

2.数据源配置类

项目结构如下：)

@Configuration
@MapperScan(basePackages = FirstDataSourceConfig.MAPPER_PACKAGE, sqlSessionFactoryRef = "firstSqlSessionFactory")
public class FirstDataSourceConfig {

    static final String MAPPER_PACKAGE = "***.mapper.first";
    private static final String MAPPER_LOCATION = "classpath:mapper/first/*.xml";

    @Bean(value = "firstDataSource")
    @ConfigurationProperties(prefix = "first.datasource")
    public DataSource dataSourceManager() {
        return DruidDataSourceBuilder.create().build();
    }

    @Bean(name = "firstTransactionManager")
    public DataSourceTransactionManager transactionManager(@Qualifier("firstDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "firstSqlSessionFactory")
    public SqlSessionFactory firstSqlSessionFactory1(@Qualifier("firstDataSource") DataSource dataSource)throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource);
        ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        sessionFactory.setConfigLocation(resolver.getResource(Constants.MYBATIS_CONFIG_PATH));
        sessionFactory.setMapperLocations(resolver.getResources(MAPPER_LOCATION));
        return sessionFactory.getObject();
    }
}
1234567891011121314151617181920212223242526272829
@Configuration
@MapperScan(basePackages = SecondDataSourceConfig.MAPPER_PACKAGE, sqlSessionFactoryRef = "secondSqlSessionFactory")
public class SecondDataSourceConfig {

    static final String MAPPER_PACKAGE = "***.mapper.second";
    private static final String MAPPER_LOCATION = "classpath:mapper/second/*.xml";

    @Bean(value = "secondDataSource")
    @ConfigurationProperties(prefix = "second.datasource")
    public DataSource dataSourceManager() {
        return DruidDataSourceBuilder.create().build();
    }

    @Bean(name = "secondTransactionManager")
    public DataSourceTransactionManager transactionManager(@Qualifier("secondDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "secondSqlSessionFactory")
    public SqlSessionFactory secondSqlSessionFactory2(@Qualifier("secondDataSource") DataSource dataSource)throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource);
        ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        sessionFactory.setConfigLocation(resolver.getResource(Constants.MYBATIS_CONFIG_PATH));
        sessionFactory.setMapperLocations(resolver.getResources(MAPPER_LOCATION));
        return sessionFactory.getObject();
    }
}
1234567891011121314151617181920212223242526272829
MapperScan注解定义了持久层的扫包范围，并且指定这个包配置的是哪个数据源。
@ConfigurationProperties(prefix = "xxx.xxx")可以依靠指定的前缀，使用application.yml中指定数据源的配置。
sessionFactory.setConfigLocation(new PathMatchingResourcePatternResolver().getResource(Constants.MYBATIS_CONFIG_PATH)): 自定义数据源不会自动加载MybatisAutoConfiguration.java这个配置类里面的sqlSessionFactory，也就不会自动加载mybatis-config.xml配置文件，需手动加载。
事务处理：@Transactional(rollbackFor = Exception.class, transactionManager = "firstTransactionManager")
1234

3.demo测试

@RunWith(SpringRunner.class)
@Slf4j
@SpringBootTestpublic class DataSourceTest {

    @Resource
    private KnowledgeRecordMapper knowledgeRecordMapper;
    @Resource
    private CourseUnitMapper courseUnitMapper;

    @Test
    public void dataSourceTest() throws Exception {
     //数据来自于first数据源
        DocumentRecordItem item = knowledgeRecordMapper.getDocumentRecordById(13439l);
        if (Objects.isNull(item)) {
            return;
        }
        log.info("documentRecord: {}", item.toString());

  //数据来自于second数据源
        List unitIds = Arrays.asList(552l, 1268l);
        List list = courseUnitMapper.getUnitKnowledgeExaminedStatusFromResult(unitIds);if (CollectionUtils.isEmpty(list)) {return;
        }
        log.info("list: {}", list);
    }
}12345678910111213141516171819202122232425262728

结果如下：

2020-11-03 14:26:00,246000 [INFO] [] [] main DruidDataSource.java:init:1003 - {dataSource-1} inited
2020-11-03 14:26:00,852000 [INFO] [] [] main DataSourceTest.java:dataSourceTest:39 - documentRecord: {"ctime":1575023698000,"documentName":"1575023700097.xlsx","id":13439,"operationDetail":"-","operationType":21,"operatorId":30000302,"operatorName":"***","utime":1575023698000}
2020-11-03 14:26:00,883000 [INFO] [] [] main DruidDataSource.java:init:1003 - {dataSource-2} inited