Esempio n. 1
0
 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;
 }
Esempio n. 2
0
 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;
 }