多数据源结合mybatis-plus的使用

多数据源
数据源mysql配置
@Configuration
@MapperScan(basePackages="com.database.multidatademo.mapper.first",sqlSessionFactoryRef = "firstSqlSessionFactory")
public class DataSource1Config {

 @Autowired
 Datasource1Properties datasource1Properties;



 @Bean(name = "firstDataSource")
 @Primary
 public DataSource getDataSource1(){
     HikariConfig config = new HikariConfig();
     config.setUsername(datasource1Properties.getUsername());
     config.setPassword(datasource1Properties.getPassword());
     config.setJdbcUrl(datasource1Properties.getUrl());
     config.setDriverClassName(datasource1Properties.getDriverClassName());
     HikariDataSource ds = new HikariDataSource(config);
     return ds;

 }

 @Bean(name = "firstSqlSessionFactory")
 public SqlSessionFactory firstSqlSessionFactory(@Qualifier("firstDataSource") DataSource dataSource1) throws Exception {
     //使用BaseMapper需要使用MybatisSqlSessionFactoryBean而不是SqlSessionFactoryBean,否则Mapper中继承的BaseMapper无效
     MybatisSqlSessionFactoryBean mssfb = new MybatisSqlSessionFactoryBean();
     mssfb.setDataSource(dataSource1);
     //xml位置
     mssfb.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:/mapping/*.xml"));
     //别名
     mssfb.setTypeAliasesPackage("com.database.multidatademo.domain");
     //分页插件,需要放在驼峰配置前,否则分页不生效,total=0
     mssfb.setPlugins(new Interceptor[] {new PaginationInterceptor()});
     //驼峰
     mssfb.getObject().getConfiguration().setMapUnderscoreToCamelCase(true);
     mssfb.getObject().getConfiguration().setCallSettersOnNulls(true);
     return mssfb.getObject();

 }

 @Bean(name = "firstSqlSessionTemplate")
 public SqlSessionTemplate firstSqlSessionTemplate(@Qualifier("firstSqlSessionFactory") SqlSessionFactory sqlSessionFactory){
     return new SqlSessionTemplate(sqlSessionFactory);
 }

 @Bean(name = "firstDataSourceTransactionManager")
 public DataSourceTransactionManager firstDataSourceTransactionManager(@Qualifier("firstDataSource") DataSource dataSource){
     return new DataSourceTransactionManager(dataSource);
 }
}
数据源oracle配置
@Configuration
@MapperScan(basePackages="com.database.multidatademo.mapper.sec",sqlSessionFactoryRef = "secSqlSessionFactory")
public class DataSource2Config {

    @Autowired
    Datasource2Properties datasource2Properties;



    @Bean(name = "secDataSource")
    public DataSource getDataSource2(){
        HikariConfig config = new HikariConfig();
        config.setUsername(datasource2Properties.getUsername());
        config.setPassword(datasource2Properties.getPassword());
        config.setJdbcUrl(datasource2Properties.getUrl());
        config.setDriverClassName(datasource2Properties.getDriverClassName());
        HikariDataSource ds = new HikariDataSource(config);
        return ds;

    }

    @Bean(name = "secSqlSessionFactory")
    public SqlSessionFactory secSqlSessionFactory(@Qualifier("secDataSource") DataSource dataSource2) throws Exception {
        //使用BaseMapper需要使用MybatisSqlSessionFactoryBean而不是SqlSessionFactoryBean,否则Mapper中继承的BaseMapper无效
        MybatisSqlSessionFactoryBean mssfb = new MybatisSqlSessionFactoryBean();
        mssfb.setDataSource(dataSource2);
        //xml位置
        mssfb.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:/mapping/*.xml"));
        //别名
        mssfb.setTypeAliasesPackage("com.database.multidatademo.domain");
        //分页插件,需要放在驼峰配置前,否则分页不生效,total=0
        mssfb.setPlugins(new Interceptor[] {new PaginationInterceptor()});
        //驼峰
        mssfb.getObject().getConfiguration().setMapUnderscoreToCamelCase(true);
        mssfb.getObject().getConfiguration().setCallSettersOnNulls(true);
        return mssfb.getObject();

    }

    @Bean(name = "secSqlSessionTemplate")
    public SqlSessionTemplate secSqlSessionTemplate(@Qualifier("secSqlSessionFactory") SqlSessionFactory sqlSessionFactory){
        return new SqlSessionTemplate(sqlSessionFactory);
    }

    @Bean(name = "secDataSourceTransactionManager")
    public DataSourceTransactionManager secDataSourceTransactionManager(@Qualifier("secDataSource") DataSource dataSource){
        return new DataSourceTransactionManager(dataSource);
    }
}
demo已经上传,使用swagger3可以调试,3和2的请求地址也有所不同,http://localhost:8888/swagger-ui/index.html,表中的数据自己可以添加几条测试下https://gitee.com/cherrychao/case.git
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

脚一晃

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值