Springboot项目同时连接SQLServer数据库和MySql数据库

今天的任务就是把同时连接SQLServer和MySql的环境搭配好

在组长的帮助下，一步一步测试摸索后终于完成了！

首先是把俩个数据源写在同一个yaml里面

 

配置完成后再去创建工具类

MySql工具类代码：

package com.gl.framework.config;
import javax.sql.DataSource;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.jdbc.core.JdbcTemplate;

import com.alibaba.druid.pool.DruidDataSource;

@Configuration
public class MySqlConfig {
    private final Logger LOG = LoggerFactory.getLogger(getClass());

    @Value("${spring.datasource.druid.url}")
    private String jdbcUrl;
    @Value("${spring.datasource.driverClassName}")
    private String jdbcDriver;
    @Value("${spring.datasource.druid.username}")
    private String jdbcUserName;
    @Value("${spring.datasource.druid.password}")
    private String jdbcPassword;

    @Value("${spring.datasource.druid.initialSize}")
    private Integer initialSize = 5;