spring+mybatis多数据源-测试可行

spring+mybatis多数据源-测试可行

个人笔记:
1.核心就是启动的时候,配置多个数据源.
2.在配置文件中,根据数据源的key,来注入到管理

	<bean id="dataSource" class="com.itrus.portal.DataSources.ThreadLocalRountingDataSource">
        <property name="defaultTargetDataSource" ref="dataSourceMaster" />
        <property name="targetDataSources">
            <map key-type="com.itrus.portal.DataSources.DataSources">
                <entry key="MASTER" value-ref="dataSourceMaster"/>
                <entry key="SLAVE" value-ref="dataSourceSlave"/>
                <!-- 这里还可以加多个dataSource -->
            </map>
        </property>
    </bean>

核心是在类AbstractRoutingDataSource的继承和使用上

public abstract class AbstractRoutingDataSource extends AbstractDataSource implements InitializingBean {
	//全部的数据源map,根据key-value来选择对应的数据源
	private Map<Object, Object> targetDataSources;
	//默认的数据源
	private Object defaultTargetDataSource;

3.使用一些方式,比如AOP等,在执行一些方法的时候,切换到指定的数据源(主要就是通过继承AbstractRoutingDataSource类,覆盖determineCurrentLookupKey()方法来实现)

4.数据源在决定用哪个数据源的时候,调用AbstractRoutingDataSource类的下面的方法,来切换到指定的数据源.
用ThreadLocal来保证线程安全

//在属性注入完成之后,复制targetDataSources到resolvedDataSources 
	@Override
	public void afterPropertiesSet() {
		if (this.targetDataSources == null) {
			throw new IllegalArgumentException("Property 'targetDataSources' is required");
		}
		this.resolvedDataSources = new HashMap<Object, DataSource>(this.targetDataSources.size());
		for (Map.Entry<Object, Object> entry : this.targetDataSources.entrySet()) {
			Object lookupKey = resolveSpecifiedLookupKey(entry.getKey());
			DataSource dataSource = resolveSpecifiedDataSource(entry.getValue());
			this.resolvedDataSources.put(lookupKey, dataSource);
		}
		if (this.defaultTargetDataSource != null) {
			this.resolvedDefaultDataSource = resolveSpecifiedDataSource(this.defaultTargetDataSource);
		}
	}
//由对应的子类的来继承,决定使用哪个key作为当前线程所对应的数据源的key
protected abstract Object determineCurrentLookupKey();

//根据key,查找resolvedDataSources中的数据源
protected DataSource determineTargetDataSource() {
		Assert.notNull(this.resolvedDataSources, "DataSource router not initialized");
		Object lookupKey = determineCurrentLookupKey();
		DataSource dataSource = this.resolvedDataSources.get(lookupKey);
		if (dataSource == null && (this.lenientFallback || lookupKey == null)) {
			dataSource = this.resolvedDefaultDataSource;
		}
		if (dataSource == null) {
			throw new IllegalStateException("Cannot determine target DataSource for lookup key [" + lookupKey + "]");
		}
		return dataSource;
	}

主要参考:
https://www.cnblogs.com/digdeep/p/4512368.html

相关代码如下

package com.itrus.portal.DataSources;

/**
 * 数据源的类别：master/slave
 */
public enum DataSources {
    MASTER, SLAVE
}

---

package com.itrus.portal.DataSources;


public class DataSourceTypeManager {
    private static final ThreadLocal<DataSources> dataSourceTypes = new ThreadLocal<DataSources>(){
        @Override
        protected DataSources initialValue(){
            return DataSources.MASTER;
        }
    };
    
    public static DataSources get(){
        return dataSourceTypes.get();
    }
    
    public static void set(DataSources dataSourceType){
        dataSourceTypes.set(dataSourceType);
    }
    
    public static void reset(){
        dataSourceTypes.set(DataSources.MASTER);
    }
}

---

package com.itrus.portal.DataSources;
import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;

public class ThreadLocalRountingDataSource extends AbstractRoutingDataSource {
    @Override
    protected Object determineCurrentLookupKey() {
        return DataSourceTypeManager.get();
    }
}

---

package com.itrus.portal.DataSources;

import org.aspectj.lang.JoinPoint;
import org.aspectj.lang.annotation.Aspect;
import org.aspectj.lang.annotation.Before;
import org.aspectj.lang.annotation.Pointcut;
import org.springframework.core.annotation.Order;
import org.springframework.stereotype.Component;

@Aspect    // for aop
@Component // for auto scan
@Order(0)  // execute before @Transactional
public class DataSourceInterceptor {    
    @Pointcut("execution(public * com.itrus.portal.DataSources.SlaveDataSouceTestService.test(..))")
    public void dataSourceSlave(){};
    
