SpringBoot+Mybatis多数据源配置

最新推荐文章于 2025-06-15 23:59:05 发布

原创最新推荐文章于 2025-06-15 23:59:05 发布 · 257 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #spring boot #数据库

本文介绍如何在SpringBoot项目中配置并使用Mybatis实现多数据源操作。通过两套配置文件、mapper及SqlSessionFactory，实现各自独立的数据处理流程。详细展示了配置类DatabaseConfig1与DatabaseConfig2的具体实现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SpringBoot+Mybatis多数据源配置

@Configuration
@MapperScan(basePackages = "com.**/mapper路径.bcop2021125.mapper.db1", sqlSessionFactoryRef = "SqlSessionFactory1")
public class DatabaseConfig1 {

    @Primary
    @Bean(name = {"DatebaseProperties"})
    @ConfigurationProperties("spring.datasource")
    public DataSourceProperties DataSourceProperties() {
        return new DataSourceProperties();
    }

    @Primary
    @Bean(name = {"DataSource"})
    public DataSource DataSource(@Qualifier("DatebaseProperties") DataSourceProperties dataSourceProperties) {
        return dataSourceProperties.initializeDataSourceBuilder().build();
    }

    @Primary
    @Bean("SqlSessionFactory1")
    public SqlSessionFactory SqlSessionFactory1(@Qualifier("DataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/*.xml"));
        return bean.getObject();
    }
    @Primary
    @Bean("SqlSessionTemplate1")
    public SqlSessionTemplate SqlSessionTemplate1(@Qualifier("SqlSessionFactory1")SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

配置类DatabaseConfig2：

@Configuration
@MapperScan(basePackages = "com.***/mapper路径.bcop2021125.mapper.db2", sqlSessionFactoryRef = "SqlSessionFactory2")

public class DatabaseConfig2 {
    @Bean(name = {"DatebaseProperties2"})
    @ConfigurationProperties("spring.datasource2")
    public DataSourceProperties DataSourceProperties() {
        return new DataSourceProperties();
    }

    @Bean(name = {"DataSource2"})
    public DataSource DataSource(@Qualifier("DatebaseProperties2") DataSourceProperties dataSourceProperties) {
        return dataSourceProperties.initializeDataSourceBuilder().build();
    }

    @Bean("SqlSessionFactory2")
    public SqlSessionFactory SqlSessionFactory1(@Qualifier("DataSource2") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/*.xml"));
        return bean.getObject();
    }

    @Bean("SqlSessionTemplate2")
    public SqlSessionTemplate SqlSessionTemplate1(@Qualifier("SqlSessionFactory2")SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}