public static List<Reservation> getAllEventReservations(int eventid) {
        try {
            Connection con = DB.getConnection();
            PreparedStatement ps = con.prepareStatement(GETALLEVENTRESERVATIONS);
            ps.setInt(1, eventid);
            ResultSet result = ps.executeQuery();
            List<Reservation> reserves = new ArrayList<Reservation>();
            while (result.next()) {
                Reservation res = extractReservation(result);
                res.user = extractUser(result);
                reserves.add(res);
            }
            return reserves;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }