public boolean loadComment() throws IOException, SQLException { if (pageNo * countPerPage >= totalCount) { return false; } Connection conn = null; PreparedStatement pStmt = null; String sql = "select ctext from comment limit ?, ?"; ResultSet rs = null; int i = 0; conn = DB.getConn(); pStmt = DB.getpStmt(conn, sql); pStmt.setInt(1, (pageNo * countPerPage)); pStmt.setInt(2, countPerPage); rs = pStmt.executeQuery(); while (rs.next()) { comm[i] = rs.getString(1); i++; } pageNo++; rs.close(); pStmt.close(); conn.close(); return true; }
public List<Comment> getCommentByStatusId(String statusId) { List<Comment> list = new LinkedList<Comment>(); Connection conn = null; PreparedStatement pStmt = null; String sql = "select cid, ctext from comment where sid = ?"; ResultSet rs = null; Comment c = null; try { conn = DB.getConn(); pStmt = DB.getpStmt(conn, sql); pStmt.setString(1, statusId); rs = pStmt.executeQuery(); while (rs.next()) { c = new Comment(); c.setCid(rs.getString("cid")); c.setCtext(rs.getString("ctext")); c.setSid(statusId); list.add(c); } } catch (SQLException e) { e.printStackTrace(); } finally { if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if (pStmt != null) { try { pStmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } return list; }