SpringBoot2.x配置多个数据库

我使用的数据源是HikariDataSource,使用的mysql8.0以上版本，首先在配置文件中bootstrap.yml:

spring:
  application:
    name: order-service
  datasource:
    order-service:
      driver-class-name: com.mysql.cj.jdbc.Driver
      username: root
      password: root
      jdbc-url: jdbc:mysql://127.0.0.1:3306/seata-order?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true
    storage-service:
      driver-class-name: com.mysql.cj.jdbc.Driver
      username: root
      password: root
      jdbc-url: jdbc:mysql://127.0.0.1:3306/seata-storage?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true
 

最重要的是配置类：

package com.alibaba.seata.config;

import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
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 org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

@Configuration
//配置mybatis接口
@MapperScan(basePackages = "com.alibaba.seata.mapper.orderMapper", sqlSessionFactoryRef = "orderSqlSessionFactory")
public class OrderDataSourceConfig {


    //将对象放入容器中
    @Bean(name = "orderDataSource")
    //yml配置的对象
    @ConfigurationProperties(prefix = "spring.datasource.order-service")
    public DataSource getOrderDataSource() {
        System.out.println("使用Order新的数据源");
        return DataSourceBuilder.create().build();
    }


    @Bean(name = "orderSqlSessionFactory")
    //@Qualifier 查找Spring 容器中名为articleServiceDataSource的对象
    public SqlSessionFactory orderSqlSessionFactory(@Qualifier("orderDataSource") DataSource dataSource) throws Exception {
        MybatisSqlSessionFactoryBean bean = new MybatisSqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        //mybatis扫描xml所在位置
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:/mapper/orderMapper/*.xml"));
        return bean.getObject();
    }


    @Bean(name="orderTransactionManager")//配置事务
    public DataSourceTransactionManager testTransactionManager(@Qualifier("orderDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }


    @Bean(name = "orderSqlSessionTemplate")
    public SqlSessionTemplate orderSqlSessionTemplate(@Qualifier("orderSqlSessionFactory") SqlSessionFactory sqlSessionFactory){
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

package com.alibaba.seata.config;

import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
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 org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

@Configuration
//配置mybatis接口
@MapperScan(basePackages = "com.alibaba.seata.mapper.storageMapper", sqlSessionFactoryRef = "storageSqlSessionFactory")
public class StorageDataSourceConfig {

    //@Primary //使用该注解，表示发现使用同样类型的bean，优先使用带有该注解的方法进行注入
    //将对象放入容器中
    @Bean(name = "storageDataSource")
    //yml配置的对象
    @ConfigurationProperties(prefix = "spring.datasource.storage-service")
    public DataSource getStorageDataSource() {
        System.out.println("使用Storage新的数据源");
        return DataSourceBuilder.create().build();
    }


    @Bean(name = "storageSqlSessionFactory")
    //@Qualifier 查找Spring 容器中名为articleServiceDataSource的对象
    public SqlSessionFactory storageSqlSessionFactory(@Qualifier("storageDataSource") DataSource dataSource) throws Exception {
        MybatisSqlSessionFactoryBean bean = new MybatisSqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        //mybatis扫描xml所在位置
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:/mapper/storageMapper/*.xml"));
        return bean.getObject();
    }


    @Bean(name="storageTransactionManager")//配置事务
    public DataSourceTransactionManager testTransactionManager(@Qualifier("storageDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }


    @Bean(name = "storageSqlSessionTemplate")
    public SqlSessionTemplate storageSqlSessionTemplate(@Qualifier("storageSqlSessionFactory") SqlSessionFactory sqlSessionFactory){
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}