配置多数据源

前言

         单数数据源的时代一去不复返，多数据源应用越来越广泛，配置各种连接执行器方便
    在不同的情况下进行使用，下面就原生的 jdbcTemplate 进行注入和配置

代码

采用Springboot Bean注入的模式

package XXXXXX;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.jdbc.core.JdbcTemplate;

/**
 * @Author Windwardbird
 * @time 2020/9/27 14:23
 * @describeOfFunction:  注入原生的JdbcTemplate
 */
@Configuration
public class PrimitiveDataSourceConfig {


     @Primary()
     @Bean(name = "primaryDataSource")
    @Qualifier("primaryDataSource")
    @ConfigurationProperties("spring.datasource.druid.mycat")
    public DruidDataSource primaryDataSource() {
        return DruidDataSourceBuilder.create().build();
    }

 
    @Bean(name = "secondaryDataSource")
    @Qualifier("secondaryDataSource")
    @ConfigurationProperties("spring.datasource.druid.mysql")
    public DruidDataSource secondaryDataSource() {
        return DruidDataSourceBuilder.create().build();
    }


    @Bean(name = "thirdDataSource")
    @Qualifier("thirdDataSource")
    @ConfigurationProperties("spring.datasource.druid.Oracle")
    public DruidDataSource  thirdDataSource() {
        return DruidDataSourceBuilder.create().build();
    }
   
    @Bean(name = "primaryJdbcTemplate")
    public JdbcTemplate primaryTemplate(@Qualifier("primaryDataSource") DruidDataSource dataSource) {
        return new JdbcTemplate(dataSource);
    }

    @Bean(name = "secondaryJdbcTemplate")
    public JdbcTemplate secondaryTemplate(@Qualifier("secondaryDataSource") DruidDataSource dataSource) {
        return new JdbcTemplate(dataSource);
    }

    @Bean(name = "thirdJdbcTemplate")
    public JdbcTemplate secondaryTemplate(@Qualifier(""thirdDataSource") DruidDataSource dataSource) {
        return new JdbcTemplate(dataSource);
    }


}

项目使用
@Resource（name ="primaryJdbcTemplate"）
private  JdbcTemplate  mycatJdbcTemplate 

@Resource（name ="secondaryJdbcTemplate"）
private  JdbcTemplate  mysqlJdbcTemplate 

@Resource（name ="thirdJdbcTemplate"）
private  JdbcTemplate  oracleJdbcTemplate