springboot+mysql+jpa 多数据源

1. springboot 自动装配

2. jpa简化数据库操作（事务支持）

3. 对于多数据库操作，可以方便查询，统计

spring.datasource.one.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.one.url=jdbc:mysql://localhost:3306/nba?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
spring.datasource.one.username=nba
spring.datasource.one.password=123456

spring.datasource.two.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.two.url=jdbc:mysql://localhost:3306/result?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
spring.datasource.two.username=nba
spring.datasource.two.password=123456

spring.datasource.three.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.three.url=jdbc:mysql://localhost:3306/china?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
spring.datasource.three.username=nba
spring.datasource.three.password=123456

spring.jpa.properties.hibernate.ddl-auto=update  //每次启动项目如果发现实体类类更新则对应着更新表结构
spring.jpa.properties.show-sql=true                //在控制台打印sql语句
spring.jpa.properties.database=mysql
spring.jpa.properties.database-platform=mysql
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL57Dialect

 链接地址：https://download.csdn.net/download/qq_31942447/86401867