/* GET PASSED EXAMS */ public Cursor getPassedExams() { database = course_dbHelper.getWritableDatabase(); String where = DB_ABSTRACTS.DBCourse.PASSED_COLUMN + " = " + 1; Cursor cursor = database.query( DB_ABSTRACTS.DBCourse.DATABASE_TABLE, examColumns, where, null, null, null, DB_ABSTRACTS.DBCourse.PASS_MARK_COLUMN + " ASC"); if (cursor.moveToFirst()) { do { Course course = new Course(); course.setId(cursor.getInt(cursor.getColumnIndex(DB_ABSTRACTS.DBCourse.KEY_ID))); course.setName(cursor.getString(cursor.getColumnIndex(DB_ABSTRACTS.DBCourse.NAME_COLUMN))); course.setPassed(cursor.getInt(cursor.getColumnIndex(DB_ABSTRACTS.DBCourse.PASSED_COLUMN))); course.setPass_mark( cursor.getString(cursor.getColumnIndex(DB_ABSTRACTS.DBCourse.PASS_MARK_COLUMN))); } while (cursor.moveToNext()); } return cursor; }