public Course(ResultSet rs) throws Exception{
        DBConnector db = new DBConnector();
        if(rs.next()){
            setCourseID(rs.getInt("courseid"));
            setTitle(rs.getString("title"));
            setYear(rs.getInt("year"));
            setSeason(rs.getString("season"));
            setTeacher(db.getPerson(rs.getInt("teacherid")));
        }
    }