Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public ArrayList<CommentItem> getTicketComments(int ticketID) {
- String QUERY = "SELECT TicketID, Player, Timestamp, Message FROM " +
- "COMMENTS WHERE TicketID = " + ticketID;
- QueryFilter FILTER = new QueryFilter() {
- @Override
- public Object onExecute(ResultSet rs) {
- ArrayList<CommentItem> comments = new ArrayList<CommentItem>();
- try {
- while(rs.next()) {
- int ticketID = rs.getInt("TicketID");
- String player = rs.getString("Player");
- String message = rs.getString("Message");
- String date = rs.getString("Timestamp");
- comments.add(new CommentItem(player, message, date,
- ticketID));
- }
- } catch (SQLException e) {
- System.out.println(e.getLocalizedMessage());
- }
- return comments;
- }
- };
- return (ArrayList<CommentItem>) this.executeQuery(new StatementObject(
- this.getPlugin(), QUERY), FILTER);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement