/** 
 * 動態(tài)配置多數(shù)據(jù)源 
 * 數(shù)據(jù)源的名稱常量類 
 * @author LONGHUI_LUO 
 * 
 */ 
public class DataSourceConst { 
 public static final String TEST="test"; 
 public static final String USER="User"; 
} 

/** 
 * 獲得和設(shè)置上下文環(huán)境 主要負責(zé)改變上下文數(shù)據(jù)源的名稱 
 * 
 * @author LONGHUI_LUO 
 * 
 */ 
public class DataSourceContextHolder { 
 private static final ThreadLocal contextHolder = new ThreadLocal(); // 線程本地環(huán)境 
 
 // 設(shè)置數(shù)據(jù)源類型 
 public static void setDataSourceType(String dataSourceType) { 
  contextHolder.set(dataSourceType); 
 } 
 
 // 獲取數(shù)據(jù)源類型 
 public static String getDataSourceType() { 
  return (String) contextHolder.get(); 
 } 
 
 // 清除數(shù)據(jù)源類型 
 public static void clearDataSourceType() { 
  contextHolder.remove(); 
 } 
 
} 

/** 
 * 建立動態(tài)數(shù)據(jù)源 
 * 
 * @author LONGHUI_LUO 
 * 
 */ 
public class DynamicDataSource extends AbstractRoutingDataSource { 
 
 protected Object determineCurrentLookupKey() { 
 // 在進行DAO操作前，通過上下文環(huán)境變量，獲得數(shù)據(jù)源的類型 
 return DataSourceContextHolder.getDataSourceType(); 
 } 
 
} 

  <!-- 數(shù)據(jù)源相同的內(nèi)容 --> 
<bean 
  id="parentDataSource" 
  class="org.apache.commons.dbcp.BasicDataSource" 
  destroy-method="close"> 
  <property 
   name="driverClassName" 
   value="com.microsoft.sqlserver.jdbc.SQLServerDriver" /> 
  <property name="username" value="sa" /> 
  <property name="password" value="net2com" /> 
</bean> 
<!-- start以下配置各個數(shù)據(jù)源的特性 --> 
<bean parent="parentDataSource" id="testDataSource"> 
  <propertynamepropertyname="url" value="jdbc:sqlserver://localhost:1433;databaseName=test" /> 
</bean> 
<bean parent="parentDataSource" id="UserDataSource"> 
   <property 
   name="url" 
   value="jdbc:sqlserver://localhost:1433;databaseName=User" /> 
</bean> 
<!-- end 配置各個數(shù)據(jù)源的特性 --> 

<bean class="com.xxxx.datasouce.DynamicDataSource" id="dataSource"> 
 <property name="targetDataSources"> 
  <map key-type="java.lang.String"> 
   <entry value-ref="testDataSource" key="test"></entry> 
   <entry value-ref="UserDataSource" key="User"></entry> 
  </map> 
 </property> 
 <property name="defaultTargetDataSource" ref="testDataSource" ></property> 
</bean> 

DataSourceContextHolder.setDataSourceType(DataSourceConst.TEST);