背景： spring+mybatis项目

数据源：

    
        
             
          
         
             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
          
         
             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
          
         
             
              
                  
               
          
         
             
          
         
         
             
          
         
         
         
     
    applicationContext.xml

  MultipleDataSource实现：

package com.cnblogs.lzrabbit;import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;public class MultipleDataSource extends AbstractRoutingDataSource {    private static final ThreadLocal
    
      dataSourceKey = new InheritableThreadLocal
     
      ();    public static void setDataSourceKey(String dataSource) {        dataSourceKey.set(dataSource);    }    @Override    protected Object determineCurrentLookupKey() {        return dataSourceKey.get();    }}
     
    

使用SpringAOP方式实现自动切换：

package com.cnblogs.lzrabbit;import org.aspectj.lang.ProceedingJoinPoint;import org.aspectj.lang.annotation.Around;import org.aspectj.lang.annotation.Aspect;import org.springframework.stereotype.Component;@Component@Aspectpublic class MultipleDataSourceAspectAdvice {    @Around("execution(* com.cnblogs.lzrabbit.*.*(..))")    public Object doAround(ProceedingJoinPoint jp) throws Throwable {        if (jp.getTarget() instanceof MySqlMapper) {            MultipleDataSource.setDataSourceKey("mySqlDataSource");        } else if (jp.getTarget() instanceof SqlServerMapper) {            MultipleDataSource.setDataSourceKey("sqlServerDataSource");        }        return jp.proceed();    }}