    @Before("dataSourceSlave()")
    public void before(JoinPoint jp) {
        DataSourceTypeManager.set(DataSources.SLAVE);
    }
}

---

package com.itrus.portal.DataSources;

import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
@Controller
@RequestMapping("/test")
public class SlaveDataSouceTestController {

	@Autowired
	SlaveDataSouceTestService slaveDataSouceTestService;
	
	/**
	 * /test/SlaveDataSouceTest
	 * @return
	 */
	@RequestMapping("/SlaveDataSouceTest")
	@ResponseBody
	public String test(){
		slaveDataSouceTestService.test();
		return "SlaveDataSouceTest";
	}
}

---

package com.itrus.portal.DataSources;

import java.util.Date;

import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.web.bind.annotation.RequestMapping;

import com.itrus.portal.db.SysLog;

@Component
public class SlaveDataSouceTestService {

	@Autowired
	SqlSession SqlSession;
	
	public SysLog test(){
		SysLog sysLog = new SysLog();
		sysLog.setCreateTime(new Date());
		sysLog.setInfo("11");
		sysLog.setIp("22");
		sysLog.setType("33");
		SqlSession.insert("com.itrus.portal.db.SysLogMapper.insert", sysLog);
		return sysLog;
	}
	
}

---

spring配置文件

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"
	xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:jdbc="http://www.springframework.org/schema/jdbc"
	xmlns:util="http://www.springframework.org/schema/util" xmlns:task="http://www.springframework.org/schema/task"
	xsi:schemaLocation="
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
		http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.3.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
		http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.3.xsd
		http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.3.xsd
		http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.3.xsd">
	<!-- This will automatically locate any and all property files you have 
		within your classpath, provided they fall under the META-INF/spring directory. 
		The located property files are parsed and their values can then be used within 
		application context files in the form of ${propertyKey}. -->
	<context:property-placeholder location="classpath:config/*.properties" />
	<util:properties id="confInfo"
		location="classpath:config/keyInfos.properties" />
	<context:spring-configured />

	<context:component-scan base-package="com.itrus.portal">
		<context:exclude-filter expression=".*_Roo_.*"
			type="regex" />
		<context:exclude-filter expression="org.springframework.stereotype.Controller"
			type="annotation" />
	</context:component-scan>
	<!--<tx:annotation-driven transaction-manager="transactionManager"/> -->
	<!-- -->
	<bean id="mailSender" class="org.springframework.mail.javamail.JavaMailSenderImpl" />
	<bean id="velocityEngine"
		class="org.springframework.ui.velocity.VelocityEngineFactoryBean">
		<property name="resourceLoaderPath" value="classpath:/templates" 	/>
	</bean>
	<!-- Resolves localized messages*.properties and application.properties 
		files in the application to allow for internationalization. The messages*.properties 
		files translate Roo generated messages which are part of the admin interface, 
		the application.properties resource bundle localizes all application specific 
		messages such as entity names and menu items. -->
	<bean id="messageSource"
		class="org.springframework.context.support.ReloadableResourceBundleMessageSource">
		<property name="basename" value="WEB-INF/i18n/messages" />
		<property name="fallbackToSystemLocale" value="false" />
	</bean>
	<!-- druid连接池：http://blog.csdn.net/hj7jay/article/details/51686418 -->
	<bean id="dataSourceMaster" class="com.alibaba.druid.pool.DruidDataSource"
		init-method="init" destroy-method="close">
		<property name="url"
			value="${database.url}?rewriteBatchedStatements=true&amp;autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF-8" />
		<property name="username" value="${database.username}" />
		<property name="password" value="${database.password}" />

