public static Reservation extractReservation(ResultSet result) throws Exception{
        int id = result.getInt("id");
        int userid = result.getInt("userid");        
        int eventid = result.getInt("eventid");
        Timestamp timereserved = result.getTimestamp("timereserved");
        Timestamp startTime = result.getTimestamp("startTime");
        int slotnum = result.getInt("slotnum");
        Reservation res = new Reservation(id, userid, eventid, timereserved, startTime, slotnum);
        return res;
    }