mybatis-plus 配置多个数据源

最新推荐文章于 2025-02-21 16:20:58 发布

重生之我是一名程序员

最新推荐文章于 2025-02-21 16:20:58 发布

阅读量1.2k

点赞数

分类专栏： mybatis 文章标签： mybatis java spring

原文链接：https://editor.csdn.net/md/?not_checkout=1&spm=1010.2135.3001.4503

版权

mybatis 专栏收录该内容

30 篇文章

订阅专栏

该文章展示了如何在SpringBoot中配置Mybatis-Plus以支持多个数据源。配置包括了主数据源`master`和从数据源`slave`，使用DruidDataSource作为数据源，分别创建对应的SqlSessionFactory和SqlSessionTemplate。同时，需要在启动类中排除Mybatis和Mybatis-Plus的自动装配。

摘要由CSDN通过智能技术生成

mybatis-plus 配置多个数据源

数据源master

@Configuration
@MapperScan(basePackages = "com.xxx.mapper.master", sqlSessionFactoryRef = "masterSqlSessionFactory")
public class DongcaiDataSourceConfig {

    @Bean(name = "masterDataSource")
    @ConfigurationProperties(prefix = "spring.master.datasource")
    public DruidDataSource masterDataSource() {
        return new DruidDataSource();
    }

    @Bean(name = "masterSqlSessionFactory")
    public SqlSessionFactory dongcaiSqlSessionFactory(@Qualifier("masterDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources("classpath*:mapping/master/*Mapper.xml"));
        return bean.getObject();
    }

    @Bean(name = "masterSqlSessionTemplate")
    public SqlSessionTemplate dongcaiSqlSessionTemplate(@Qualifier("masterSqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

}

数据源 slave

@Configuration
@MapperScan(basePackages = "com.xxx.mapper.slave", sqlSessionFactoryRef = "slaveSqlSessionFactory")
public class DongcaiDataSourceConfig {

    @Bean(name = "slaveDataSource")
    @ConfigurationProperties(prefix = "spring.slave.datasource")
    public DruidDataSource masterDataSource() {
        return new DruidDataSource();
    }

    @Bean(name = "slaveSqlSessionFactory")
    public SqlSessionFactory dongcaiSqlSessionFactory(@Qualifier("slaveDataSource") DataSource dataSource) throws Exception {
        MybatisSqlSessionFactoryBean bean = new MybatisSqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources("classpath*:mapping/slave/*Mapper.xml"));
        return bean.getObject();
    }

    @Bean(name = "slaveSqlSessionTemplate")
    public SqlSessionTemplate dongcaiSqlSessionTemplate(@Qualifier("slaveSqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

}

注意，这里用 MybatisSqlSessionFactoryBean 而不是 SqlSessionFactoryBean！！

修改启动类，排除mybatis和mybatis-plus 自动装配

@SpringBootApplication(exclude = {MybatisPlusAutoConfiguration.class,MybatisAutoConfiguration.class})
public class UserApplication {

    public static void main(String[] args) {
        SpringApplication.run(UserApplication.class, args);
    }
}