SpringBoot 配置双数据源MySQL、SQL Server

1、pom.xml引mysql和sql server依赖

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.17</version>
</dependency>

<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>sqljdbc4</artifactId>
    <version>4.0</version>
</dependency>

2、application.yml配置mysql和sql server连接数据源的信息

spring:
  datasource:
    mysql:
      username: root
      password: 123456
      driver-class-name: com.mysql.cj.jdbc.Driver
      jdbc-url: jdbc:mysql://127.0.0.1:3306/testdb?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=Asia/Shanghai
    sql-server:
      username: sa
      password: 123456
      driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
      jdbc-url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=testdb

3、创建DataSourceConfig.java工具类

import javax.sql.DataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Primary;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Configuration;
import org.springframework.boot.context.properties.ConfigurationProperties;

@Configuration
public class DataSourceConfig {
    @Primary
    @Bean(name = "mysql")
    @ConfigurationProperties(prefix = "spring.datasource.mysql")
    public DataSource mysql() {
        return DataSourceBuilder.create().build();
    }

    @Primary
    @Bean(name = "sql-server")
    @ConfigurationProperties(prefix = "spring.datasource.sql-server")
    public DataSource sqlServer() {
        return DataSourceBuilder.create().build();
    }
}

4、创建mysql数据源配置工具类MySqlConfig.java

import javax.sql.DataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Primary;
import org.springframework.context.annotation.Configuration;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;

import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.apache.ibatis.session.SqlSessionFactory;
import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;

@Configuration
@MapperScan(basePackages = {"com.baige.mapper.mysql"}, sqlSessionFactoryRef = "mySqlSqlSessionFactory")
public class MySqlConfig {
    @Autowired
    private Config config;

    @Autowired
    @Qualifier("mysql")
    private DataSource mysqlDataSource;

    @Primary
    @Bean(name = "mySqlSqlSessionFactory")
    public SqlSessionFactory mysqlSqlSessionFactory() throws Exception {
        MybatisSqlSessionFactoryBean factoryBean = new MybatisSqlSessionFactoryBean();
        factoryBean.setDataSource(mysqlDataSource);
        factoryBean.setPlugins(config.paginationInterceptor());
        return factoryBean.getObject();
    }

    @Bean
    @Primary
    public SqlSessionTemplate mysqlSqlSessionTemplate() throws Exception {
        return new SqlSessionTemplate(mysqlSqlSessionFactory());
    }
}

5、创建sql server数据源配置工具类SqlServerConfig.java

import javax.sql.DataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Primary;
import org.springframework.context.annotation.Configuration;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;

import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.apache.ibatis.session.SqlSessionFactory;
import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;

@Configuration
@MapperScan(basePackages = {"com.baige.mapper.sqlserver"}, sqlSessionFactoryRef = "sqlServerSqlSessionFactory")
public class SqlServerConfig {
    @Autowired
    private Config config;

    @Autowired
    @Qualifier("sql-server")
    private DataSource sqlServerDataSource;

    @Primary
    @Bean(name = "sqlServerSqlSessionFactory")
    public SqlSessionFactory sqlServerSqlSessionFactory() throws Exception {
        MybatisSqlSessionFactoryBean factoryBean = new MybatisSqlSessionFactoryBean();
        factoryBean.setDataSource(sqlServerDataSource);
        factoryBean.setPlugins(config.paginationInterceptor());
        return factoryBean.getObject();
    }

    @Bean
    @Primary
    public SqlSessionTemplate sqlServerSqlSessionTemplate() throws Exception {
        return new SqlSessionTemplate(sqlServerSqlSessionFactory());
    }
}