文件命名必须为c3p0-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<default-config>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://192.168.92.7:3306/guns?useUnicode=true&characterEncoding=UTF-8</property>
<property name="user">root</property>
<property name="password">1234</property>
<property name="initialPoolSize">10</property>
<property name="maxIdleTime">30</property>
<property name="maxPoolSize">100</property>
<property name="minPoolSize">10</property>
</default-config>
</c3p0-config>
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.sql.DataSource;
import com.mchange.v2.c3p0.ComboPooledDataSource;
/**
* @author qisun
* @TODO c3p0工具类(数据库连接池工具),用于管理多个数据库连接对象。
*/
public class C3P0Utils {
private static ComboPooledDataSource ds = new ComboPooledDataSource();
/**
* 获取数据源
*
* @return 连接池
*/
public static DataSource getDataSource() {
return ds;
}
/**
* 释放资源
*
* @param conn
* @param st
* @param rs
*/
public static void CloseResource(Connection conn, Statement st, ResultSet rs) {
closeResultSet(rs);
closeStaement(st);
closeConn(conn);
}
/**
* 获取连接
*
* @return 连接
* @throws SQLException
*/
public static Connection getConnection() {
Connection conn;
try {
conn = ds.getConnection();
return conn;
} catch (SQLException e) {
throw new RuntimeException("服务器忙。。。");
}
}
/**
* 释放连接
*
* @param conn
* 连接
*/
public static void closeConn(Connection conn) {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
conn = null;
}
}
}
/**
* 释放语句执行者
*
* @param st
* 语句执行者
*/
public static void closeStaement(Statement st) {
if (st != null) {
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
st = null;
}
}
}
/**
* 释放结果集
*
* @param rs
* 结果集
*/
public static void closeResultSet(ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
rs = null;
}
}
}
}
需要用到两个jar包 一个是mysql-connection 一个是c3p0-0-0.9.5.2.jar