springboot配置mysql多数据源

1.pom.xml依赖

  <!--数据库-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

2.application.yml配置多数据源,这里使用springboot+jpa

server:
  port: 7803

spring:
 datasource1:
    driver-class-name: com.mysql.jdbc.Driver
    jdbc-url: jdbc:mysql://ip1:3306/demo1?useUnicode=true&characterEncoding=UTF-8&useSSL=false 
    username: username
    password: password
 datasource2:
    driver-class-name: com.mysql.jdbc.Driver
    jdbc-url: jdbc:mysql://ip2:3306/demo2?useUnicode=true&characterEncoding=UTF-8&useSSL=false 
    username: username
    password: pwd
  buss-datasource:
    driver-class-name: com.mysql.jdbc.Driver
    jdbc-url: jdbc:mysql://ip3:3306/tnoat_news_bz?useUnicode=true&characterEncoding=UTF-8&useSSL=false 
    username: username
    password: pwd
    jpa:
      database-platform: org.hibernate.dialect.MySQL5Dialect
      show-sql: false
      hibernate:
        ddl-auto: update

3.数据库统一配置文件

package com.tnaot.recommendreckon.base.config.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;


/**
 * Author: hezishan
 * Date: 2018/5/25.
 * Description: 多数据源配置
 **/
@Configuration
public class DataSourceConfig {

    @Bean(name = "collectDataSource")
    @Qualifier("collectDataSource")
    @Primary
    @ConfigurationProperties(prefix = "spring.datasource1")
    public DataSource collectDataSource() {
        return DataSourc