public GradeItem(ResultSet rs) throws Exception {
        DBConnector db = new DBConnector();
        if(rs.next()){
            setGradeItemID(rs.getInt("gradeitemid"));
            setStudent(db.getPerson(rs.getInt("studentid")));
            setCourse(db.getCourse(rs.getInt("courseid")));
            setTitle(rs.getString("title"));
            setPossiblePoints(rs.getInt("possiblepoints"));
            setEarnedPoints(rs.getInt("earnedpoints"));
            setType(rs.getString("gradeitemtype.type"));
        }
    }