基于Spring boot+Spring data的多数据源配置及事物处理

由于近期项目中需要多数据源的配置，在网上找了好多基于Spring boot+Spring data多数据源和事物的处理，发现都比较零散，所以本人整理了一套分模块进行多数据源的配置，不说了之接上代码。

第一步：配置文件application.properties进行多数据源配置

# 数据库访问配置
spring.datasource.names=h2,basic,log
## 主数据源，默认的
spring.datasource.h2.jdbc-url = jdbc:h2:file:~/.h2/userdb
spring.datasource.h2.username = sa
spring.datasource.h2.password = sa
spring.datasource.h2.driverClassName = org.h2.Driver
#表示可以在浏览器中访问H2的控制台
spring.h2.console.enabled=true

#  数据源1（基础数据库）
spring.datasource.basic.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.basic.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.basic.jdbc-url=jdbc:mysql://127.0.0.1:3306/web_basic?useUnicode=true&characterEncoding=UTF-8
spring.datasource.basic.username=root
spring.datasource.basic.password=1qazxsw2
#  数据源2（日志数据库）
spring.datasource.log.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.log.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.log.jdbc-url=jdbc:mysql://127.0.0.1:3306/web_log?useUnicode=true&characterEncoding=UTF-8
spring.datasource.log.username=root
spring.datasource.log.password=1qazxsw2


# 下面为连接池的补充设置，应用到上面所有数据源中
# 初始化大小，最小，最大
spring.datasource.initialSize=5
spring.datasource.minIdle=5
spring.datasource.maxActive=20
# 配置获取连接等待超时的时间
spring.datasource.maxWait=60000
# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
spring.datasource.timeBetweenEvictionRunsMillis=60000
# 配置一个连接在池中最小生存的时间，单位是毫秒
spring.datasource.minEvictableIdleTimeMillis=300000
spring.datasource.validationQuery=SELECT 1 FROM t_user
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=true
spring.datasource.testOnReturn=false
# 打开PSCache，并且指定每个连接上PSCache的大小
spring.datasource.poolPreparedStatements=true
spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
spring.datasource.filters=stat,wall,log4j

第二步：添加配置DataSourceConfig类

package com.elink.dataSource;

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import javax.sql.DataSource;


@Configuration
public class DataSourceConfig {
    //内存数据源
    @Bean(name = "h2DataSource")
    @Qualifier("h2DataSource")
    @Primary
    @ConfigurationProperties(prefix="spring.datasource.h2")
    public DataSource h2DataSource() {
        return DataSourceBuilder.create().build();
    }
    //系统基础数据源
    @Bean(name = "basicDataSource")
    @Qualifier("basicDataSource")
    @ConfigurationProperties(prefix="spring.datasource.basic")
    public DataSource basicDataSource() {
        return DataSourceBuilder.create().build();
    }
    //日志数据源
    @Bean(name = "logDataSource")
    @Qualifier("logDataSource")
    @ConfigurationProperties(prefix="spring.datasource.log")
    public DataSource logDataSource() {
        return DataSourceBuilder.create().build();
    }


}  

配置各数据源的类

配置H2Config 

package com.elink.dataSource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.orm.jpa.HibernateSettings;
import org.springframework.boot.autoconfigure.orm.jpa.JpaProperties;
import org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import javax.persistence.EntityManager;
import javax.sql.DataSource;

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(
        entityManagerFactoryRef="entityManagerFactoryH2",
        transactionManagerRef="transactionManagerH2",
        basePackages= { "com.elink.h2" }) //设置Repository所在位置
public class H2Config {
        @Autowired
        @Qualifier("h2DataSource")
        private DataSource h2DataSource;
        @Autowired
        private JpaProperties jpaProperties;

        @Primary
        @Bean(name = "entityManagerH2")
        public EntityManager entityManager(EntityManagerFactoryBuilder builder) {
                return entityManagerFactoryH2(builder).getObject().createEntityManager();
        }

