62,614
社区成员
发帖
与我相关
我的任务
分享
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcUtil {
public static void close(Connection con, Statement stat, ResultSet rs) {
close(rs);
close(stat);
close(con);
}
public static void close(Connection con, Statement stat) {
close(con, stat, null);
}
public static void close(Connection con, ResultSet rs) {
close(con, null, rs);
}
public static void close(Connection con) {
if(con != null) {
try {
con.close();
} catch(SQLException e) {
e.printStackTrace();
}
}
}
public static void close(Statement stat) {
if(stat != null) {
try {
stat.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}
public static void close(ResultSet rs) {
if(rs != null) {
try {
rs.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}
}
} finally {
JdbcUtil.close(con, pStatement, rs);
}
} finally {
if(rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(....) // 照上面这样关闭另外两个。
}