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;
}
