public Course getCourse(String id) { Cursor cursor = dbadapter.getCourse(id); Course course = new Course(cursor.getString(cursor.getColumnIndex("key"))); course.setTitle(cursor.getString(cursor.getColumnIndex("title"))); course.setLevel(cursor.getString(cursor.getColumnIndex("level"))); course.setSCQFLevel(cursor.getString(cursor.getColumnIndex("scqf_level"))); course.setAcronym(cursor.getString(cursor.getColumnIndex("acronym"))); course.setNormalYear(cursor.getString(cursor.getColumnIndex("normal_year"))); course.setVisitorsOnly(cursor.getString(cursor.getColumnIndex("visitors_only"))); course.setBlocks(cursor.getString(cursor.getColumnIndex("blocks"))); course.setCO(cursor.getString(cursor.getColumnIndex("co"))); course.setSY(cursor.getString(cursor.getColumnIndex("sy"))); course.setFirstMeet(cursor.getString(cursor.getColumnIndex("first_meet"))); course.setLocation(cursor.getString(cursor.getColumnIndex("location"))); course.setSpecialArrangements(cursor.getString(cursor.getColumnIndex("special_arrangements"))); course.setEvents( cursor.getString(cursor.getColumnIndex("start")), cursor.getString(cursor.getColumnIndex("end")), cursor.getString(cursor.getColumnIndex("alts")), cursor.getString(cursor.getColumnIndex("sites"))); course.setOptions(cursor.getString(cursor.getColumnIndex("options"))); Cursor cursor_ = dbadapter.getCollege(cursor.getString(cursor.getColumnIndex("college"))); if (cursor_.getCount() > 0) course.setCollege( new College( cursor_.getString(cursor_.getColumnIndex("key")), cursor_.getString(cursor_.getColumnIndex("name")))); cursor_.close(); cursor_ = dbadapter.getSchool(cursor.getString(cursor.getColumnIndex("school"))); if (cursor_.getCount() > 0) course.setSchool( new School( cursor_.getString(cursor_.getColumnIndex("key")), cursor_.getString(cursor_.getColumnIndex("name")))); cursor_.close(); cursor_ = dbadapter.getSubjectArea(cursor.getString(cursor.getColumnIndex("subject_area"))); if (cursor_.getCount() > 0) course.setSubjectArea( new SubjectArea( cursor_.getString(cursor_.getColumnIndex("key")), cursor_.getString(cursor_.getColumnIndex("name")))); cursor_.close(); cursor.close(); return course; }