一般的小型项目可能只有一个库,不存在动态切换数据源的问题,只需配置一个数据连接池就可以很好的使用了,但是目前公司业务很广泛,目前的架构是针对分公司甚至到店面级别的按照片区或者业务量进行划分,分成了很多的库,故需要在存储数据时读取数据库配置,然后获取数据源。
public class DataSourceContextHolder {
@SuppressWarnings("rawtypes")
private static final ThreadLocal contextHolder=new ThreadLocal();
@SuppressWarnings("unchecked")
public static void setDataSourceContextHolder(String DataSourceType)
{
contextHolder.set(DataSourceType);
}
public static String getDataSourceContextHolder(){
return (String)contextHolder.get();
}
public static void clearDataSourceContextHolder(){
contextHolder.remove();
}
}
import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;
public class DynamicDataSource extends AbstractRoutingDataSource {
@Override
protected Object determineCurrentLookupKey() {
// TODO Auto-generated method stub
return DataSourceContextHolder.getDataSourceContextHolder();
}
}
配置文件如下:
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
<!-- <beans:import resource="classpath:spring/Job-context.xml" /> Root Context:
defines shared resources visible to all other web components -->
<bean id="dataSource1" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/springdb" />
<property name="username" value="root" />
<property name="password" value="123456" />
<property name="initialSize" value="1" />
<property name="maxActive" value="5"/>
</bean>
<bean id="dataSource2" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/springdb2" />
<property name="username" value="root" />
<property name="password" value="123456" />
</bean>
<bean id="dataSource" class="com.suning.common.multidatasource.DynamicDataSource">
<property name="targetDataSources">
<map>
<entry key="dataSource1" value-ref="dataSource1" />
<entry key="dataSource2" value-ref="dataSource2" />
</map>
</property>
<!-- <property name="defaultTargetDataSource" ref="dataSource1" /> -->
</bean>
<!-- jdbcTemplate -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource" />
</bean>
</beans>
使用的时候
DataSourceContextHolder.setDataSourceContextHolder("dataSource1");选择你需要的bean id就好了