Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void requestgoing(BufferedReader input) throws Exception {
- String eventid = input.readLine();
- 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 + ";");
- String going = "";
- int counter = 0;
- while (resultSet.next()) {
- going += "user " + ++counter + "\n" + resultSet.getInt("id") + "\n" + resultSet.getString("firstname") + "\n" + resultSet.getString("lastname") + "\n";
- }
- going += "end\n";
- DataOut.writeBytes("Success\n" + going);
- }
- public void requestinvited(BufferedReader input) throws Exception {
- String eventid = input.readLine();
- 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 + ";");
- String invited = "";
- int counter = 0;
- while (resultSet.next()) {
- invited += "user " + ++counter + "\n" + resultSet.getInt("id") + "\n" + resultSet.getString("firstname") + "\n" + resultSet.getString("lastname") + "\n";
- }
- invited += "end\n";
- DataOut.writeBytes("Success\n" + invited);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement