public static int getNextUploadNo() throws SQLException { Connection con = null; PreparedStatement pstmt = null; ResultSet rset = null; int nextPostNo = 0; try { con = DBUtil.getConnection(); pstmt = con.prepareStatement("SELECT max(dkswUploadNo) FROM dksw_upload"); rset = pstmt.executeQuery(); rset.next(); nextPostNo = rset.getInt(1) + 1; return nextPostNo; } catch (SQLException se) { se.printStackTrace(); throw se; } finally { try { DBUtil.close(con, pstmt, rset); } catch (SQLException sqle) { sqle.printStackTrace(); } } }
public static int addUploadFile( int inputUploadCategory, int inputUploadPostNo, long inputUploadDate, int inputMemberNo, String inputUploadFileName, String inputUploadFileSrc) throws SQLException { Connection con = null; PreparedStatement pstmt = null; ResultSet rset = null; int check = 0; try { con = DBUtil.getConnection(); pstmt = con.prepareStatement( "INSERT INTO dksw_upload(" + "dkswUploadCategory, dkswUploadPostNo, dkswUploadDate, dkswMemberNo, dkswUploadFileName, dkswUploadFileSrc" + ") values(?, ?, ?, ?, ?, ?)"); pstmt.setInt(1, inputUploadCategory); pstmt.setInt(2, inputMemberNo); pstmt.setLong(3, inputUploadDate); pstmt.setInt(4, inputMemberNo); pstmt.setString(5, inputUploadFileName); pstmt.setString(6, inputUploadFileSrc); check = pstmt.executeUpdate(); return check; } catch (SQLException se) { se.printStackTrace(); throw se; } finally { try { DBUtil.close(con, pstmt, rset); } catch (SQLException sqle) { sqle.printStackTrace(); } } }
public static Upload getFile(int inputUploadNo) throws SQLException { Connection con = null; PreparedStatement pstmt = null; ResultSet rset = null; Upload file = null; try { con = DBUtil.getConnection(); pstmt = con.prepareStatement("SELECT * FROM dksw_upload WHERE dkswUploadNo=?"); pstmt.setInt(1, inputUploadNo); rset = pstmt.executeQuery(); if (rset.next()) { file = new Upload( rset.getInt(1), rset.getInt(2), rset.getInt(3), rset.getLong(4), rset.getInt(5), rset.getString(6), rset.getString(7)); } return file; } catch (SQLException se) { se.printStackTrace(); throw se; } finally { try { DBUtil.close(con, pstmt, rset); } catch (SQLException sqle) { sqle.printStackTrace(); } } }