import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.mchange.v2.c3p0.ComboPooledDataSource;
/**
* 连接池规范接口:
* javax.sql.DataSource
* C3P0连接池,实现类sun公司提供的规范接口
* ComboPooledDataSource implements DataSource
* 重写了getConection接口
*/
public class C3P0Utils {
//1.注册驱动
public static ComboPooledDataSource dataSource= new ComboPooledDataSource();
static{
try {
dataSource.setDriverClass("com.mysql.jdbc.Driver");
dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/day_04");
dataSource.setUser("root");
dataSource.setPassword("root");
} catch (PropertyVetoException e) {
e.printStackTrace();
}
}
public static Connection getConection(){
try {
return dataSource.getConnection();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException();
}
}
public static void close(ResultSet rs,Statement state,Connection conn){
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(state != null){
try {
state.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
C3P0Utils连接工具
最新推荐文章于 2023-12-18 12:40:19 发布