Spring多数据源的动态切换

public class DynamicDataSource extends AbstractRoutingDataSource{
 private final static Logger  logger  = LoggerFactory.getLogger("DynamicDataSource");   
 
    @Override  
    protected Object determineCurrentLookupKey() {   
        return DbContextHolder.getDbType();   
    }   
}

public class DbContextHolder {
 private static final ThreadLocal contextHolder = new ThreadLocal();   
   
    public static void setDbType(String dbType) {   
        contextHolder.set(dbType);   
    }   
  
    public static String getDbType() {   
        return (String) contextHolder.get();   
    }   
  
    public static void clearDbType() {   
        contextHolder.remove();   
    }   
}

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 3 xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context"
 4 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
 5 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd"
 6 default-autowire="byName">
 7 
 8 <bean id="aTestDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
 9 <property name="driverClassName" value="${a.jdbc.driverClassName}" />
10 <property name="url" value="${a.jdbc.url}" />
11 <property name="username" value="${a.jdbc.username}" />
12 <property name="password" value="${a.jdbc.password}" />
13 </bean>
14 
15 <bean id="bTestDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
16 <property name="driverClassName" value="${b.jdbc.driverClassName}" />
17 <property name="url" value="${gott.jdbc.url}" />
18 <property name="username" value="${b.jdbc.username}" />
19 <property name="password" value="${b.jdbc.password}" />
20 </bean>
21 
22 <bean id="dataSource" class="***.DynamicDataSource">
23 <property name="targetDataSources">
24 <map key-type="java.lang.String">
25 <entry key="aTestDataSource" value-ref="aTestDataSource" />
26 <entry key="bTestDataSource" value-ref="bTestDataSource" />
27 </map>
28 </property>
29 <property name="aTestDataSource" ref="aTestDataSource" />
30 </bean>
31 </beans>

DbContextHolder.setDbType("aTestDataSource");