Springboot：多数据源（druid）

多数据源

1. pom依赖

        <!-- jdbc -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        
        <!-- alibaba的druid数据库连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
        
        <!-- oracle驱动 -->
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>11.2.0.3.0</version>
        </dependency>

<备注>oracle驱动包在MAVEN中是获取不到的，所以需要手动下载添加。

2. application.properties配置文件

#数据源配置
spring.datasource.type = com.alibaba.druid.pool.DruidDataSource
#----主数据源----
spring.datasource.primary.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.primary.url=jdbc:oracle:thin:@localhost:1521:XE
spring.datasource.primary.username=sidb
spring.datasource.primary.password=123456

#----第二数据源---
spring.datasource.secondary.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.secondary.url=jdbc:oracle:thin:@localhost:1521:XE
spring.datasource.secondary.username=sidb
spring.datasource.secondary.password=123456

#----第三数据源---
spring.datasource.third.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.third.url=jdbc:oracle:thin:@localhost:1521:XE
spring.datasource.third.username=sidb
spring.datasource.third.password=123456

#连接池配置
spring.datasource.druid.initial-size = 5
spring.datasource.druid.max-active = 20
spring.datasource.druid.min-idle = 5
spring.datasource.druid.max-wait= 30000
spring.datasource.druid.validation-query=select 1 from dual
spring.datasource.druid.test-on-borrow=true

<备注>数据源url、username、password根据自己情况配置。

3. 创建数据源配置类
   不仅配置了数据源，还创建了与数据源对应的JdbcTemplate对象。JdbcTemplate是Spring对Jdbc的深层次封装，其内部已经实现了连接的创建，关闭，异常处理等，使用时只需考虑业务逻辑即可。

@Configuration
public class DSConfigurer {

    /**
    * @Description: 创建数据源
    * @Author:
    * @Date:
    */
    @Bean(name = "primaryDataSource")
    @Primary
    @ConfigurationProperties(prefix = "spring.datasource.primary")
    public DataSource primaryDataSource(){
        return DruidDataSourceBuilder.create().build();
    }

    @Bean(name = "secondaryDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.secondary")
    public DataSource secondaryDataSource(){
        return DruidDataSourceBuilder.create().build();
    }

    @Bean(name = "thirdDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.third")
    public DataSource thirdDataSource(){
        return DruidDataSourceBuilder.create().build();
    }

    /**
    * @Description: 创建与数据源对应的JdbcTemplate
    * @Author:
    * @Date:
    */
    @Bean(name = "primaryJdbcTemplate")
    public JdbcTemplate primaryJdbcTemplate(@Qualifier("primaryDataSource")DataSource dataSource){
        return new JdbcTemplate(dataSource);
    }

    @Bean(name = "secondaryJdbcTemplate")
    public JdbcTemplate secondaryJdbcTemplate(@Qualifier("secondaryDataSource")DataSource dataSource){
        return new JdbcTemplate(dataSource);
    }
    @Bean(name = "thirdJdbcTemplate")
    public JdbcTemplate thirdJdbcTemplate(@Qualifier("thirdDataSource")DataSource dataSource){
        return new JdbcTemplate(dataSource);
    }
 }

4. 使用方式
   通过Springboot的特性直接注入获取对应数据源的JdbcTemplate对象，通过JdbcTemplate对象进行CRUD。

    @Autowired
    @Qualifier("primaryJdbcTemplate")
    private JdbcTemplate jt1;

    @Autowired
    @Qualifier("secondaryJdbcTemplate")
    private JdbcTemplate jt2;

    @Autowired
    @Qualifier("thirdJdbcTemplate")
    private JdbcTemplate jt3;