应项目需要,需要给前端提供来自不同数据库的数据。
现集成了多种数据源:
直接贴代码:
application.yml:
#端口号:
server:
port: 8091
################日志##################
logging:
level:
com.automic.donge.dao: debug
#druid相关配置 ?serverTimezone=UTC&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false
spring:
datasource:
#druid相关配置
primary:
#监控统计拦截的filters
filters: stat
driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
url: com.alibaba.druid.pool.DruidDataSource
name: ruarlwater #数据库名称
#基本属性
jdbc-url: jdbc:sqlserver://localhost:1433;DatabaseName=ruarl
username: sa
password: Saadmin654321
second:
driver-class-name: com.mysql.jdbc.Driver
jdbc-url: jdbc:mysql://localhost:3306/aunge?serverTimezone=UTC&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false
username: root
password: root
name: automic_donge
自定义配置类
DataSourceConfig.java:
package com.automic.donge.config;
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;
/**
* @ClassName: DataSourceConfig
* @Author: Kun
* @Description:
* @Date: 2019/11/2 14:01
* @Version: 1.0
*/
@Configuration
public class DataSourceConfig {
@Bean(n