mybatisAOP多数据源配置（使用阿里数据库连接池）

由于项目中需要使用数据源，用的网上开源的项目，之前使用网上通用的多数据源配置，没有切换成功，于是采用了AOP来切换数据源。

（此处只贴出关于多数据源和其他部分的一些配置）

spring-context.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:context="http://www.springframework.org/schema/context" 
    xmlns:jdbc="http://www.springframework.org/schema/jdbc"  
    xmlns:aop="http://www.springframework.org/schema/aop" 
    xmlns:jee="http://www.springframework.org/schema/jee" 
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:util="http://www.springframework.org/schema/util"
    xmlns:task="http://www.springframework.org/schema/task" 
    xsi:schemaLocation="
        http://www.springframework.org/schema/beans 
        http://www.springframework.org/schema/beans/spring-beans-4.1.xsd 
        http://www.springframework.org/schema/context 
        http://www.springframework.org/schema/context/spring-context-4.1.xsd 
        http://www.springframework.org/schema/jdbc 
        http://www.springframework.org/schema/jdbc/spring-jdbc-4.1.xsd 
        http://www.springframework.org/schema/aop 
         http://www.springframework.org/schema/aop/spring-aop.xsd 
        http://www.springframework.org/schema/jee 
        http://www.springframework.org/schema/jee/spring-jee-4.1.xsd 
        http://www.springframework.org/schema/lang 
         http://www.springframework.org/schema/lang/spring-lang.xsd 
        http://www.springframework.org/schema/tx 
        http://www.springframework.org/schema/tx/spring-tx-4.1.xsd 
        http://www.springframework.org/schema/util 
        http://www.springframework.org/schema/util/spring-util-4.1.xsd 
        http://www.springframework.org/schema/task 
        http://www.springframework.org/schema/task/spring-task-4.1.xsd"
    default-lazy-init="true">

    <description>Spring Configuration</description>
    
    <!-- 加载配置属性文件 -->
    <context:property-placeholder ignore-unresolvable="true" location="classpath:jeesite.properties" />
    
    <!-- 加载应用属性实例，可通过  @Value("#{APP_PROP['jdbc.driver']}") String jdbcDriver 方式引用 -->
    <util:properties id="APP_PROP" location="classpath:jeesite.properties" local-override="true"/>
    
    <!-- 使用Annotation自动注册Bean，解决事物失效问题：在主容器中不扫描@Controller注解，在SpringMvc中只扫描@Controller注解。  -->
    <context:component-scan base-package="com.vcard"><!-- base-package 如果多个，用“,”分隔 -->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
    
    <bean id="jedisUtil" class="h2o.common.thirdparty.redis.JedisUtil">
        <constructor-arg>
            <list>
                <value>localhost:6379</value>
                <value>localhost:6379</value>
            </list>
        </constructor-arg>
    </bean>
    
     <!-- MyBatis begin -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- <property name="dataSource" ref="dataSource"/> -->
        <property name="dataSource" ref="dynamicDataSource"/>
        <property name="typeAliasesPackage" value="com.vcard"/>
        <property name="typeAliasesSuperType" value="com.vcard.common.persistence.BaseEntity"/>
        <property name="mapperLocations" value="classpath:/mappings/**/*.xml"/>
        <property name="configLocation" value="classpath:/mybatis-config.xml"></property>
    </bean>
    
    <!-- 扫描basePackage下所有以@MyBatisDao注解的接口 -->
    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
        <property name="basePackage" value="com.vcard"/>
        <property name="annotationClass" value="com.vcard.common.persistence.annotation.MyBatisDao"/>
    </bean>
    
    <!-- 动态数据源 -->
    <bean id="dynamicDataSource" class="com.vcard.common.db.DynamicDataSource">
         <property name="defaultTargetDataSource" ref="dataSource"/>
         <property name="targetDataSources">
             <map key-type="java.lang.String">
                 <!-- <entry key="dataSource" value-ref="dataSource"/> -->
                 <entry key="dataSource2" value-ref="dataSource2"/>
             </map>
         </property>
    </bean>
    
     <!-- 定义事务 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dynamicDataSource" />
    </bean>
    
    <!-- 配置 Annotation 驱动，扫描@Transactional注解的类定义事务  -->
    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>
    
    <!-- 拦截器方式配置事务 -->
    <tx:advice id="transactionAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="get*" propagation="REQUIRED" read-only="true"/>
            <tx:method name="find*" propagation="REQUIRED" read-only="true"/>
            <tx:method name="list*" propagation="REQUIRED" read-only="true"/>
            <tx:method name="insert*" rollback-for="java.lang.Exception" propagation="REQUIRED" read-only="false"/>
            <tx:method name="create*" rollback-for="java.lang.Exception" propagation="REQUIRED" read-only="false"/>
            <tx:method name="update*" rollback-for="java.lang.Exception" propagation="REQUIRED" read-only="false"/>
            <tx:method name="save*" rollback-for="java.lang.Exception" propagation="REQUIRED" read-only="false"/>
            <tx:method name="delete*" rollback-for="java.lang.Exception" propagation="REQUIRED" read-only="false"/>
            <tx:method name="upd*" rollback-for="java.lang.Exception" propagation="REQUIRED" read-only="false"/>
        </tx:attributes>
    </tx:advice>
    
    <bean id="transactionAdvice" class="com.vcard.common.db.DataSourceAspect"></bean>
    
    <aop:config>
        <aop:pointcut id="transactionPointcut" expression="execution(* com.vcard.second.modules.order.web.*.*(..))" />
        <aop:advisor advice-ref="transactionAdvice" pointcut-ref="transactionPointcut"/>
    </aop:config>
    
    <!-- 定义事务 -->
    <!-- <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean> -->
    <!-- MyBatis end -->
    
    <!-- 配置 JSR303 Bean Validator 定义 -->
    <bean id="validator" class="org.springframework.validation.beanvalidation.LocalValidatorFactoryBean" />

    <!-- 缓存配置 -->
    <bean id="cacheManager" class="org.springframework.cache.ehcache.EhCacheManagerFactoryBean">
        <property name="configLocation" value="classpath:${ehcache.configFile}" />
    </bean>
    
    <!-- 计划任务配置，用 @Service @Lazy(false)标注类，用@Scheduled(cron = "0 0 2 * * ?")标注方法 -->
    <task:executor id="executor" pool-size="10"/> <task:scheduler id="scheduler" pool-size="10"/>
    <task:annotation-driven scheduler="scheduler" executor="executor" proxy-target-class="true"/>
    
    <!-- 数据源配置, 使用 BoneCP 数据库连接池 -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> 
        <!-- 数据源驱动类可不写，Druid默认会自动根据URL识别DriverClass -->
        <property name="driverClassName" value="${jdbc.driver}" />
        
        <!-- 基本属性 url、user、password -->
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        
        <!-- 配置初始化大小、最小、最大 -->
        <property name="initialSize" value="${jdbc.pool.init}" />
        <property name="minIdle" value="${jdbc.pool.minIdle}" /> 
        <property name="maxActive" value="${jdbc.pool.maxActive}" />
        
        <!-- 配置获取连接等待超时的时间 -->
        <property name="maxWait" value="60000" />
        
        <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
        <property name="timeBetweenEvictionRunsMillis" value="60000" />
        
        <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
        <property name="minEvictableIdleTimeMillis" value="300000" />
        
        <property name="validationQuery" value="${jdbc.testSql}" />
        <property name="testWhileIdle" value="true" />
        <property name="testOnBorrow" value="false" />
        <property name="testOnReturn" value="false" />
        
        <!-- 打开PSCache，并且指定每个连接上PSCache的大小（Oracle使用）
        <property name="poolPreparedStatements" value="true" />
        <property name="maxPoolPreparedStatementPerConnectionSize" value="20" /> -->
        
        <!-- 配置监控统计拦截的filters -->
        <property name="filters" value="stat" /> 
    </bean>
    
    <!-- 数据源配置, 使用 BoneCP 数据库连接池 -->
    <bean id="dataSource2" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> 
        <!-- 数据源驱动类可不写，Druid默认会自动根据URL识别DriverClass -->
        <property name="driverClassName" value="${jdbc2.driver}" />
        
        <!-- 基本属性 url、user、password -->
        <property name="url" value="${jdbc2.url}" />
        <property name="username" value="${jdbc2.username}" />
        <property name="password" value="${jdbc2.password}" />
        
        <!-- 配置初始化大小、最小、最大 -->
        <property name="initialSize" value="${jdbc2.pool.init}" />
        <property name="minIdle" value="${jdbc2.pool.minIdle}" /> 
        <property name="maxActive" value="${jdbc2.pool.maxActive}" />
        
        <!-- 配置获取连接等待超时的时间 -->
        <property name="maxWait" value="60000" />
        
        <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
        <property name="timeBetweenEvictionRunsMillis" value="60000" />
        
        <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
        <property name="minEvictableIdleTimeMillis" value="300000" />
        
        <property name="validationQuery" value="${jdbc.testSql}" />
        <property name="testWhileIdle" value="true" />
        <property name="testOnBorrow" value="false" />
        <property name="testOnReturn" value="false" />
        
        <!-- 打开PSCache，并且指定每个连接上PSCache的大小（Oracle使用）
        <property name="poolPreparedStatements" value="true" />
        <property name="maxPoolPreparedStatementPerConnectionSize" value="20" /> -->
        
        <!-- 配置监控统计拦截的filters -->
        <property name="filters" value="stat" /> 
    </bean>

    <!-- 数据源配置, 使用应用服务器的数据库连接池 
    <jee:jndi-lookup id="dataSource" jndi-name="java:comp/env/jdbc/jeesite" />-->

    <!-- 数据源配置, 不使用连接池 
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${jdbc.driver}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>-->
    
