spring 多数据源 mysql ，oracle

       
    <!-- mysql 配置数据源 -->
    <bean id="dataSource_mysql" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${mysql.driverClassName}"></property>
        <property name="jdbcUrl" value="${mysql.url}"></property>
        <property name="user" value="${mysql.username}"></property>
        <property name="password" value="${mysql.password}"></property>
    </bean>

    <!-- oracle 配置数据源 -->
    <bean id="dataSource_oracle" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${oracle.driverClassName}"></property>
        <property name="jdbcUrl" value="${oracle.url}"></property>
        <property name="user" value="${oracle.username}"></property>
        <property name="password" value="${oracle.password}"></property>
    </bean>
    
    <!-- DynamicDataSource 多数据源配置  -->
    <bean id="dataSource" class="com.ystx.generalmanage.Dynamic.DynamicDataSource">
        <property name="targetDataSources">
            <map key-type="java.lang.String">
                <entry value-ref="dataSource_mysql" key="dataSource_mysql"></entry>
                <entry value-ref="dataSource_oracle" key="dataSource_oracle"></entry>
            </map>
        </property>
        <!-- 默认使用dataSource_mysql的数据源 -->
        <property name="defaultTargetDataSource" ref="dataSource_mysql"></property>
    </bean>
    
    <!-- 配置mybatis的sqlSessionFactory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!-- 自动扫描mappers.xml文件 -->
        <property name="mapperLocations"
            value="classpath:com/ystx/generalmanage/mappers/*/*.xml"></property>
        <!-- mybatis配置文件 -->
        <property name="configLocation" value="classpath:mybatis-config.xml"></property>
    </bean>

public class DatabaseContextHolder {
	
	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();
	}
}

@Component
public class DataSourceInterceptor {

    public void setdataSourceMysql(JoinPoint jp) {  
        DatabaseContextHolder.setCustomerType("dataSource_mysql");  
    }  
      
    public void setdataSourceOracle(JoinPoint jp) {  
        DatabaseContextHolder.setCustomerType("dataSource_oracle");  
    } 

public class DynamicDataSource extends AbstractRoutingDataSource{  
	  
    @Override  
    protected Object determineCurrentLookupKey() {  
        return DatabaseContextHolder.getCustomerType();   
    }  
  
}  

public class WebServiceCableImpl implements IWebServiceCable {

    @Autowired
    private IService service;	
public String Test(String qtr) {
		//DatabaseContextHolder.setCustomerType("dataSource_oracle");
       DatabaseContextHolder.setCustomerType("dataSource_mysql"); 
       service.xxx();
} 
}

测试成功