Programming/JSP - 게시판만들기
[JSP] JSP로 게시판 만들기[MODEL 1] - 4(DBClose.java)
세이나린
2013. 1. 25. 15:10
이번엔 열어놓은 값들을 닫는 DBClose 클래스를 만들어 보도록 하겠습니다.
DBClose.java
package board; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; public class DBClose { public static void close(Connection con, PreparedStatement pstmt, ResultSet rs) { try { try { if(rs!=null) { rs.close(); rs=null;} }catch(Exception e) {} try { if(pstmt!=null) { pstmt.close(); pstmt=null; } }catch(Exception e) {} try { if(con!=null) { con.close(); con=null; } }catch(Exception e) {} }catch(Exception e) {} } public static void close(Connection con, PreparedStatement pstmt) { try { try { if(pstmt!=null) { pstmt.close(); pstmt=null; } }catch(Exception e) {} try { if(con!=null) { con.close(); con=null; } }catch(Exception e) {} }catch(Exception e) {} } public static void close(Connection con, Statement stmt) { try { try { if(stmt!=null) { stmt.close(); stmt=null; } }catch(Exception e) {} try { if(con!=null) { con.close(); con=null; } }catch(Exception e) {} }catch(Exception e) {} } public static void close(Connection con) { try { try { if(con!=null) { con.close(); con=null; } }catch(Exception e) {} }catch(Exception e) {} } public static void close(PreparedStatement pstmt) { try { try { if(pstmt!=null) { pstmt.close(); pstmt=null; } }catch(Exception e) {} }catch(Exception e) {} } public static void close(Statement stmt) { try { try { if(stmt!=null) { stmt.close(); stmt=null; } }catch(Exception e) {} }catch(Exception e) {} } public static void close(ResultSet rs) { try { try { if(rs!=null) { rs.close(); rs=null; } }catch(Exception e) {} }catch(Exception e) {} } public static void close(PreparedStatement pstmt, ResultSet rs) { try { try { if(rs!=null) { rs.close(); rs=null; } }catch(Exception e) {} try { if(pstmt!=null) { pstmt.close(); pstmt=null; } }catch(Exception e) {} }catch(Exception e) {} }
}
인자값에 따라 모든 경우의 수에 맞게 close메소드를 오버로딩 시킨 파일입니다.
특별히 설명할 부분은 없을것 같습니다.