        @Primary
        @Bean(name = "entityManagerFactoryH2")
        public LocalContainerEntityManagerFactoryBean entityManagerFactoryH2 (EntityManagerFactoryBuilder builder) {
                return builder
                        .dataSource(h2DataSource)
                        .properties(jpaProperties.getProperties())
                        .packages("com.elink.h2") //设置实体类所在位置
                        .persistenceUnit("h2PersistenceUnit")
                        .build();
        }


        @Primary
        @Bean(name = "transactionManagerH2")
        public PlatformTransactionManager transactionManagerH2(EntityManagerFactoryBuilder builder) {
                return new JpaTransactionManager(entityManagerFactoryH2(builder).getObject());
        }
} 

配置BasicConfig 

package com.elink.dataSource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.orm.jpa.JpaProperties;
import org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import javax.persistence.EntityManager;
import javax.sql.DataSource;

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(
        entityManagerFactoryRef="entityManagerFactoryBasic",
        transactionManagerRef="transactionManagerBasic",
        basePackages= { "com.elink.system" }) //设置Repository所在位置
public class BasicConfig {
        @Autowired
        @Qualifier("basicDataSource")
        private DataSource basicDataSource;
        @Autowired
        private JpaProperties jpaProperties;

        @Bean(name = "entityManagerBasic")
        public EntityManager entityManager(EntityManagerFactoryBuilder builder) {
                return entityManagerFactoryBasic(builder).getObject().createEntityManager();
        }

        @Bean(name = "entityManagerFactoryBasic")
        public LocalContainerEntityManagerFactoryBean entityManagerFactoryBasic (EntityManagerFactoryBuilder builder) {
                return builder
                        .dataSource(basicDataSource)
                        .properties(jpaProperties.getProperties())
                        .packages("com.elink.system") //设置实体类所在位置
                        .persistenceUnit("basicPersistenceUnit")
                        .build();
        }


        @Bean(name = "transactionManagerBasic")
        public PlatformTransactionManager transactionManagerBasic(EntityManagerFactoryBuilder builder) {
                return new JpaTransactionManager(entityManagerFactoryBasic(builder).getObject());
        }
} 

配置LogConfig 

package com.elink.dataSource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.orm.jpa.JpaProperties;
import org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import javax.persistence.EntityManager;
import javax.sql.DataSource;

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(
        entityManagerFactoryRef="entityManagerFactoryLog",
        transactionManagerRef="transactionManagerLog",
        basePackages= { "com.elink.log" }) //设置Repository所在位置
public class LogConfig {
        @Autowired
        @Qualifier("logDataSource")
        private DataSource logDataSource;
        @Autowired
        private JpaProperties jpaProperties;


        @Bean(name = "entityManagerLog")
        public EntityManager entityManager(EntityManagerFactoryBuilder builder) {
                return entityManagerFactoryLog(builder).getObject().createEntityManager();
        }

        @Bean(name = "entityManagerFactoryLog")
        public LocalContainerEntityManagerFactoryBean entityManagerFactoryLog (EntityManagerFactoryBuilder builder) {
                return builder
                        .dataSource(logDataSource)
                        .properties(jpaProperties.getProperties())
                        .packages("com.elink.log") //设置实体类所在位置
                        .persistenceUnit("logPersistenceUnit")
                        .build();
        }

        @Bean(name = "transactionManagerLog")
        public PlatformTransactionManager transactionManagerLog(EntityManagerFactoryBuilder builder) {
                return new JpaTransactionManager(entityManagerFactoryLog(builder).getObject());
        }
} 

第三步：在主程序入口处添加@EnableTransactionManagement事物的注解。

package com.elink;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@SpringBootApplication
@EnableTransactionManagement
public class WebApplication {
	public static void main(String[] args) {
		SpringApplication.run(WebApplication.class, args);
	}
}

用法：各模块包之间的数据源事物相对独立。对应的代码直接在配置的包里面。

事物用注解配置在ServiceImpl类上：

注：Spring boot的版本是2.1，特别注意，Spring boot 2.0以后在配置数据库时一定要注意，

否则启动会报错。

Spring boot的版本是2.0之前的配置：

Spring boot的版本是2.0之后的配置：

最后在发张运行时的截图：

本人经验不是很足，还望大神们不要吐槽。。。。