springboot集成多个mybatis

最新推荐文章于 2023-06-13 19:51:45 发布

菜到不能自已的程序员

最新推荐文章于 2023-06-13 19:51:45 发布

阅读量458

点赞数

分类专栏： Java框架文章标签： mybatis spring boot java

本文链接：https://blog.csdn.net/HMH_huige/article/details/126302729

版权

Java框架专栏收录该内容

7 篇文章 0 订阅

订阅专栏

创建两个mybatis类
一.

@Configuration
@MapperScan(basePackages = "com.cp.mapper.r",sqlSessionFactoryRef = "rsqlSessionFactoryBean")
public class RMybatisConfig {
    @Bean("dataSource1")
    @ConfigurationProperties(prefix = "spring.datasource.datasource1")
    public DataSource dataSource(){

        return DruidDataSourceBuilder.create().build();
    }
    @Bean
    @Primary
    public SqlSessionFactory rsqlSessionFactoryBean(@Qualifier("dataSource1") DataSource dataSource)
    throws Exception
    {
       final SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
       sqlSessionFactoryBean.setDataSource(dataSource);
       //设置指定对应的mapper.xml 注解不用配置
       //sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResource(
       //        "classpath:mapper/w/*.xml"
       //));
       //日志
        //org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        //configuration.setLogImpl(StdOutImpl.class);
        //sqlSessionFactoryBean.setConfiguration(configuration);
        return sqlSessionFactoryBean.getObject();
    }

}

二.

@Configuration
@MapperScan(basePackages = "com.cp.mapper.w",sqlSessionFactoryRef = "wsqlSessionFactoryBean")
public class WMybatisConfig {
    @Bean("dataSource2")
    @ConfigurationProperties(prefix = "spring.datasource.datasource2")
    public DataSource dataSource(){

        return DruidDataSourceBuilder.create().build();
    }
    @Bean
    @Primary
    public SqlSessionFactory wsqlSessionFactoryBean(@Qualifier("dataSource2") DataSource dataSource)
    throws Exception
    {
       final SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
       sqlSessionFactoryBean.setDataSource(dataSource);
       //设置指定对应的mapper.xml 注解不用配置
       //sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResource(
       //        "classpath:mapper/w/*.xml"
       //));
       //日志
        //org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        //configuration.setLogImpl(StdOutImpl.class);
        //sqlSessionFactoryBean.setConfiguration(configuration);
        return sqlSessionFactoryBean.getObject();
    }

}