public Comment getComment(String commentId) {
Comment comment = new Comment();
try {
ResultSet rs = db.getData("comment", "id", commentId);
while (rs.next()) {
comment.setCommentMessage(rs.getString("commentMessage"));
comment.setAuthor(rs.getString("author"));
comment.setCreated(rs.getDate("created"));
}
} catch (SQLException e) {
System.err.println("Exception on getComment : " + e);
;
}
return comment;
}
public List<Comment> getAllComments(int messageId) {
try {
ResultSet rs = db.getAllDatas("comment where \"messageId\" = " + messageId);
while (rs.next()) {
Comment comment = new Comment();
comment.setId(rs.getInt("id"));
comment.setCommentMessage(rs.getString("commentMessage"));
comment.setAuthor(rs.getString("author"));
comment.setCreated(rs.getDate("created"));
comments.add(comment);
}
} catch (SQLException e) {
e.printStackTrace();
}
return comments;
}