spring:
  datasource:  #數(shù)據(jù)源
    hikari:
     # 第一個(gè)Mysql數(shù)據(jù)源配置
      master:
        jdbc-url: jdbc:mysql://127.0.0.1:3306/test1?characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true
        username: root
        password: 123456
        #  Spring Boot已經(jīng)換新的啦 
        # driverClassName: com.mysql.jdbc.Driver
        driverClassName: com.mysql.cj.jdbc.Driver
        type: com.zaxxer.hikari.HikariDataSource
         # 連接池中維護(hù)的最小空閑連接數(shù)
        minimum-idle: 5
         # 配置最大池大小
        maximum-pool-size: 15
         # 配置從池返回的連接的默認(rèn)自動(dòng)提交行為。默認(rèn)值為true。
        auto-commit: true
        # 允許連接在連接池中空閑的最長(zhǎng)時(shí)間（以毫秒為單位）
        idle-timeout: 30000 
         # 連接池的用戶定義名稱，主要出現(xiàn)在日志記錄和JMX管理控制臺(tái)中以識(shí)別池和池配置
        pool-name: HikariDataPool
         # 池中連接關(guān)閉后的最長(zhǎng)生命周期（以毫秒為單位）
        max-lifetime: 1800000
        # 客戶端等待連接池連接的最大毫秒數(shù)
        connection-timeout: 30000 
        # 測(cè)試連接
        connection-test-query: select 1 from dual
      # 第二個(gè)Oracle數(shù)據(jù)源 
      core:
        jdbc-url: jdbc:oracle:thin:@127.0.0.1:1521:test2
        username: root
        password: 123456
        driverClassName: oracle.jdbc.OracleDriver
        type: com.zaxxer.hikari.HikariDataSource
        minimum-idle: 5
        maximum-pool-size: 15
        max-lifetime: 1800000
        idle-timeout: 30000
        connection-timeout: 30000
        pool-name: HikariDataPoolOracle
        connection-test-query: select 1 from dual

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.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;

@Configuration
@MapperScan(basePackages = "com.zlc.springcloud.repository.*.coresystem", sqlSessionFactoryRef = "coreSqlSessionFactory")
public class CoreDataSourceConfig {
    @Bean(name = "coreDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.hikari.core")
    public DataSource getCoreDataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "coreSqlSessionFactory")
    public SqlSessionFactory coreSqlSessionFactory(@Qualifier("coreDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean=new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource);
        //xml位置
        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:/mapper/**/coresystem/*.xml"));
        return sqlSessionFactoryBean.getObject();

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

}

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
@MapperScan(basePackages = "com.zlc.springcloud.repository.*.master", sqlSessionFactoryRef = "masterSqlSessionFactory")
public class MasterDataSourceConfig {

    @Bean(name = "masterDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.hikari.master")
    public DataSource getMasterDataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "masterSqlSessionFactory")
    public SqlSessionFactory masterSqlSessionFactory(@Qualifier("masterDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean=new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource);
        //xml位置
        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:/mapper/**/master/*.xml"));
        return sqlSessionFactoryBean.getObject();

    }

    @Bean(name = "masterSqlSessionTemplate")
    public SqlSessionTemplate masterSqlSessionTemplate(@Qualifier("masterSqlSessionFactory") SqlSessionFactory sqlSessionFactory){
        return new SqlSessionTemplate(sqlSessionFactory);
    }
    
    @Bean(name = "MasterTransactionManager")
    public DataSourceTransactionManager transactionManager(@Qualifier("masterDataSource")DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }
}

@MapperScan(basePackages = “com.zlc.springcloud.repository.*.coresystem”, sqlSessionFactoryRef = “coreSqlSessionFactory”)

@ConfigurationProperties(prefix = “spring.datasource.hikari.core”)

 //xml位置
 sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:/mapper/**/coresystem/*.xml"));