Advertisement
Guest User

Untitled

a guest
Apr 27th, 2015
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. public void requestgoing(BufferedReader input) throws Exception {
  2. String eventid = input.readLine();
  3. ResultSet resultSet = statement.executeQuery("Select going_id from events_going as e inner join users as u on u.id=e.going_id where event_id=" + eventid + ";");
  4. String going = "";
  5. int counter = 0;
  6. while (resultSet.next()) {
  7. going += "user " + ++counter + "\n" + resultSet.getInt("id") + "\n" + resultSet.getString("firstname") + "\n" + resultSet.getString("lastname") + "\n";
  8. }
  9. going += "end\n";
  10. DataOut.writeBytes("Success\n" + going);
  11. }
  12.  
  13. public void requestinvited(BufferedReader input) throws Exception {
  14. String eventid = input.readLine();
  15. ResultSet resultSet = statement.executeQuery("Select invited_id from events_invited as e inner join users as u on u.id=e.invited_id where event_id=" + eventid + ";");
  16. String invited = "";
  17. int counter = 0;
  18. while (resultSet.next()) {
  19. invited += "user " + ++counter + "\n" + resultSet.getInt("id") + "\n" + resultSet.getString("firstname") + "\n" + resultSet.getString("lastname") + "\n";
  20. }
  21. invited += "end\n";
  22. DataOut.writeBytes("Success\n" + invited);
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement