转：

 

多数据源问题，目的，可以使用xml来自由配置切换的数据源

 

spring-mybatis.xml

 

1 
      2 
     
      15 16     
      17 18     
      
       20         
       
        21             
        
         22                 
         
          classpath:jdbc.properties
         23                 
         
          classpath:config.properties
         24             
        25         
       26     27     28     
       29     
       
        31         
        32         
        33         
        34         
        35         
        36         
        
        37         
        
        38         
        
        39         
        
        40     
       41     42     
       43     
       
        45         
        46         
        47         
        48         
        49         
        50         
        
        51         
        
        52         
        
        53         
        
        54     
       55     56     
       
        57         
        58         
        
         59             
         63         
        64     
       65     66     
       67     
       
        68         
        69         
        70     
       71     
       
        72         
        73     
       74 75     
       76     
       77     
       78 79     
       
        81         
        82     
       83 
      
     

 

2. DynamicDataSource.class

package com.xxx.aop;import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;public class DynamicDataSource extends AbstractRoutingDataSource{	@Override	protected Object determineCurrentLookupKey() {		return DatabaseContextHolder.getCustomerType(); 	}}

 

3. DatabaseContextHolder.class

package com.xxx.aop;public class DatabaseContextHolder {	private static final ThreadLocal
     
       contextHolder = new ThreadLocal
      
       ();	public static void setCustomerType(String customerType) {		contextHolder.set(customerType);	}	public static String getCustomerType() {		return contextHolder.get();	}	public static void clearCustomerType() {		contextHolder.remove();	}}