Spring Boot 多数据源配置教程-优快云博客

本文链接：https://blog.youkuaiyun.com/gitblog_00319/article/details/141523730

Spring Boot 多数据源配置教程

springboot-multiple-dataSources项目地址:https://gitcode.com/gh_mirrors/sp/springboot-multiple-dataSources

项目介绍

本项目旨在展示如何在Spring Boot应用中配置和使用多个数据源。通过本项目，开发者可以学习到如何为不同的数据库配置独立的DataSource、EntityManagerFactory和TransactionManager，从而实现对多个数据库的灵活管理。

项目快速启动

环境准备

Java 8 或更高版本
Maven
两个数据库实例（例如MySQL和PostgreSQL）

克隆项目

git clone https://github.com/heikehuan/springboot-multiple-dataSources.git
cd springboot-multiple-dataSources

配置数据源

在application.properties文件中配置两个数据源的连接信息：

spring.datasource.primary.url=jdbc:mysql://localhost:3306/db1
spring.datasource.primary.username=root
spring.datasource.primary.password=root
spring.datasource.primary.driver-class-name=com.mysql.cj.jdbc.Driver

spring.datasource.secondary.url=jdbc:postgresql://localhost:5432/db2
spring.datasource.secondary.username=postgres
spring.datasource.secondary.password=postgres
spring.datasource.secondary.driver-class-name=org.postgresql.Driver

配置数据源Bean

在DataSourceConfig类中定义两个数据源的Bean：

@Configuration
public class DataSourceConfig {

    @Bean(name = "primaryDataSource")
    @Primary
    @ConfigurationProperties(prefix = "spring.datasource.primary")
    public DataSource primaryDataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "secondaryDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.secondary")
    public DataSource secondaryDataSource() {
        return DataSourceBuilder.create().build();
    }
}

配置EntityManagerFactory和TransactionManager

在JpaConfig类中配置每个数据源的EntityManagerFactory和TransactionManager：

@Configuration
@EnableJpaRepositories(
    basePackages = "com.example.demo.primary",
    entityManagerFactoryRef = "primaryEntityManagerFactory",
    transactionManagerRef = "primaryTransactionManager"
)
public class PrimaryConfig {

    @Bean(name = "primaryEntityManagerFactory")
    public LocalContainerEntityManagerFactoryBean primaryEntityManagerFactory(
            EntityManagerFactoryBuilder builder, @Qualifier("primaryDataSource") DataSource dataSource) {
        return builder
                .dataSource(dataSource)
                .packages("com.example.demo.primary.entity")
                .persistenceUnit("primaryPU")
                .build();
    }

    @Bean(name = "primaryTransactionManager")
    public PlatformTransactionManager primaryTransactionManager(
            @Qualifier("primaryEntityManagerFactory") EntityManagerFactory entityManagerFactory) {
        return new JpaTransactionManager(entityManagerFactory);
    }
}

@Configuration
@EnableJpaRepositories(
    basePackages = "com.example.demo.secondary",
    entityManagerFactoryRef = "secondaryEntityManagerFactory",
    transactionManagerRef = "secondaryTransactionManager"
)
public class SecondaryConfig {

    @Bean(name = "secondaryEntityManagerFactory")
    public LocalContainerEntityManagerFactoryBean secondaryEntityManagerFactory(
            EntityManagerFactoryBuilder builder, @Qualifier("secondaryDataSource") DataSource dataSource) {
        return builder
                .dataSource(dataSource)
                .packages("com.example.demo.secondary.entity")
                .persistenceUnit("secondaryPU")
                .build();
    }

    @Bean(name = "secondaryTransactionManager")
    public PlatformTransactionManager secondaryTransactionManager(
            @Qualifier("secondaryEntityManagerFactory") EntityManagerFactory entityManagerFactory) {
        return new JpaTransactionManager(entityManagerFactory);
    }
}