jdbc使用mysql数据库连接池_用jdbc连接mysql数据库(c3p0连接池篇)

package cn.lfd.Utils;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class JdbcUtils_c3p0 {

private static ComboPooledDataSource ds;

static{

ds = new ComboPooledDataSource("lfd");//读取配置文件中名字为lfd的配置，不写的话读取默认配置

}

//从数据源中获取连接

public static Connection getConnection() throws SQLException {

return ds.getConnection();

}

//释放资源

public static void release(Connection conn, Statement st, ResultSet rs) {

if(conn!=null) {

try {

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}finally{

if(st!=null) {

try {

st.close();

} catch (SQLException e) {

e.printStackTrace();

}finally{

if(rs!=null) {

try {

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

}

}

}

}

c3p0-config.xml文件

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/test

root

root

con_test

30000

30

20

30

30

10

200

10

1

0

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/test

root

root

20

5

30

0

5

1

1

1

5

50

注意事项:

1.c3p0-config.xml文件必须放在src目录下

2.需要的jar包:   c3p0-0.9.1.2.jar      mchange-commons-java-0.2.3.4.jar