背景:
項目需要操作多個數據庫,多個不同類型的數據庫,進行數據操作。
1.默認數據源的注入
DataSourceConfig.java
import java.util.HashMap;
import java.util.Map;
import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.env.Environment;
import com.alibaba.druid.pool.DruidDataSource;
import com.xxx.provider.dds.DynamicDataSource;
@Configuration
public class DataSourceConfig {
@Autowired
private Environment env;
@Bean(name = "baseDataSource", destroyMethod = "close")
public DataSource baseDataSource() {
DruidDataSource basedataSource = new DruidDataSource();
basedataSource.setName("base");
basedataSource.setUrl(env.getProperty("spring.datasource.url"));
basedataSource.setUsername(env.getProperty("spring.datasource.username"));// 用户名
basedataSource.setPassword(env.getProperty("spring.datasource.password"));// 密码
basedataSource.setDriverClassName(env.getProperty("spring.datasource.driver-class-name"));
basedataSource.setInitialSize(Integer.parseInt(env.getProperty("spring.datasource.initialSize")) );// 初始化时建立物理连接的个数
basedataSource.setMaxActive(Integer.parseInt(env.getProperty("spring.datasource.maxActive")));// 最大连接池数量
basedataSource.setMinIdle(Integer.parseInt(env.getProperty("spring.datasource.minIdle")));// 最小连接池数量
basedataSource.setMaxWait(Integer.parseInt(env.getProperty("spring.datasource.maxWait")));// 获取连接时最大等待时间,单位毫秒。
basedataSource.setValidationQuery(env.getProperty("spring.datasource.validationQuery"));// 用来检测连接是否有效的sql
basedataSource.setTestOnBorrow(Boolean.parseBoolean(env.getProperty("spring.datasource.testOnBorrow")));// 申请连接时执行validationQuery检测连接是否有效
basedataSource.setTestWhileIdle(Boolean.parseBoolean(env.getProperty("spring.datasource.testWhileIdle")));// 建议配置为true,不影响性能,并且保证安全性。
basedataSource.setPoolPreparedStatements(Boolean.parseBoolean(env.getProperty("spring.datasource.poolPreparedStatements")));//
return basedataSource;
}
@Primary
@Bean(name="dataSource")
public DataSource dataSource() {
DynamicDataSource dynamicDataSource=new DynamicDataSource();
Map<Object,Object> targetDataSources=new HashMap<>();
targetDataSources.put("base",baseDataSource());
dynamicDataSource.setDefaultTargetDataSource(baseDataSource());
dynamicDataSource.setTargetDataSources(targetDataSources);
dynamicDataSource.addTargetDataSource("base",baseDataSource());
return dynamicDataSource;
}
}
application.properties
### db config ###
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassName=oracle.jdbc.driver.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@xx.xxx.xxx.xx:1521:abc
spring.datasource.username=dbuname
spri