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; }
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; }