public Comment addComment(int messageId, Comment comment) {
String query =
"insert into comment (\"commentMessage\", author, created, \"messageId\") values('"
+ comment.getCommentMessage()
+ "', '"
+ comment.getAuthor()
+ "', '"
+ comment.getCreated()
+ "', "
+ messageId
+ ")";
db.addData(query);
return comment;
}
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 Comment updateComment(int messageId, Comment comment) {
String query =
"update comment set \"commentMessage\" = '"
+ comment.getCommentMessage()
+ "', author = '"
+ comment.getAuthor()
+ "', created = '"
+ comment.getCreated()
+ "', \"messageId\" = '"
+ messageId
+ "' where id = '"
+ comment.getId()
+ "'";
db.addData(query);
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;
}
public Comment removeComment(int commentId, Comment comment) {
String query = "delete from comment where id = '" + commentId + "'";
db.addData(query);
return comment;
}