Advertisement
Jnk1296

SQL Method

Mar 2nd, 2014
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.19 KB | None | 0 0
  1. public ArrayList<CommentItem> getTicketComments(int ticketID) {
  2.         String QUERY = "SELECT TicketID, Player, Timestamp, Message FROM " +
  3.                 "COMMENTS WHERE TicketID = " + ticketID;
  4.  
  5.         QueryFilter FILTER = new QueryFilter() {
  6.             @Override
  7.             public Object onExecute(ResultSet rs) {
  8.                 ArrayList<CommentItem> comments = new ArrayList<CommentItem>();
  9.  
  10.                 try {
  11.                     while(rs.next()) {
  12.                         int ticketID = rs.getInt("TicketID");
  13.                         String player = rs.getString("Player");
  14.                         String message = rs.getString("Message");
  15.                         String date = rs.getString("Timestamp");
  16.  
  17.                         comments.add(new CommentItem(player, message, date,
  18.                                 ticketID));
  19.                     }
  20.                 } catch (SQLException e) {
  21.                     System.out.println(e.getLocalizedMessage());
  22.                 }
  23.  
  24.                 return comments;
  25.             }
  26.         };
  27.  
  28.         return (ArrayList<CommentItem>) this.executeQuery(new StatementObject(
  29.                 this.getPlugin(), QUERY), FILTER);
  30.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement