Spring框架

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

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

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

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

         <property name="jdbcUrl" value="${jdbcUrl}"/>

         <property name="driverClass" value="${driverClass}"/>

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

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

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

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

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

<property name="maxStatementsPerConnection"

value="${maxStatementsPerConnection}"/>

</bean>

<bean id="template"

class="org.springframework.jdbc.core.JdbcTemplate">

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

</bean>