新建配置类DynamicDataSourceHolder、DynamicDataSource
public class DynamicDataSourceHolder {
private static final ThreadLocal<String> THREAD_DATA_SOURCE = new ThreadLocal<String>();
public static String getDatasource(){
return THREAD_DATA_SOURCE.get();
}
public static void setDataSource(String dataSource){
THREAD_DATA_SOURCE.set(dataSource);
}
public static void clearDataSource(){
THREAD_DATA_SOURCE.remove();
}
}
import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;
public class DynamicDataSource extends AbstractRoutingDataSource {
@Override
protected Object determineCurrentLookupKey() {
return DynamicDataSourceHolder.getDatasource();
}
}
xml配置文件中配置双数据源
<bean id="datasource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url"
value="jdbc:mysql://127.0.0.1:3306/production" />
<property name="username" value="root" />
<property name="password" value="root" />
</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://127.0.0.1:3306/hamster" />
<property name="username" value="root" />
<property name="password" value="root" />
</bean>
配置dynamicDataSource的bean,class指向新建的DynamicDataSource配置类
工厂数据源配置新建的dynamicDataSource的bean
<bean id="dynamicDataSource" class="cn.vsx.hamster.production.system.DynamicDataSource">
<property name="targetDataSources">
<map key-type="java.lang.String">
<entry key="datasource" value-ref="datasource"></entry>
<entry key="datasource2" value-ref="datasource2"></entry>
</map>
</property>
<property name="defaultTargetDataSource" ref="datasource"/>
</bean>
<bean id="entityManagerFactory"
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<property name="dataSource" ref="dynamicDataSource" />
<property name="persistenceXmlLocation" value="classpath:/persistence.xml" />
<property name="persistenceProviderClass" value="org.hibernate.ejb.HibernatePersistence" />
<property name="persistenceUnitName" value="hamster" />
<property name="jpaVendorAdapter">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter" />
</property>
</bean>
通过DynamicDataSourceHolder.setDataSource("datasource2");即可使用第二个数据源