SpringBoot中实现多数据源配置：MySQL与Oracle的JDBC集成方案

1、application.properties配置&＃xff1a;

server.port&＃61;8085

server.tomcat.uri-encoding&＃61;utf-8

#MySQL

spring.datasource.primary.driver-class-name&＃61;com.mysql.jdbc.Driver

spring.datasource.primary.jdbc-url&＃61;jdbc:mysql://localhost:3306/test_spboot?characterEncoding&＃61;utf8

spring.datasource.primary.username&＃61;root

spring.datasource.primary.password&＃61;123456

#oracle

spring.datasource.secondary.driver-class-name&＃61;oracle.jdbc.driver.OracleDriver

spring.datasource.secondary.jdbc-url&＃61;jdbc:oracle:thin:&＃64;127.0.0.1:1521:XE

spring.datasource.secondary.username&＃61;user01

spring.datasource.secondary.password&＃61;user01

#视图层控制

spring.mvc.view.prefix&＃61;classpath:/templates/

spring.mvc.view.suffix&＃61;.html

spring.mvc.static-path-pattern&＃61;/static/**

2DataSourceConfig.java

package com.configuration;

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.jdbc.core.JdbcTemplate;

import javax.sql.DataSource;

&＃64;Configuration

public class DataSourceConfig {

&＃64;Bean(name &＃61; "primaryDataSource")

// &＃64;Qualifier("primaryDataSource")//原博主这里加上&＃64;Qualify 没有必要 删了也没有影响

&＃64;ConfigurationProperties("spring.datasource.primary")

public DataSource primaryDataSource() {

return DataSourceBuilder.create().build();

}

&＃64;Primary

&＃64;Bean(name &＃61; "secondaryDataSource")

// &＃64;Qualifier("secondaryDataSource") //原博主这里加上&＃64;Qualify 没有必要 删了也没有影响

&＃64;ConfigurationProperties("spring.datasource.secondary")

public DataSource secondaryDataSource() {

return DataSourceBuilder.create().build();

}

/**

* &＃64;param dataSource

* &＃64;return

* &＃64;Bean明确地指示了一种方法&＃xff0c;什么方法呢——产生一个bean的方法&＃xff0c; 并且交给Spring容器管理&＃xff1b;从这我们就明白了为啥&＃64;Bean是放在方法的注释上了&＃xff0c;

* 因为它很明确地告诉被注释的方法&＃xff0c;你给我产生一个Bean&＃xff0c;然后交给Spring容器&＃xff0c;

* 实现依赖注入

*/

&＃64;Bean(name &＃61; "primaryJdbcTemplate")

public JdbcTemplate primaryTemplate(&＃64;Qualifier("primaryDataSource") DataSource dataSource) {

return new JdbcTemplate(dataSource);

}

&＃64;Bean(name &＃61; "secondaryJdbcTemplate")

public JdbcTemplate secondaryTemplate(&＃64;Qualifier("secondaryDataSource") DataSource dataSource) {

return new JdbcTemplate(dataSource);

}

}

3使用&＃xff1a;

&＃64;Autowired

private JdbcTemplate secondaryJdbcTemplate