applicationContext.xml：

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

    xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

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

    xsi:schemaLocation="http://www.springframework.org/schema/beans

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

               http://www.springframework.org/schema/context

               http://www.springframework.org/schema/context/spring-context-3.0.xsd

               http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd

            ">

    <context:property-placeholder location="classpath*:javaniu.properties" />

    <context:annotation-config />

    <context:component-scan base-package="com.javaniu" />

    <mvc:annotation-driven />

    <import resource="hibernate-context.xml" />

    <bean id="viewResolver"

        class="org.springframework.web.servlet.view.InternalResourceViewResolver">

        <property name="viewClass"

            value="org.springframework.web.servlet.view.JstlView" />

        <property name="prefix">

            <value>/WEB-INF/jsp/</value>

        </property>

        <property name="suffix" value=".jsp" />

    </bean>

</beans>

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

    xmlns:jpa="http://www.springframework.org/schema/data/jpa"

    xsi:schemaLocation="

            http://www.springframework.org/schema/beans

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

            http://www.springframework.org/schema/context

            http://www.springframework.org/schema/context/spring-context.xsd

            http://www.springframework.org/schema/aop

            http://www.springframework.org/schema/aop/spring-aop.xsd

            http://www.springframework.org/schema/tx

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

            http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa.xsd

            ">

    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">

        <property name="driverClass" value="${datasource.connection.driver_class}" />

        <property name="jdbcUrl" value="${datasource.connection.url}" />

        <property name="user" value="${datasource.connection.username}" />

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

        <property name="minPoolSize" value="${datasource.connection.minPoolSize}" />

        <!--连接池中保留的最大连接数。Default: 15 -->

        <property name="maxPoolSize" value="${datasource.connection.maxPoolSize}" />

        <!--最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->

        <property name="maxIdleTime" value="${datasource.connection.maxIdleTime}" />

        <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->

        <property name="acquireIncrement" value="${datasource.connection.acquireIncrement}" />

        <!--JDBC的标准参数，用以控制数据源内加载的PreparedStatements数量。但由于预缓存的statements 属于单个connection而不是整个连接池。所以设置这个参数需要考虑到多方面的因素。

            如果maxStatements与maxStatementsPerConnection均为0，则缓存被关闭。Default: 0 -->

        <property name="maxStatements" value="${datasource.connection.maxStatements}" />

        <!--maxStatementsPerConnection定义了连接池内单个连接所拥有的最大缓存statements数。Default: 0 -->

        <property name="maxStatementsPerConnection"

            value="${datasource.connection.maxStatementsPerConnection}" />

        <!--初始化时获取三个连接，取值应在minPoolSize与maxPoolSize之间。Default: 3 -->

        <property name="initialPoolSize" value="${datasource.connection.initialPoolSize}" />

        <!--每60秒检查所有连接池中的空闲连接。Default: 0 -->

        <property name="idleConnectionTestPeriod"

            value="${datasource.connection.idleConnectionTestPeriod}" />

        <!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->

        <property name="acquireRetryAttempts"

            value="${datasource.connection.acquireRetryAttempts}" />

        <!--获取连接失败将会引起所有等待连接池来获取连接的线程抛出异常。但是数据源仍有效 保留，并在下次调用getConnection()的时候继续尝试获取连接。如果设为true，那么在尝试

            获取连接失败后该数据源将申明已断开并永久关闭。Default: false -->

        <property name="breakAfterAcquireFailure"

            value="${datasource.connection.breakAfterAcquireFailure}" />

        <!--因性能消耗大请只在需要的时候使用它。如果设为true那么在每个connection提交的 时候都将校验其有效性。建议使用idleConnectionTestPeriod或automaticTestTable

            等方法来提升连接测试的性能。Default: false -->

        <property name="testConnectionOnCheckout"

            value="${datasource.connection.testConnectionOnCheckout}" />

        <property name="checkoutTimeout" value="${datasource.connection.checkoutTimeout}" />

        <property name="testConnectionOnCheckin"

            value="${datasource.connection.testConnectionOnCheckin}" />

        <property name="automaticTestTable" value="${datasource.connection.automaticTestTable}" />

        <property name="acquireRetryDelay" value="${datasource.connection.acquireRetryDelay}" />

    </bean>

    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true" />

    <!-- Declare a JPA entityManagerFactory -->

    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">

        <property name="packagesToScan" value="com.javaniu" />

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

        <property name="jpaVendorAdapter">

            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">

                <property name="showSql" value="${hibernate.showSql}" />

                <property name="generateDdl" value="true" />

            </bean>

        </property>

    </bean>

    <!-- Declare a transaction manager -->

    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">

        <property name="entityManagerFactory" ref="entityManagerFactory" />

    </bean>

    <!-- Where to find repositories -->

    <jpa:repositories base-package="com.javaniu.repository" />

</beans>   

javaniu.properties

# database properties

## datasource

datasource.connection.driver_class=com.mysql.jdbc.Driver

datasource.connection.url=jdbc:mysql://10.32.11.74:3306/jparest?useUnicode=true&characterEncoding=utf-8

datasource.connection.username=root

datasource.connection.password=123456

datasource.connection.minPoolSize=1

datasource.connection.maxPoolSize=20

datasource.connection.maxIdleTime=30

datasource.connection.acquireIncrement=10

datasource.connection.maxStatements=0

datasource.connection.maxStatementsPerConnection=0

datasource.connection.initialPoolSize=5

datasource.connection.idleConnectionTestPeriod=30

datasource.connection.acquireRetryAttempts=30

datasource.connection.breakAfterAcquireFailure=true

datasource.connection.testConnectionOnCheckout=true

datasource.connection.checkoutTimeout=3000

datasource.connection.testConnectionOnCheckin=true

datasource.connection.automaticTestTable = c3p0TestTable

datasource.connection.acquireRetryDelay = 1000

hibernate.showSql=true