其他-07-Springboot配置多数据源

其他-07-Springboot配置多数据源 1. yml配置

   # 注意，要把service层和dao层放到指定的数据源包下，当service只有实现类没接口时，可以配置一级目录，
  # 当service有接口时，必须配置指向dao层接口路径
 
 # 注意。yml配置库中，springboot2.0以上不要使用url,而是使用jdbc-url
 
  spring
  datasource:
      db1:
        jdbc-url: jdbc:oracle:thin:@10.132.119.102:1521:qmsdb
        username: mobile
        password: mobile
        driver-class-name: oracle.jdbc.OracleDriver
        hikari:
          idle-timeout: 30000
          connection-timeout: 15000
          connection-test-query: select 1 from dual
          login-timeout: 5
          max-lifetime: 900000
          maximum-pool-size: 20
          minimum-idle: 5
      db2:
        jdbc-url: jdbc:oracle:thin:@(DEscriptION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.118.159)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = mesdbstb)))
        username: Kj
        password: kjmes
        driver-class-name: oracle.jdbc.OracleDriver
        hikari:
          idle-timeout: 30000
          connection-timeout: 15000
          connection-test-query: select 1 from dual
          login-timeout: 5
          max-lifetime: 900000
          maximum-pool-size: 20
          minimum-idle: 5

2. 配置类

package cn.rp.config;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
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 tk.mybatis.spring.annotation.MapperScan;

import javax.sql.DataSource;
import java.io.IOException;
import java.sql.SQLClientInfoException;


@Configuration
@MapperScan(basePackages = {"配置dao层接口路径"},sqlSessionFactoryRef = "sqlFact")
public class db1Config {


    
    @Bean(name = "dbOne")
    @Primary
    @ConfigurationProperties(prefix = "spring.datasource.db1")
    public DataSource db1(){
        return DataSourceBuilder.create().build();
    }

    
    @Bean(name = "sqlFact")
    @Primary
    public SqlSessionFactory sqlSessionFactory(@Qualifier("dbOne")DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
         //配置mybatis的驼峰映射
        org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        configuration.setMapUnderscoreToCamelCase(true);
        bean.setConfiguration(configuration);
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath: db1
    @Bean(name = "db1Tx")
    @Primary
    public DataSourceTransactionManager db1Tx(@Qualifier("dbOne")DataSource dataSource){
        return new DataSourceTransactionManager(dataSource);
    }

    
    @Bean(name = "db1Temp")
    @Primary
    public SqlSessionTemplate tb1Temp(@Qualifier("sqlFact")SqlSessionFactory sqlSessionFactory){
        return new SqlSessionTemplate(sqlSessionFactory);
    }

}