public ArrayList<RsvpData> getAllRsvpData() { ArrayList<RsvpData> dataList = new ArrayList<>(); try { if (databaseInfo.getMySQL().checkConnection()) { String rsvpTableName = String.format("%srsvp", databaseInfo.getPrefix()); PreparedStatement stmt = databaseInfo.getConnection().prepareStatement("SELECT * FROM " + rsvpTableName); ResultSet res = stmt.executeQuery(); while (res.next()) { if (res.getString("GUILD_ID") != null) { RsvpData data = new RsvpData(Long.valueOf(res.getString("GUILD_ID"))); data.setEventId(res.getString("EVENT_ID")); data.setEventEnd(res.getLong("EVENT_END")); data.setGoingOnTimeFromString(res.getString("GOING_ON_TIME")); data.setGoingLateFromString(res.getString("GOING_LATE")); data.setNotGoingFromString(res.getString("NOT_GOING")); data.setUndecidedFromString(res.getString("UNDECIDED")); dataList.add(data); } } stmt.close(); } } catch (SQLException e) { Logger.getLogger().exception(null, "Failed to get all RSVP Data!", e, this.getClass()); } return dataList; }
statement.setString(1, data.getEventId()); " VALUES (?, ?, ?, ?, ?, ?, ?)"; PreparedStatement ps = databaseInfo.getConnection().prepareStatement(insertCommand); ps.setString(1, String.valueOf(data.getGuildId())); ps.setString(2, data.getEventId()); ps.setLong(3, data.getEventEnd()); ps.setString(4, data.getGoingOnTimeString()); ps.setString(5, data.getGoingLateString()); ps.setString(6, data.getNotGoingString()); ps.setString(7, data.getUndecidedString()); PreparedStatement ps = databaseInfo.getConnection().prepareStatement(update); ps.setLong(1, data.getEventEnd()); ps.setString(2, data.getGoingOnTimeString()); ps.setString(3, data.getGoingLateString()); ps.setString(4, data.getNotGoingString()); ps.setString(5, data.getUndecidedString()); ps.setString(6, data.getEventId());
body.put("on_time", rsvp.getGoingOnTime()); body.put("late", rsvp.getGoingLate()); body.put("undecided", rsvp.getUndecided()); body.put("not_going", rsvp.getNotGoing());
body.put("on_time", rsvp.getGoingOnTime()); body.put("late", rsvp.getGoingLate()); body.put("undecided", rsvp.getUndecided()); body.put("not_going", rsvp.getNotGoing());
body.put("on_time", rsvp.getGoingOnTime()); body.put("late", rsvp.getGoingLate()); body.put("undecided", rsvp.getUndecided()); body.put("not_going", rsvp.getNotGoing());
public RsvpData getRsvpData(long guildId, String eventId) { RsvpData data = new RsvpData(guildId); data.setEventId(eventId); try { if (databaseInfo.getMySQL().checkConnection()) { String rsvpTableName = String.format("%srsvp", databaseInfo.getPrefix()); String query = "SELECT * FROM " + rsvpTableName + " WHERE GUILD_ID= ?"; PreparedStatement statement = databaseInfo.getConnection().prepareStatement(query); statement.setString(1, guildId + ""); ResultSet res = statement.executeQuery(); while (res.next()) { if (res.getString("EVENT_ID").equals(eventId)) { data.setEventEnd(res.getLong("EVENT_END")); data.setGoingOnTimeFromString(res.getString("GOING_ON_TIME")); data.setGoingLateFromString(res.getString("GOING_LATE")); data.setNotGoingFromString(res.getString("NOT_GOING")); data.setUndecidedFromString(res.getString("UNDECIDED")); break; } } statement.close(); } } catch (SQLException e) { Logger.getLogger().exception(null, "Failed to get RSVP data for event", e, this.getClass()); } return data; }
rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("on_time").length(); i++) { String s = jsonMain.getJSONArray("on_time").getString(i); rsvp.getGoingOnTime().add(s); rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("late").length(); i++) { String s = jsonMain.getJSONArray("late").getString(i); rsvp.getGoingLate().add(s); rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("undecided").length(); i++) { String s = jsonMain.getJSONArray("undecided").getString(i); rsvp.getUndecided().add(s); rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("not_going").length(); i++) { String s = jsonMain.getJSONArray("not_going").getString(i); rsvp.getNotGoing().add(s);
rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("on_time").length(); i++) { String s = jsonMain.getJSONArray("on_time").getString(i); rsvp.getGoingOnTime().add(s); rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("late").length(); i++) { String s = jsonMain.getJSONArray("late").getString(i); rsvp.getGoingLate().add(s); rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("undecided").length(); i++) { String s = jsonMain.getJSONArray("undecided").getString(i); rsvp.getUndecided().add(s); rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("not_going").length(); i++) { String s = jsonMain.getJSONArray("not_going").getString(i); rsvp.getNotGoing().add(s);
rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("on_time").length(); i++) { String s = jsonMain.getJSONArray("on_time").getString(i); rsvp.getGoingOnTime().add(s); rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("late").length(); i++) { String s = jsonMain.getJSONArray("late").getString(i); rsvp.getGoingLate().add(s); rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("undecided").length(); i++) { String s = jsonMain.getJSONArray("undecided").getString(i); rsvp.getUndecided().add(s); rsvp.getGoingOnTime().clear(); for (int i = 0; i < jsonMain.getJSONArray("not_going").length(); i++) { String s = jsonMain.getJSONArray("not_going").getString(i); rsvp.getNotGoing().add(s);