ds1.driverClassName=com.mysql.jdbc.Driver

ds1.url=jdbc:mysql://192.168.200.130:3306/test1?useUnicode=true&characterEncoding=UTF-8

ds1.username=hhh

ds1.password=123456  

ds2.driverClassName=oracle.jdbc.OracleDriver

ds2.url=jdbc:mysql://localhost:3306/test2?useUnicode=true&characterEncoding=UTF-8

ds2.username=qqq

ds2.password=123456

　　 <bean id="dataSource" class="com.hhhqqq.datasource.DynamicDataSource">

        <property name="targetDataSources">

            <map key-type="java.lang.String">

                <entry key="ds1" value-ref="ds1" />

                <entry key="ds2" value-ref="ds2" />

            </map>

        </property>

        <property name="defaultTargetDataSource" ref="ds1" />

    </bean>  

    <bean id="ds1" class="com.alibaba.druid.pool.DruidDataSource"

        destroy-method="close">

        <property name="driverClassName" value="${ds1.driverClassName}" />

        <property name="url" value="${ds1.url}" />

        <property name="username" value="${ds1.username}" />

        <property name="password" value="${ds1.password}" />

    </bean>  

    <bean id="ds2" class="com.alibaba.druid.pool.DruidDataSource"

        destroy-method="close">

        <property name="driverClassName" value="${ds2.driverClassName}" />

        <property name="url" value="${ds2.url}" />

        <property name="username" value="${ds2.username}" />

        <property name="password" value="${ds2.password}" />

    </bean>

import java.util.logging.Logger;

import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;

public class DynamicDataSource extends AbstractRoutingDataSource {

    /**

     * 取得当前使用那个数据源。

     */

    @Override

    protected Object determineCurrentLookupKey() {

        return DataSourceContextHolder.getDbType();

    }  

    public Logger getParentLogger() {

        // TODO Auto-generated method stub

        return null;

    }

}

public class DataSourceContextHolder {

    private static final ThreadLocal<String> contextHolder = new ThreadLocal<String>();  

    /**

     * 设置当前数据库。

     * @param dbType

     */

    public static void setDbType(String dbType)

    {

        contextHolder.set(dbType);

    }  

    /**

     * 取得当前数据源。

     * @return

     */

    public static String getDbType()

    {

        String str = (String) contextHolder.get();

        return str;

    }  

    /**

     * 清除上下文数据

     */

    public static void clearDbType()

    {

        contextHolder.remove();

    }

}