import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;
import com.mchange.v2.c3p0.ComboPooledDataSource;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.ResultSet;
public class JDBCUtils {
//创建数据库连接池
public static final ComboPooledDataSource dataSource = new ComboPooledDataSource();
//获得连接
public static Connection getConnection() throws SQLException{
return dataSource.getConnection();
}
//获得连接池
public static DataSource getDataSource(){
return dataSource;
}
//查询操作:释放资源
public static void relase(Connection conn,PreparedStatement pstmt,ResultSet rs){
//释放连接
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
conn = null;
}
//释放sql语句对象
if(pstmt != null){
try {
pstmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pstmt = null;
}
//释放结果集
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
rs = null;
}
}
//更新操作:释放资源
public static void relase(Connection conn,PreparedStatement pstmt){
//释放连接
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
conn = null;
}
//释放sql语句获取对象
if(pstmt != null){
try {
pstmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pstmt = null;
}
}
}
import java.sql.SQLException;
import javax.sql.DataSource;
import com.mchange.v2.c3p0.ComboPooledDataSource;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.ResultSet;
public class JDBCUtils {
//创建数据库连接池
public static final ComboPooledDataSource dataSource = new ComboPooledDataSource();
//获得连接
public static Connection getConnection() throws SQLException{
return dataSource.getConnection();
}
//获得连接池
public static DataSource getDataSource(){
return dataSource;
}
//查询操作:释放资源
public static void relase(Connection conn,PreparedStatement pstmt,ResultSet rs){
//释放连接
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
conn = null;
}
//释放sql语句对象
if(pstmt != null){
try {
pstmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pstmt = null;
}
//释放结果集
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
rs = null;
}
}
//更新操作:释放资源
public static void relase(Connection conn,PreparedStatement pstmt){
//释放连接
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
conn = null;
}
//释放sql语句获取对象
if(pstmt != null){
try {
pstmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pstmt = null;
}
}
}