</beans>

jeesite.properties

#============================#
#===== Database sttings =====#
#============================#

#oracle database settings
#jdbc.type=oracle
#jdbc.driver=oracle.jdbc.driver.OracleDriver
#jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
#jdbc.username=jeesite
#jdbc.password=123456

#mysql database setting
jdbc.type=mysql
jdbc.driver=com.mysql.jdbc.Driver
#jdbc.url=jdbc:mysql://localhost:3306/vcardjeesite?useUnicode=true&characterEncoding=utf-8
#jdbc.username=root
#jdbc.password=123456
jdbc.url=jdbc:mysql://localhost:3306/vcardjeesite?useUnicode=true&characterEncoding=utf-8
jdbc.username=changyue
jdbc.password=cykjdev164123

jdbc2.type=mysql
jdbc2.driver=com.mysql.jdbc.Driver
jdbc2.url=jdbc:mysql://localhost:3306/newmall?useUnicode=true&characterEncoding=utf-8
jdbc2.username=changyue
jdbc2.password=cykjdev164123
#jdbc2.url=jdbc:mysql://localhost:3306/newmalljeesite?useUnicode=true&characterEncoding=utf-8
#jdbc2.username=root
#jdbc2.password=123456

#mssql database settings
#jdbc.type=mssql
#jdbc.driver=net.sourceforge.jtds.jdbc.Driver
#jdbc.url=jdbc:jtds:sqlserver://localhost:1433/jeesite
#jdbc.username=sa
#jdbc.password=sa

