SpringMVC配置连接两个数据库

<!-- 加载数据源 -->
    <!-- 数据库A连接配置 -->
    <bean id="dataSourceA" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${db.driverClassName}" />
        <property name="url" value="${db.url}" />
        <property name="username" value="${db.username}" />
        <property name="password" value="${db.password}" />
        <property name="maxActive" value="${db.maxActive}" />
        <property name="maxIdle" value="${db.maxIdle}" />
        <property name="minIdle" value="${db.minIdle}" />
        <property name="maxWait" value="${db.maxWait}" />
    </bean>

    <!-- 数据库B连接配置 -->
    <bean id="dataSourceB" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${db.driverClassName}" />
        <property name="url" value="${db.hrd.url}" />
        <property name="username" value="${db.hrd.username}" />
        <property name="password" value="${db.hrd.password}" />
        <property name="maxActive" value="${db.maxActive}" />
        <property name="maxIdle" value="${db.maxIdle}" />
        <property name="minIdle" value="${db.minIdle}" />
        <property name="maxWait" value="${db.maxWait}" />
    </bean>

    <!-- 配置数据库切换 -->
    <bean id="dynamicDataSource" class="com.DynamicDataSource">
        <property name="targetDataSources">
            <map key-type="java.lang.String">
                <entry value-ref="dataSourceA" key="dataSourceA"></entry>
                <entry value-ref="dataSourceB" key="dataSourceB"></entry>
            </map>
        </property>
        <!-- 默认连接数据库 -->
        <property name="defaultTargetDataSource" ref="dataSourceA"/>
    </bean>
    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">  
        <property name="dataSource" ref="dynamicDataSource" /> 
        <property name="packagesToScan">  
            <list>
                <value>com.web.entity</value>
                <value>com.web.B.entity</value>
            </list>
        </property>  
        <property name="hibernateProperties">  
            <!-- 以下的所有配置均没有任何变化 -->
        </property>  
    </bean>

// DynamicDataSource.java
import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;

/**
 * 数据库连接切换类
 * @author Wangbt
 *
 */
public class DynamicDataSource extends AbstractRoutingDataSource {

    public static final String DATA_SOURCE_A = "dataSourceA";
    public static final String DATA_SOURCE_B = "dataSourceB";
    private static final ThreadLocal<String> contextHolder = new ThreadLocal<String>();

    public static void setCustomerType(String customerType) {
        contextHolder.set(customerType);
    }

    public static String getCustomerType() {
        return contextHolder.get();
    }

    public static void clearCustomerType() {
        contextHolder.remove();
    }

    @Override
    protected Object determineCurrentLookupKey() {

        return getCustomerType();
    }
}

使用方式（本人当初两个数据库均为MySQL）：
DynamicDataSource.setCustomerType(DynamicDataSource.DATA_SOURCE_B);// 切换到B数据库，用完后必须再次手动切换会默认数据库，否则连接默认数据库失败
// 理解B数据进行查询等等
DynamicDataSource.setCustomerType(DynamicDataSource.DATA_SOURCE_A);// 切换回A数据库