		<!-- 配置初始化大小、最小、最大 -->
		<property name="initialSize" value="10" />
		<property name="minIdle" value="10" />
		<property name="maxActive" value="64" />
		<!-- 配置获取连接等待超时的时间 -->
		<property name="maxWait" value="60000" />
		<!-- 配置间隔10分钟才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
		<property name="timeBetweenEvictionRunsMillis" value="600000" />
		<!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
		<property name="minEvictableIdleTimeMillis" value="1800000" />
		<property name="validationQuery" value="SELECT 'x'" />
		<property name="testWhileIdle" value="true" />
		<property name="testOnBorrow" value="true" />
		<property name="testOnReturn" value="true" />
		<!-- 关闭长时间不使用的连接，防止连接池泄漏 -->
		<property name="removeAbandoned" value="true" /> <!-- 打开removeAbandoned功能 -->
		<property name="removeAbandonedTimeout" value="1800" /> <!-- 1800秒，也就是30分钟 -->
		<!-- 打开PSCache，并且指定每个连接上PSCache的大小 如果用Oracle，则把poolPreparedStatements配置为true，mysql可以配置为false。 -->
		<property name="poolPreparedStatements" value="false" />
		<property name="maxPoolPreparedStatementPerConnectionSize"
			value="20" />
		<!-- 配置监控统计拦截的filters -->
		<property name="filters" value="wall,stat" />
	</bean>
	
		<!-- druid连接池：http://blog.csdn.net/hj7jay/article/details/51686418 -->
	<bean id="dataSourceSlave" class="com.alibaba.druid.pool.DruidDataSource"
		init-method="init" destroy-method="close">
		<property name="url"
			value="${database.url2}?rewriteBatchedStatements=true&amp;autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF-8" />
		<property name="username" value="${database.username2}" />
		<property name="password" value="${database.password2}" />

		<!-- 配置初始化大小、最小、最大 -->
		<property name="initialSize" value="10" />
		<property name="minIdle" value="10" />
		<property name="maxActive" value="64" />
		<!-- 配置获取连接等待超时的时间 -->
		<property name="maxWait" value="60000" />
		<!-- 配置间隔10分钟才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
		<property name="timeBetweenEvictionRunsMillis" value="600000" />
		<!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
		<property name="minEvictableIdleTimeMillis" value="1800000" />
		<property name="validationQuery" value="SELECT 'x'" />
		<property name="testWhileIdle" value="true" />
		<property name="testOnBorrow" value="true" />
		<property name="testOnReturn" value="true" />
		<!-- 关闭长时间不使用的连接，防止连接池泄漏 -->
		<property name="removeAbandoned" value="true" /> <!-- 打开removeAbandoned功能 -->
		<property name="removeAbandonedTimeout" value="1800" /> <!-- 1800秒，也就是30分钟 -->
		<!-- 打开PSCache，并且指定每个连接上PSCache的大小 如果用Oracle，则把poolPreparedStatements配置为true，mysql可以配置为false。 -->
		<property name="poolPreparedStatements" value="false" />
		<property name="maxPoolPreparedStatementPerConnectionSize"
			value="20" />
		<!-- 配置监控统计拦截的filters -->
		<property name="filters" value="wall,stat" />
	</bean>
	