#pool settings
jdbc.pool.init=1
jdbc.pool.minIdle=3
jdbc.pool.maxActive=20

jdbc2.pool.init=1
jdbc2.pool.minIdle=3
jdbc2.pool.maxActive=20

#jdbc.testSql=SELECT 'x'
jdbc.testSql=SELECT 'x' FROM DUAL

#redis settings
redis.keyPrefix=vcard
redis.host=localhost
redis.port=6379

#============================#
#===== System settings ======#
#============================#

#u4ea7u54c1u4fe1u606fu8bbeu7f6e
productName=u5546u6237u5F00u653Eu5E73u53F0
copyrightYear=2017
version=V1.2.7

#u6f14u793au6a21u5f0f: u4e0du80fdu64cdu4f5cu548cu4fddu5b58u7684u6a21u5757uff1a sys: area/office/user/role/menu/dict, cms: site/category
demoMode=false

#u7ba1u7406u57fau7840u8defu5f84, u9700u540cu6b65u4feeu6539uff1aweb.xml
adminPath=/a

#u524du7aefu57fau7840u8defu5f84
frontPath=/f

#u7f51u7ad9URLu540eu7f00
urlSuffix=.html

#u662fu5426u4e0du5141u8bb8u5237u65b0u4e3bu9875uff0cu4e0du5141u8bb8u60c5u51b5u4e0buff0cu5237u65b0u4e3bu9875u4f1au5bfcu81f4u91cdu65b0u767bu5f55
notAllowRefreshIndex=false

