Spring MVC Mybatis多数据源的使用实例解析

<!-- 多数据源配置 --> <bean id="ds1" class="org.apache.commons.dbcp.BasicDataSource">  <property name="driverClassName" value="${jdbc.driverClassName}" />  <property name="url" value="${jdbc.url}" />  <property name="username" value="${jdbc.username}" />  <property name="password" value="" /> </bean> <bean id="ds2" class="org.apache.commons.dbcp.BasicDataSource">  <property name="driverClassName" value="" />  <property name="url" value="" />  <property name="username" value="" />  <property name="password" value="" /> </bean> <!-- 动态配置数据源 --> <bean id="dataSource" class="com.test.utils.DynamicDataSource">//这里是你项目里DynamicDataSource.java的路径  <property name="targetDataSources">   <map key-type="java.lang.String">    <entry value-ref="ds_admin" key="ds1"></entry>    <entry value-ref="ds_partner" key="ds2"></entry>   </map>  </property>  <!-- 默认使用ds1的数据源 -->  <property name="defaultTargetDataSource" ref="ds_admin"></property>   </bean>

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

public class DataSourceType { // 默认数据库 public static final String SOURCE_ADMIN = "ds1"; // 第二个数据库，在applicationContext.xml里的id public static final String SOURCE_PARTNER = "ds2";}

import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;public class DynamicDataSource extends AbstractRoutingDataSource { @Override protected Object determineCurrentLookupKey() {  return DataSourceContextHolder.getDbType(); }}