C3P0连接池使用

来源：互联网发布：淘宝企业信息公示审核编辑：程序博客网时间：2024/06/04 18:50

具体的步骤：

一、导入c3p0的jar包：mysql-connector-java-5.1.7-bin.jar

二、对C3P0连接池进行配置，具体配置查看：c3p0-0.9.1.2.bin/c3p0-0.9.1.2/doc/index.html 的API、QuickStart、Appendix B: Configuation Files, etc.等文件

三、创建C3P0Utils类，定义获取connection、释放connection的方法

一些重要的类和代码：ComboPooledDataSource cpds = new ComboPooledDataSource("intergalactoApp"); 其中intergalactoApp是config-name

<c3p0-config>
<named-config name="intergalactoApp">
<property name="acquireIncrement">50</property>
     <property name="initialPoolSize">100</property>
     <property name="minPoolSize">50</property>
     <property name="maxPoolSize">1000</property>

     <property name="maxStatements">0</property>
     <property name="maxStatementsPerConnection">5</property>

     <property name="acquireIncrement">1</property>
     <property name="initialPoolSize">1</property>
     <property name="minPoolSize">1</property>
     <property name="maxPoolSize">5</property>
     <property name="maxStatementsPerConnection">50</property>
     </named-config>
   </c3p0-config>

参考网址：http://www.cnblogs.com/ygj0930/p/6405861.html

阅读全文

0 0