jpa 连接多个mysql 数据库_Springboot2.0配置JPA多数据源连接两个mysql数据库详解

1. 目录结构及配置

pom.xml(不要乱放太多，会引起jar冲突，亲身体验)

4.0.0

com.luoshupeng

multidatasource

0.0.1-SNAPSHOT

jar

SpringBoot2-MultiDataSource

Spring Boot 2.0 多数据源练习程序

org.springframework.boot

spring-boot-starter-parent

2.0.0.RELEASE

UTF-8

UTF-8

1.8

org.springframework.boot

spring-boot-starter-data-jpa

org.springframework.boot

spring-boot-starter-web

org.springframework.boot

spring-boot-devtools

runtime

mysql

mysql-connector-java

runtime

org.springframework.boot

spring-boot-starter-test

test

org.springframework.boot

spring-boot-maven-plugin

2.配置文件

server.port=8080##\u7B2C\u4E00\u79CD\u65B9\u6CD5

spring.datasource.primary.name=primaryDB

spring.datasource.primary.url=jdbc:mysql://localhost:3306/shiro?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC&useSSL=true

spring.datasource.primary.username=root

spring.datasource.primary.password=spring.datasource.primary.driver-class-name=com.mysql.jdbc.Driver

##\u7B2C\u4E8C\u79CD\u65B9\u6CD5

spring.datasource.secondary.name=secondaryDB

#spring.datasource.secondary.url=jdbc:h2:mem:test-db2

spring.datasource.secondary.jdbc-url=jdbc:mysql://l