SpringBoot配置双数据源MySQLSQLServer

　　1、pom.xml引mysql和sql server依赖      mysql     mysql-connector-java     8.0.17        com.microsoft.sqlserver     sqljdbc4     4.0 
　　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());     } }路漫漫其修远兮，吾将上下而求索
　　译文：在追寻真理方面，前方的道路还很漫长，但我将百折不挠，不遗余力地去追求和探索。
　　如果您有什么好的想法与方法，欢迎在评论区留言，我们一起讨论~