#u662fu5426u5141u8bb8u591au8d26u53f7u540cu65f6u767bu5f55
user.multiAccountLogin=true

#u5206u9875u914du7f6e
page.pageSize=10

#u7855u6b63u7ec4u4ef6u662fu5426u4f7fu7528u7f13u5b58
supcan.useCache=false

#u901au77e5u95f4u9694u65f6u95f4u8bbeu7f6e, u5355u4f4duff1au6bebu79d2, 30s=30000ms, 60s=60000ms
oa.notify.remind.interval=60000

#============================#
#==== Framework settings ====#
#============================#

#u4f1au8bddu8d85u65f6uff0c u5355u4f4duff1au6bebu79d2uff0c 20m=1200000ms, 30m=1800000ms, 60m=3600000ms
session.sessionTimeout=1800000
#u4f1au8bddu6e05u7406u95f4u9694u65f6u95f4uff0c u5355u4f4duff1au6bebu79d2uff0c2m=120000msu3002
session.sessionTimeoutClean=120000

#u7f13u5b58u8bbeu7f6e
ehcache.configFile=cache/ehcache-local.xml
#ehcache.configFile=cache/ehcache-rmi.xml

#u7d22u5f15u9875u8defu5f84
web.view.index=/a

#u89c6u56feu6587u4ef6u5b58u653eu8defu5f84
web.view.prefix=/WEB-INF/views/
web.view.suffix=.jsp

#u6700u5927u6587u4ef6u4e0au4f20u9650u5236uff0cu5355u4f4du5b57u8282. 10M=10*1024*1024(B)=10485760 bytesuff0cu9700u540cu6b65u4feeu6539uff1ackfinder.xml
web.maxUploadSize=10485760

#u65e5u5fd7u62e6u622au8bbeu7f6euff0cu6392u9664u7684URIuff1bu5305u542b @RequestMappingu6ce8u89e3u7684valueu3002uff08u5df2u4f5cu5e9fuff09
#web.logInterceptExcludeUri=/, /login, /sys/menu/tree, /sys/menu/treeData, /oa/oaNotify/self/count
#web.logInterceptIncludeRequestMapping=save, delete, import, updateSort

#u9759u6001u6587u4ef6u540eu7f00
web.staticFile=.css,.js,.png,.jpg,.gif,.jpeg,.bmp,.ico,.swf,.psd,.htc,.htm,.html,.crx,.xpi,.exe,.ipa,.apk

#u5355u70b9u767bu5f55CASu8bbeu7f6e
cas.server.url=http://127.0.0.1:8080/cas
cas.project.url=http://127.0.0.1:8080/vcard

