c3p0-config.xml

<c3p0-config>

 <!-- 默认配置，如果没有指定则使用这个配置 -->

 <default-config>

  <property name="checkoutTimeout">30000</property><!-- 超时时间 -->

  <property name="idleConnectionTestPeriod">30</property><!-- 每30秒检查一下是否有空闲连接 -->

  <property name="initialPoolSize">2</property>

  <property name="maxIdleTime">30</property>

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

  <property name="minPoolSize">2</property>

  <property name="maxStatements">50</property>

  <property name="driverClass">com.mysql.jdbc.Driver</property>

  <property name="jdbcUrl">

   <![CDATA[jdbc:mysql://127.0.0.1:3306/student?useUnicode=true&characterEncoding=UTF-8]]>

  </property>

  <property name="user">root</property>

  <property name="password">root</property>

 </default-config>

 <!-- 命名的配置以连接其他数据库 -->

 <named-config name="wj">

  <property name="driverClass">com.mysql.jdbc.Driver</property>

  <property name="jdbcUrl">

   <![CDATA[jdbc:mysql://127.0.0.1:3306/student?useUnicode=true&characterEncoding=UTF-8]]>

  </property>

  <property name="user">root</property>

  <property name="password">root</property>

  <property name="acquireIncrement">2</property><!-- 如果池中数据连接不够时一次增长多少个 -->

  <property name="initialPoolSize">2</property>

  <property name="minPoolSize">50</property>

  <property name="maxPoolSize">10</property>

  <property name="maxStatements">50</property>

 </named-config>

</c3p0-config>