<?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:tx="http://www.springframework.org/schema/tx"

       xmlns:context="http://www.springframework.org/schema/context"

       xsi:schemaLocation="http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd

      http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd

      http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd">

    <context:component-scan base-package="com.jxyq" use-default-filters="false">

        <context:include-filter type="annotation" expression="org.springframework.stereotype.Service"/>

    </context:component-scan>

    <bean id="springContextHolder" class="com.jxyq.config.SpringContextHolder"/>

    <bean id="placeholderConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

        <property name="fileEncoding" value="UTF-8"/>

        <property name="locations">

            <array>

                <value>classpath:proxool.properties</value>

                <value>classpath:security.properties</value>

                <value>classpath:systemParam.properties</value>

            </array>

        </property>

    </bean>

    <bean id="messageSource" class="org.springframework.context.support.ResourceBundleMessageSource">

        <property name="basename" value="messages"/>

    </bean>

    <!--第一个数据源-->

    <bean id="oneDataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource">

        <property name="alias" value="${proxool.alias}"/>

        <property name="driver" value="${proxool.driver}"/>

        <property name="user" value="${proxool.user}"/>

        <property name="password" value="${proxool.password}"/>

        <property name="driverUrl" value="${proxool.url}"/>

        <property name="trace" value="${proxool.trace}"/>

        <property name="prototypeCount" value="${proxool.prototypeCount}"/>

        <property name="maximumConnectionCount" value="${proxool.maximumConnectionCount}"/>

        <property name="minimumConnectionCount" value="${proxool.minimumConnectionCount}"/>

        <property name="simultaneousBuildThrottle" value="${proxool.simultaneousBuildThrottle}"/>

        <property name="houseKeepingTestSql" value="${proxool.houseKeepingTestSql}"/>

    </bean>

    <bean id="oneSqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

        <property name="dataSource" ref="oneDataSource"/>

        <property name="configLocation" value="classpath:mybatis.xml"/>

        <property name="mapperLocations">

            <list>

                <value>classpath:mapper/*.xml</value>

            </list>

        </property>

        <property name="typeAliasesPackage" value="com.jxyq.model"/>

        <property name="plugins">

            <list>

                <bean class="com.jxyq.commons.mybatis.pagination.PagingInterceptor">

                    <property name="dbModel" value="${proxool.dbModel}"/>

                    <property name="dialect">

                        <bean class="com.jxyq.commons.mybatis.pagination.dialect.OracleDialect"/>

                    </property>

                    <property name="sqlRegex" value=".*ByPage"/>

                </bean>

            </list>

        </property>

    </bean>

    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">

        <property name="dataSource" ref="oneDataSource"/>

    </bean>

    <bean id="oneTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

        <property name="dataSource" ref="oneDataSource"/>

    </bean>

    <tx:annotation-driven transaction-manager="transactionManager"/>

    <bean id="oneTransactionTemplate" class="org.springframework.transaction.support.TransactionTemplate">

        <property name="transactionManager" ref="oneTransactionManager"/>

    </bean>

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

        <property name="sqlSessionFactoryBeanName" value="oneSqlSessionFactory"></property>

        <property name="basePackage" value="com.jxyq.mapper"/>

    </bean>

    <bean id="oneResultMapManager" class="com.jxyq.config.ResultMapManager">

        <property name="sqlSessionFactory" ref="oneSqlSessionFactory"/>

    </bean>

    <bean id="taskExecutor" class="org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor">

        <property name="corePoolSize" value="3"/>

        <property name="maxPoolSize" value="5"/>

        <property name="queueCapacity" value="1000"/>

        <property name="keepAliveSeconds" value="60"/>

        <property name="rejectedExecutionHandler">

            <bean class="java.util.concurrent.ThreadPoolExecutor$CallerRunsPolicy"/>

        </property>

    </bean>

</beans> 

#SQLServer

proxool.alias=mainDB

proxool.dbModel=SQLServer

proxool.driver=net.sourceforge.jtds.jdbc.Driver

proxool.url=jdbc:jtds:sqlserver://193.160.17.251:1433;databasename=tempdb

proxool.user=sa

proxool.password=fnst1234

proxool.trace=true

proxool.prototypeCount=

proxool.maximumConnectionCount=

proxool.minimumConnectionCount=

proxool.simultaneousBuildThrottle=

proxool.houseKeepingTestSql=select current_date

        <dependency>

            <groupId>net.sourceforge.jtds</groupId>

            <artifactId>jtds</artifactId>

            <version>1.3.1</version>

        </dependency>