#u5de5u4f5cu6d41u8bbeu7f6e
activiti.isSynActivitiIndetity=false
activiti.export.diagram.path=c:/activiti_diagram
#activiti font (windows font: u5b8bu4f53  linux font: simsun)
activiti.diagram.activityFontName=u5b8bu4f53
activiti.diagram.labelFontName=u5b8bu4f53
#5.21.0 u65b0u589eu53c2u6570 ,2016.06.23 u8f66u6811u708e add
activiti.diagram.annotationFontName=u5b8bu4f53
#activitiu5916u90e8u8868u5355u6839u5730u5740u914du7f6e
activiti.form.server.url=

#u4e0au4f20u6587u4ef6u7eddu5bf9u8defu5f84, u8defu5f84u4e2du4e0du5141u8bb8u5305u542bu201cuserfilesu201d
#userfiles.basedir=D:/jeesite

#u5de5u7a0bu8defu5f84uff0cu5728u4ee3u7801u751fu6210u65f6u83b7u53d6u4e0du5230u5de5u7a0bu8defu5f84u65f6uff0cu53efu518du6b64u6307u5b9au7eddu5bf9u8defu5f84u3002
#projectPath=D:\workspace\jeesite

DynamicDataSource.java

import org.aspectj.lang.annotation.Aspect;
import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;
import org.springframework.stereotype.Component;

/**
 * 多数据源配置
 */
@Component
@Aspect
public class DynamicDataSource extends AbstractRoutingDataSource {

    public DynamicDataSource() {
    }
    
    @Override
    protected Object determineCurrentLookupKey() {
        return DBContextHolder.getDbType();
    }
    
    public java.util.logging.Logger getParentLogger() {
        return null;
    }
}

DBContextHolder.java

public class DBContextHolder {
    private static ThreadLocal<String> contextHolder = new ThreadLocal<String>();
    public static String Master = "dataSource";
    public static String Slave = "dataSource2";
    
    public DBContextHolder() {
    }

    public static String getDbType() {
        String db = contextHolder.get();
        if (db == null) {
            db = Master;
        }
        return db;
    }
    
    public static void setDbType(String str) {
        contextHolder.set(str);
    }
    
    public static void setMater() {
        contextHolder.set(Master);
    }
    
    public static void serSlave() {
        contextHolder.set(Slave);
    }
    
    public static void clearDBType() {
        contextHolder.remove();
    }
}

DataSourceAspect.java

import java.lang.reflect.Method;

import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
import org.aspectj.lang.JoinPoint;
import org.springframework.aop.AfterReturningAdvice;
import org.springframework.aop.MethodBeforeAdvice;
import org.springframework.aop.ThrowsAdvice;

public class DataSourceAspect implements MethodBeforeAdvice, AfterReturningAdvice, ThrowsAdvice {
    private static final Logger log = LogManager.getLogger(DataSourceAspect.class);

    public DataSourceAspect() {
    }

    public void before(Method m, Object[] args, Object target) throws Throwable {
        try {
            if (m != null) {
                // 拦截ImsShopOrderController中的方法，切换数据源
                if ((m.getName().equals("listImsShopOrder") 
                        || m.getName().equals("sendGoods") 
                        || m.getName().equals("cancleSend")) 
                        && !m.getName().contains("FromMaster")) {
                    DBContextHolder.setDbType(DBContextHolder.Slave);
                } else {
                    DBContextHolder.setDbType(DBContextHolder.Master);
                }
            }
        } catch (Exception var5) {
            log.error("data source aspect error.", var5);
        }

    }

    public void after(JoinPoint point) {
        log.info("clear db type after method.current id {}",
                new Object[] { Long.valueOf(Thread.currentThread().getId()) });
        DBContextHolder.clearDBType();
    }

    public void afterReturning(Object returnValue, Method method, Object[] args, Object target) throws Throwable {
    }

    public void afterThrowing(Method method, Object[] args, Object target, Exception ex) throws Throwable {
        log.info("current db type {} when exception", new Object[] { DBContextHolder.getDbType() });
        DBContextHolder.setDbType(DBContextHolder.Master);
    }
}