springmvc+hibernate配置双数据源

新建配置类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");即可使用第二个数据源