	    <bean id="dataSource" class="com.itrus.portal.DataSources.ThreadLocalRountingDataSource">
        <property name="defaultTargetDataSource" ref="dataSourceMaster" />
        <property name="targetDataSources">
            <map key-type="com.itrus.portal.DataSources.DataSources">
                <entry key="MASTER" value-ref="dataSourceMaster"/>
                <entry key="SLAVE" value-ref="dataSourceSlave"/>
                <!-- 这里还可以加多个dataSource -->
            </map>
        </property>
    </bean>
    
	
	<bean id="transactionManager"
		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource" />
	</bean>
	<!-- 使用annotation定义事务 -->
    <tx:annotation-driven transaction-manager="transactionManager" /> 
	<bean id="defaultTd"
		class="org.springframework.transaction.support.DefaultTransactionDefinition">
		<property name="propagationBehaviorName" value="PROPAGATION_REQUIRED" />
		<property name="isolationLevelName" value="ISOLATION_READ_COMMITTED" />
	</bean>
	<bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sqlSessionFactory">
		<property name="dataSource" ref="dataSource" />
		<property name="mapperLocations">
			<list>
				<value>classpath*:com/itrus/portal/db/*.xml</value>
				<value>classpath*:com/itrus/portal/sql/*.xml</value>
				<value>classpath*:com/itrus/portal/evidence/sql/*.xml</value>
				 
			</list>
		</property>
	</bean>

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--注入sqlSessionFactory-->
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        <!--给出扫描Dao接口包-->
        <property name="basePackage" value="com.itrus.portal.db"/>
    </bean>

	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg index="0" ref="sqlSessionFactory" />
		<constructor-arg index="1" value="BATCH" />
	</bean>
	<bean id="EvidenceQueryQueue" class="com.itrus.portal.evidence.service.EvidenceQueryQueue"
          init-method="start">
        <property name="sqlSession" ref="sqlSession" />
    </bean>  
    <bean id="EvidenceQueueThread" class="com.itrus.portal.evidence.service.EvidenceQueueThread"
          init-method="start" destroy-method="destory">
        <property name="sqlSession" ref="sqlSession" />
    </bean>
    <bean id="RecordQueueThread" class="com.itrus.portal.service.RecordQueueThread"
          init-method="start">
        <property name="sqlSession" ref="sqlSession"/>
    </bean>

	<bean id="trustService" class="com.itrus.portal.service.TrustService"
		init-method="initSignKey">
		<property name="sqlSession" ref="sqlSession" />
		<property name="ksFileName" value="${keyStoreFileName}" />
		<property name="kspass" value="${keyStorePassword}" />
		<property name="kaliase" value="${keyAliase}" />
		<property name="kpass" value="${keyPassword}" />
	</bean>
	<bean id="passwordEncoder"
		class="org.springframework.security.authentication.encoding.ShaPasswordEncoder" />
	<bean id="MD5Encoder"
		class="org.springframework.security.authentication.encoding.Md5PasswordEncoder" />

	<bean id="captchaEngine" class="com.itrus.portal.utils.CaptchaEngine">
		<property name="base" value="0123456789" />
	</bean>
	<!-- 配置执行定时任务的类和方法 -->
	<bean id="cacheInit"
		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="cacheCustomer" />
		<property name="targetMethod" value="init" />
	</bean>
	<!-- 送审任务
	<bean id="submitReviewAuditTask"
		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="submitReview"/>
		<property name="targetMethod" value="audit"/>
	</bean>-->
	<!-- 查询送审结果任务 -->
	<bean id="submitReviewQueryTask"
		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="submitReview"/>
		<property name="targetMethod" value="query" />
	</bean>
	<!-- 发送短信任务 -->
	<bean id="sendSMSTask"
		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="sendSMS"/>
		<property name="targetMethod" value="send"/>
		<property name="concurrent" value="false"/><!-- 作业不并发调度 -->
	</bean>
	<!-- 配置触发器 -->
	<bean id="cacheInitTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerFactoryBean">
		<!-- see the example of method invoking job above -->
		<property name="jobDetail" ref="cacheInit" />
		<!-- repeat every 5 minute -->
		<property name="repeatInterval" value="300000" />
	</bean>
	<!--<bean id="submitReviewAuditTaskTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerFactoryBean">
		触发器触发的 执行定时任务的bean
		<property name="jobDetail" ref="submitReviewAuditTask" />
		延迟10s 
		<property name="startDelay" value="10000" />
		每10s启动一次 
		<property name="repeatInterval" value="10000" />
	</bean>-->
	
	<bean id="submitReviewQueryTaskTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerFactoryBean">
		<!--触发器触发的 执行定时任务的bean -->
		<property name="jobDetail" ref="submitReviewQueryTask" />
		<!--延迟10s -->
		<property name="startDelay" value="10000" />
		<!--每10s启动一次 -->
		<property name="repeatInterval" value="10000" />
	</bean>
	<bean id="sendSMSTaskTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
		<!-- 触发器触发的 执行定时任务的bean -->
		<property name="jobDetail" ref="sendSMSTask" />
		<!--延迟10s -->
		<property name="startDelay" value="10000" />
		<property name="cronExpression">
			<value>0 0 12 * * ?</value>
		</property>
	</bean>
	<!-- 推送企业 -->
	<bean id="signServiceUserTask"
		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="signService" />
		<property name="targetMethod" value="user" />
		<property name="concurrent" value="false" /><!-- 作业不并发调度 -->
	</bean>
	<!--计费批账定时任务  -->
	<bean id="chargingFlow"
		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="chargingFlowTask" />
		<property name="targetMethod" value="charging" />
		<property name="concurrent" value="false" /><!-- 作业不并发调度 -->
	</bean>
	<bean id="signServiceUserTaskTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerFactoryBean">
		<!-- 触发器触发的 执行定时任务的bean -->
		<property name="jobDetail" ref="signServiceUserTask" />
		<!--延迟10s -->
		<property name="startDelay" value="10000" />
		<!--每10s启动一次 -->
		<property name="repeatInterval" value="10000" />
	</bean>
	<!-- 推送订单 -->
	<!-- <bean id="userBillServiceTask"
		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="userBillService" />
		<property name="targetMethod" value="user" />
		<property name="concurrent" value="false" />作业不并发调度
	</bean>
	接楼上的订单任务
	<bean id="userBillServiceTaskTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerFactoryBean">
		触发器触发的 执行定时任务的bean
		<property name="jobDetail" ref="userBillServiceTask" />
		延迟10s
		<property name="startDelay" value="10000" />
		每10s启动一次
		<property name="repeatInterval" value="10000" />
	</bean> -->
	<bean id="chargingFlowTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerFactoryBean">
		<!-- 触发器触发的 执行定时任务的bean -->
		<property name="jobDetail" ref="chargingFlow" />
		<!--延迟10s -->
		<property name="startDelay" value="10000" />
		<!--每10s启动一次 -->
		<property name="repeatInterval" value="10000" />
	</bean>
	
	<!-- 查询签名记录 -->
	<bean id="signServiceQueryTask"
		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="signService" />
		<property name="targetMethod" value="query" />
	</bean>
	<bean id="signServiceQueryTaskTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
		<!-- 触发器触发的 执行定时任务的bean -->
		<property name="jobDetail" ref="signServiceQueryTask" />
		<!--延迟10s -->
		<property name="startDelay" value="10000" />
		<property name="cronExpression">
			<value>0 0 1-5/2 * * ?</value>
			<!--<value>0 0 15-18 * * ?</value> -->
		</property>
	</bean>
	<!-- 开电子发票定时任务 -->
	<bean id="invoiceTask"
		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="invoiceService" />
		<property name="targetMethod" value="execute" />
	</bean>
	<bean id="invoiceTaskTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerFactoryBean">
		<!-- 触发器触发的 执行定时任务的bean -->
		<property name="jobDetail" ref="invoiceTask" />
		<!--延迟10s -->
		<property name="startDelay" value="10000" />
		<!--每10s启动一次 -->
		<property name="repeatInterval" value="10000" />
	</bean>
	<!-- 发送邮件 -->
	<bean id="sendEmailTask"
		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="sendEmail" />
		<property name="targetMethod" value="send" />
		<property name="concurrent" value="false" /><!-- 作业不并发调度 -->
	</bean>
	<bean id="sendEmailTaskTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
		<!-- 触发器触发的 执行定时任务的bean -->
		<property name="jobDetail" ref="sendEmailTask" />
		<!--延迟10s -->
		<property name="startDelay" value="10000" />
		<property name="cronExpression">
			<value>0 0/2 * * * ?</value>
		</property>
	</bean>
	<!-- 银行卡打款批量查询 -->
	<bean id="batchQueryTask"
		  class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="enterpriseService" />
		<property name="targetMethod" value="batchQuery" />
		<property name="concurrent" value="false" /><!-- 作业不并发调度 -->
	</bean>
	<bean id="batchQueryTaskTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerFactoryBean">
		<!-- 触发器触发的 执行定时任务的bean -->
		<property name="jobDetail" ref="batchQueryTask" />
		<!--延迟10s -->
		<property name="startDelay" value="10000" />
		<!--每10s启动一次 -->
		<property name="repeatInterval" value="10000" />
	</bean>
	<!-- 存证失败信息调用 -->
	 <bean id="evidenceCallbackTaskJob"
		  class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="evidenceCallbackTask" />
		<property name="targetMethod" value="init" />
		<property name="concurrent" value="false" /><!-- 作业不并发调度 -->
	</bean>
	<bean id="evidenceCallbackTaskTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerFactoryBean">
		<!-- 触发器触发的 执行定时任务的bean -->
		<property name="jobDetail" ref="evidenceCallbackTaskJob"/>
		<!-- 延迟10分钟 -->
		<property name="startDelay" value="600000" />
		<!-- 每2小时启动一次 -->
		<property name="repeatInterval" value="7200000" />
	</bean> 
	<!-- 存证入库信息恢复 -->
	<bean id="evidenceRecoverDataTaskJob"
		  class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
		<property name="targetObject" ref="evidenceRecoverDataTask" />
		<property name="targetMethod" value="init" />
		<property name="concurrent" value="false" /><!-- 作业不并发调度 -->
	</bean>
	<bean id="evidenceRecoverDataTaskTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerFactoryBean">
		<!-- 触发器触发的 执行定时任务的bean -->
		<property name="jobDetail" ref="evidenceRecoverDataTaskJob" />
		<!-- 延迟10分钟 -->
		<property name="startDelay" value="600000" />
		<!-- 每2小时启动一次 -->
		<property name="repeatInterval" value="1800000" />
	</bean>
	
	<bean name="quartzScheduler"
		class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
		<!-- 普通触发器 ：触发器列表 -->
		<property name="triggers">
			<list>
				<ref bean="cacheInitTrigger" />
			<!--<ref bean="submitReviewAuditTaskTrigger" />-->
				<ref bean="submitReviewQueryTaskTrigger" />
				<ref bean="sendSMSTaskTrigger" />
				<!--<ref bean="signServiceUserTaskTrigger" />-->
				<!-- <ref bean="userBillServiceTaskTrigger" /> -->
				
				<ref bean="chargingFlowTrigger" />
				<ref bean="signServiceQueryTaskTrigger" />
				<ref bean="invoiceTaskTrigger" />
				<ref bean="sendEmailTaskTrigger" />
				<ref bean="batchQueryTaskTrigger" />
				<ref bean="evidenceCallbackTaskTrigger" />
				<ref bean="evidenceRecoverDataTaskTrigger" />
			</list>
		</property>
	</bean>

	<!-- httpClient start -->
	<!--<bean id="connManager"-->
		<!--class="org.apache.http.impl.conn.PoolingClientConnectionManager">-->
		<!--<property name="maxTotal" value="200" /> &lt;!&ndash; 最大连接总数 &ndash;&gt;-->
		<!--<property name="defaultMaxPerRoute" value="100" /> &lt;!&ndash; 每个站点最大连接数 &ndash;&gt;-->
	<!--</bean>-->
	<!--<bean id="httpClient" class="org.apache.http.impl.client.DefaultHttpClient">-->
		<!--<constructor-arg ref="connManager" />-->
	<!--</bean>-->


	<!-- 定义连接管理器 -->
	<bean id="httpClientConnectionManager"
		  class="org.apache.http.impl.conn.PoolingHttpClientConnectionManager"
		  destroy-method="close">
		<!-- 最大连接数 -->
		<property name="maxTotal" value="600" />

		<!-- 设置每个主机地址的并发数 -->
		<property name="defaultMaxPerRoute" value="300" />
	</bean>

	<!-- httpclient对象构建器 -->
	<bean id="httpClientBuilder" class="org.apache.http.impl.client.HttpClientBuilder">
		<!-- 设置连接管理器 -->
		<property name="connectionManager" ref="httpClientConnectionManager" />
	</bean>

	<!-- 定义Httpclient对象 -->
	<bean id="httpClient" class="org.apache.http.impl.client.CloseableHttpClient"
		  factory-bean="httpClientBuilder" factory-method="build">
	</bean>

	<!-- 定义清理无效连接 -->
	<bean class="com.itrus.portal.utils.IdleConnectionEvictor"
		  destroy-method="shutdown">
		<constructor-arg index="0" ref="httpClientConnectionManager" />
	</bean>

	<bean id="requestConfigBuilder" class="org.apache.http.client.config.RequestConfig.Builder">
		<!-- 创建连接的最长时间 -->
		<property name="connectTimeout" value="1000"/>
		<!-- 从连接池中获取到连接的最长时间 -->
		<property name="connectionRequestTimeout" value="500"/>
		<!-- 数据传输的最长时间 -->
		<property name="socketTimeout" value="5000"/>
		<!-- 提交请求前测试连接是否可用 -->
		<property name="staleConnectionCheckEnabled" value="true"/>
	</bean>
	<!-- 定义请求参数 -->
	<bean id="requestConfig" class="org.apache.http.client.config.RequestConfig" factory-bean="requestConfigBuilder" factory-method="build">
	</bean>

	<bean id="httpClientFactory"
		  class="org.springframework.http.client.HttpComponentsClientHttpRequestFactory">
		<constructor-arg ref="httpClient" />
	</bean>
	<util:list id="mdeiaTypes" list-class="java.util.ArrayList">
		<value>application/x-www-form-urlencoded;charset=UTF-8</value>
		<value>multipart/form-data;charset=UTF-8</value>
		<value>text/plain</value>
		<value>text/html;charset=UTF-8</value>
		<value>text/xml;charset=UTF-8</value>
		<value>application/octet-stream;charset=UTF-8</value>
		<value>application/xml;charset=UTF-8</value>
		<value>application/json;charset=UTF-8</value>
	</util:list>
	<!-- httpClient end -->
	<bean id="restTemplate" class="org.springframework.web.client.RestTemplate">
		<constructor-arg ref="httpClientFactory" />
		<!-- for chinese garbled -->
		<property name="messageConverters">
			<list>
				<bean
					class="org.springframework.http.converter.support.AllEncompassingFormHttpMessageConverter">
					<property name="supportedMediaTypes" ref="mdeiaTypes" />
					<property name="partConverters">
						<list>
							<bean
								class="org.springframework.http.converter.StringHttpMessageConverter">
								<property name="supportedMediaTypes" ref="mdeiaTypes" />
							</bean>
							<bean
								class="org.springframework.http.converter.ByteArrayHttpMessageConverter" />
							<bean
								class="org.springframework.http.converter.ResourceHttpMessageConverter" />
							<bean
								class="org.springframework.http.converter.xml.SourceHttpMessageConverter" />
							<bean
								class="org.springframework.http.converter.xml.Jaxb2RootElementHttpMessageConverter" />
							<bean
								class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter" />
						</list>
					</property>
				</bean>
				<bean
					class="org.springframework.http.converter.StringHttpMessageConverter">
					<property name="supportedMediaTypes" ref="mdeiaTypes" />
				</bean>
			</list>
		</property>
	</bean>
	<bean id="escapeTool" class="org.apache.velocity.tools.generic.EscapeTool" />
	<bean id="jsonTool" class="org.codehaus.jackson.map.ObjectMapper" />
	<jdbc:initialize-database data-source="dataSource">
		<jdbc:script encoding="UTF-8" execution="INIT"
			location="classpath:config/init_sys_res.sql" />
		<jdbc:script encoding="UTF-8" execution="INIT"
			location="classpath:config/init_sys_region.sql" />
	</jdbc:initialize-database>

	<task:executor id="executorPortal" pool-size="4-16" queue-capacity="1000000" />
	<task:annotation-driven executor="executorPortal" />
	<!-- 
	<aop:config proxy-target-class="true">
		<aop:aspect id="controllerAop" ref="controllerAop">
			<aop:pointcut id="target" expression="execution(public com.itrus.portal.mobile.controller.ResultBean *(..))" />
			<aop:around method="handlerControllerMethod" pointcut-ref="target" />
		</aop:aspect>
	</aop:config>
	 -->
	  <!-- 1.开启注解AOP -->
    <aop:aspectj-autoproxy></aop:aspectj-autoproxy>
</beans>

---

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:p="http://www.springframework.org/schema/p"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:task="http://www.springframework.org/schema/task"
	xsi:schemaLocation="
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
		http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
		http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.3.xsd">

	<!-- The controllers are autodetected POJOs labeled with the @Controller 
		annotation. -->
	<context:component-scan base-package="com.itrus.portal" use-default-filters="false">
		<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
	</context:component-scan>
	<aop:aspectj-autoproxy expose-proxy="true"></aop:aspectj-autoproxy>

	<mvc:annotation-driven>
		<mvc:message-converters register-defaults="true">
			<bean
				class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
				<property name="supportedMediaTypes" value="text/html;charset=UTF-8"></property>
			</bean>
		</mvc:message-converters>
	</mvc:annotation-driven>

	<!-- Handles HTTP GET requests for /resources/** by efficiently serving 
		up static resources -->
	<mvc:resources location="/, /WEB-INF/web-resources/"
		mapping="/resources/**" />

	<!-- Allows for mapping the DispatcherServlet to "/" by forwarding static 
		resource requests to the container's default Servlet -->
	<mvc:default-servlet-handler />

	<!-- Register "global" interceptor beans to apply to all registered HandlerMappings -->
	<mvc:interceptors>
		<bean class="org.springframework.web.servlet.theme.ThemeChangeInterceptor" />
		<bean class="org.springframework.web.servlet.i18n.LocaleChangeInterceptor"
			p:paramName="lang" />
	</mvc:interceptors>

	<!-- Selects a static view for rendering without the need for an explicit 
		controller -->
	<mvc:view-controller path="/login" />
	<mvc:view-controller path="/uncaughtException" />
	<mvc:view-controller path="/resourceNotFound" />
	<mvc:view-controller path="/dataAccessFailure" />
	<mvc:view-controller path="/errorpage" />
	

	<!-- Store preferred language configuration in a cookie -->
	<bean class="org.springframework.web.servlet.i18n.CookieLocaleResolver"
		id="localeResolver" p:cookieName="locale" />

	<!-- Resolves localized <theme_name>.properties files in the classpath to 
		allow for theme support -->
	<bean
		class="org.springframework.ui.context.support.ResourceBundleThemeSource"
		id="themeSource" />

	<!-- Store preferred theme configuration in a cookie -->
	<bean class="org.springframework.web.servlet.theme.CookieThemeResolver"
		id="themeResolver" p:cookieName="theme" p:defaultThemeName="standard" />

	<!-- This bean resolves specific types of exceptions to corresponding logical 
		- view names for error views. The default behaviour of DispatcherServlet 
		- is to propagate all exceptions to the servlet container: this will happen 
		- here with all other types of exceptions. -->
	<bean
		class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver"
		p:defaultErrorView="uncaughtException">
		<property name="exceptionMappings">
			<props>
				<prop key=".DataAccessException">dataAccessFailure</prop>
				<prop key=".NoSuchRequestHandlingMethodException">resourceNotFound</prop>
				<prop key=".TypeMismatchException">resourceNotFound</prop>
				<prop key=".MissingServletRequestParameterException">resourceNotFound</prop>
			</props>
		</property>
	</bean>

	<!-- Enable this for integration of file upload functionality -->
	<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver" />

	<bean id="velocityConfigurer"
		class="org.springframework.web.servlet.view.velocity.VelocityConfigurer">
		<property name="resourceLoaderPath">
			<value>/WEB-INF/views</value>
		</property>
		<property name="velocityProperties">
			<props>
				<prop key="input.encoding">UTF-8</prop>
				<prop key="output.encoding">UTF-8</prop>
			</props>
		</property>
	</bean>

	<bean id="viewResolver"
		class="org.springframework.web.servlet.view.velocity.VelocityLayoutViewResolver">
		<property name="cache" value="false" />
		<property name="prefix" value="" />
		<property name="suffix" value=".vm" />
		<property name="contentType" value="text/html;charset=UTF-8" />

		<property name="dateToolAttribute" value="date" /><!--日期函数名称 -->
		<property name="numberToolAttribute" value="number" /><!--数字函数名称 -->

		<property name="exposeRequestAttributes" value="true" />
		<property name="exposeSessionAttributes" value="true" />
		<property name="exposeSpringMacroHelpers" value="true" />
		<property name="requestContextAttribute" value="rc" />

		<property name="layoutUrl" value="layouts/layout.vm" />

		<property name="attributesMap">
			<map>
				<entry key="esc" value-ref="escapeTool" />
				<entry key="json" value-ref="jsonTool" />
				<entry key="dus" value-ref="dateUtils"></entry>
			</map>
		</property>
	</bean>
	<bean id="appProperty"
	          class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
	    <property name="locations">
	        <array>
	            <value>classpath:config/machineNo.properties</value>
	        </array>
	    </property>
	</bean>
</beans>

---

数据库配置文件

database.driverClassName=com.mysql.jdbc.Driver
database.url=jdbc\:mysql\://127.0.0.1\:4306/itrusportal20190314
database.username=root
database.password=root

database.url2=jdbc\:mysql\://127.0.0.1\:4306/itruslaweyecloud
database.username2=root
database.password2=root