SpringBoot 多数据源配置不同数据库配置

你的名字 2022-12-14 12:26 142阅读 0赞

今天做个呆呆，明天依旧呆呆

## sqlserver 和 oracle ##

### properties配置信息 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjYzMzEzMQ_size_16_color_FFFFFF_t_70_pic_center]

spring.datasource.secondary2012.jdbc-url=jdbc:sqlserver://ip:端口;databasename=库名
    spring.datasource.secondary2012.username= 
    spring.datasource.secondary2012.password=
    spring.datasource.secondary2012.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
    #SQLServer 连接超时配置
    #验证连接的有效性
    spring.datasource.secondary.test-while-idle=true
    #获取连接时候验证，会影响性能
    spring.datasource.secondary.test-on-borrow=true
    spring.datasource.secondary.validation-query=SELECT 1 
    #空闲连接回收的时间间隔，与test-while-idle一起使用，设置5分钟
    spring.datasource.secondary.time-between-eviction-runs-millis=300000
    #连接池空闲连接的有效时间 ，设置30分钟
    spring.datasource.secondary.min-evictable-idle-time-millis=1800000
    
    # ********************** 2014 配置 *************************************** #
    spring.datasource.oracle2014.jdbc-url=jdbc:oracle:thin:@ip:端口:ORACLE
    spring.datasource.oracle2014.username=
    spring.datasource.oracle2014.password=
    spring.datasource.oracle2014.driver-class-name=oracle.jdbc.driver.OracleDriver
    spring.datasource.max-idle=10
    spring.datasource.max-wait=10000
    spring.datasource.min-idle=5
    spring.datasource.initial-size=5

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjYzMzEzMQ_size_16_color_FFFFFF_t_70_pic_center 1]

### config ###

import com.github.pagehelper.PageInterceptor;
    import com.proapplysvr.historyMapper.history2014.Oracle2014Mapper;
    import org.apache.ibatis.plugin.Interceptor;
    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 org.springframework.jdbc.datasource.DataSourceTransactionManager;
    
    import javax.sql.DataSource;
    import java.util.Properties;
    
    
    @Configuration  
    @MapperScan(basePackages = { "com.historyMapper.history2014"}, sqlSessionTemplateRef = "oracle2014Template")
    public class Oracle2014DataConfig { 
        /** * @author * @description 2014 * @date 2020/9/14 */
        @Bean(name = "oracle2014Properties")
        @ConfigurationProperties(prefix = "spring.datasource.oracle2014")
        public DataSource oracle2014Properties() { 
            return DataSourceBuilder.create().build();
        }
        @Bean(name = "oracle2014Factory")
        public SqlSessionFactory sqlSessionFactory(@Qualifier("oracle2014Properties") DataSource dataSource)
                throws Exception { 
            SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
            bean.setDataSource(dataSource);
            bean.setMapperLocations(
                    new PathMatchingResourcePatternResolver().getResources("classpath:com/historyMapper/history2014/xml/*.xml"));
            return bean.getObject();
        }
    
        @Bean(name = "oracle2014Manager")
        public DataSourceTransactionManager transactionManager(@Qualifier("oracle2014Properties") DataSource dataSource) { 
            return new DataSourceTransactionManager(dataSource);
        }
    
        @Bean(name = "oracle2014Template")
        public SqlSessionTemplate sqlSessionTemplate(
                @Qualifier("oracle2014Factory") SqlSessionFactory sqlSessionFactory) throws Exception { 
            return new SqlSessionTemplate(sqlSessionFactory);
        }
    }

## 依赖 ##

<mssql-jdbc.version>8.2.2.jre8</mssql-jdbc.version>
     <oracle.ojdbc6.version>11.2.0.3</oracle.ojdbc6.version>
     
    		    <dependency>
                    <groupId>com.microsoft.sqlserver</groupId>
                    <artifactId>mssql-jdbc</artifactId>
                    <version>${mssql-jdbc.version}</version>
                </dependency>
    			<dependency>
                    <groupId>com.oracle</groupId>
                    <artifactId>ojdbc6</artifactId>
                    <version>${oracle.ojdbc6.version}</version>
                </dependency>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjYzMzEzMQ_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/626f428f7e004e37b16e71a11ad46eb2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjYzMzEzMQ_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221123/0264c0c07bf04301b00c5d5ea89e62c9.png