用的是阿里云，刚买的，网站就我自己测试

db.properties

 nginx


 jdbc.acquireIncrement=5
jdbc.initPoolSize=20
jdbc.minPoolSize=10
jdbc.maxPoolSize=600

jdbc.maxStatements=20
jdbc.maxStatementsPerConnection=5
jdbc.idleConnectionTestPeriod=60

applicationContext.xml

 xml


 <!-- 导入资源文件 -->
    <context:property-placeholder location="classpath:db.properties" />

    <!-- 配置 C3P0 数据源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
        destroy-method="close">
        <property name="user" value="${jdbc.user}"></property>
        <property name="password" value="${jdbc.password}"></property>
        <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
        <property name="driverClass" value="${jdbc.driverClass}"></property>

        <property name="acquireIncrement" value="${jdbc.initPoolSize}"></property>
        <property name="initialPoolSize" value="${jdbc.initPoolSize}"></property>
        <property name="minPoolSize" value="${jdbc.minPoolSize}"></property>
        <property name="maxPoolSize" value="${jdbc.maxPoolSize}"></property>

        <property name="maxStatements" value="${jdbc.maxStatements}"></property>
        <!-- 每60秒检查所有连接池中的空闲连接.Default:0 -->  
        <property name="idleConnectionTestPeriod" value="${jdbc.idleConnectionTestPeriod}"/>
        <!-- 
        <property name="maxStatementsPerConnection" value="${jdbc.maxStatementsPerConnection}"></property>
         -->
    </bean>

    <!-- 配置 Spirng 的 JdbcTemplate -->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!-- 配置事务管理器 -->
    <bean id="transactionManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!-- 启用事务注解 -->
    <tx:annotation-driven transaction-manager="transactionManager" />


    <!-- 配置 bean -->
    <!-- 配置 bean model 包 -->