c3p0連接池

需要的架包
1.mysql-connector-java-5.1.7-bin.jar
2.c3p0-0.9.2.1.jar
3.mchange-commons-java-0.2.3.4.jar
c3p0-config.xml配置文件
<!--?
*這里為了演示只配置了最基本的，和普通連接數據庫類似
*這里的name屬性名字不能自己杜撰
*這里的named-config的name屬性一定要寫，不然找不到配置
*如果出現java.sql.SQLException:?
Connections could not be acquired from the underlying database!
錯誤，通常是c3p0-config.xml文件配置錯誤，檢查賬號，密碼，驅動是否正確

?-->

<c3p0-config><named-config name="tang"><property name="driverClass">com.mysql.jdbc.Driver</property><property name="jdbcUrl">jdbc:mysql://localhost:3306/tang</property><property name="user">root</property><property name="password">jarrem</property><property name="maxActive">20</property><property name="maxIdle">10</property><property name="minIdle">1</property><property name="initialSize">2</property></named-config></c3p0-config>

?

java代碼

package com.tang.c3p0; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.sql.DataSource; import com.mchange.v2.c3p0.ComboPooledDataSource; public class c3p0Test {private Connection connection=null;private DataSource ds=null;public c3p0Test(){//創建數據源，通過named-config的name屬性加載xml配置文件ds=new ComboPooledDataSource("tang");try {//獲取Connection對象connection = ds.getConnection();PreparedStatement statement = connection.prepareStatement("select * from student;");ResultSet result = statement.executeQuery();while(result.next()){System.out.println(result.getString(5)+" "+result.getString(3));}} catch (SQLException e) {e.printStackTrace();}}public static void main(String args[]){new c3p0Test();} }

?

轉載于:https://www.cnblogs.com/jarrem/p/5910824.html

總結

以上是生活随笔為你收集整理的c3p0连接池的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。