目标
- 3个数据源拥有自己的EntityManage,拥有自己的TransactionManager,Transaction支持单独使用
- 其中1个数据源需要使用JdbcTemplate,需要有事务控制
- 因为框架原因,需要对JpaRepository接口进行改动,要需要把EntityManage也添加到JpaRepository接口(取了一个新名字BaseRepository)
环境介绍
- Spring Boot v2.0.5
- Spring JPA 接口(Hibernate的EntityManage实现)
- Mysql 5.7
代码目录结构
demo
+com.xmasq.demo
+base // 该包下的内容是对对JpaRepository接口进行改动,把EntityManage也添加到BaseRepository接口
+first // 系统默认实体以及实体操作内容
+main // 运行内容
+second
+third // JdbcTemplate 操作内容
DataSourceConfig.java
DemoApplication.java
FirstConfig.java
SecondConfig.java
ThirdConfig.java
pom.xml
部分代码
pom.xml
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>6.0.6</version><!--$NO-MVN-MAN-VER$ -->
</dependency>
</dependencies>
application.properties
datasource.first.jdbc-url=jdbc:mysql://localhost:3306/first?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=Hongkong
datasource.first.username=root
datasource.first.password=
datasource.first.driver-class-name=com.mysql.cj.jdbc.Driver
datasource.second.jdbc-url=jdbc:mysql://localhost:3306/second?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=Hongkong
datasource.second.username=root
datasource.second.password=
datasource.second.driver-class-name=com.mysql.cj.jdbc.Driver
datasource.third.jdbc-url=jdbc:mysql://localhost:3306/third?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=Hongkong
datasource.third.username=root
datasource.third.password=
datasource.third.driver-class-name=com.mysql.cj.jdbc.Driver
实现自己的RepositoryBeanFactoryBean
原因:因为现在是使用JpaRepository接口,而不是具体的实现类,所以没有办法通过@PersistenceContext直接注入EntityManager,BaseRepositoryFactoryBean的实现是在生成具体接口的实现类时,把相应的EntityManager赋值进去。例如FirstRepository的EntityManager是FirstEntityManager的代理类,SecondeRepository的EntityManager是SecondEntityManager的代理类。
package com.xmasq.demo.base;
import java.io.Serializable;
import javax.persistence.EntityManager;
import org.springframework.data.jpa.repository.support.JpaRepositoryFactory;
import org.springframework.data.jpa.repository.support.JpaRepositoryFactoryBean;
import org.springframework.