spring mvc+mybatis+sql server简单配置

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: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> 

proxool.properties配置文件

#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=3
proxool.maximumConnectionCount=100
proxool.minimumConnectionCount=10
proxool.simultaneousBuildThrottle=80
proxool.houseKeepingTestSql=select current_date

驱动（mavem）：

        <dependency>
            <groupId>net.sourceforge.jtds</groupId>
            <artifactId>jtds</artifactId>
            <version>1.3.1</version>
        </dependency>

一开始时使用微软官方的驱动sqljdbc4(com.microsoft.sqlserver),但是一直报找不到合适的驱动，最后就改用jtds开源的驱动替代。