private LessonListElement getLessonFromCursor(Cursor c) { LessonListElement lesson; lesson = new LessonListElement(); lesson.setId(c.getLong(c.getColumnIndex(LessonTableModel.ID))); lesson.setDayNumber(c.getInt(c.getColumnIndex(LessonTableModel.DAY))); lesson.setLessonNumber(c.getInt(c.getColumnIndex(LessonTableModel.NUMBER))); lesson.setInformation(getLessonInformation(c.getLong(c.getColumnIndex(LessonTableModel.ID)))); return lesson; }
public LessonListElement getLesson(Long lesonId) { LessonListElement result = new LessonListElement(); Cursor c = mDb.rawQuery( TextUtils.concat( "SELECT * FROM ", LessonTableModel.TABLE_NAME, " WHERE ", LessonTableModel.ID, "=?") .toString(), new String[] {lesonId.toString()}); c.moveToFirst(); if (c.getCount() != 0) { result.setId(c.getLong(c.getColumnIndex(LessonTableModel.ID))); result.setDayNumber(c.getInt(c.getColumnIndex(LessonTableModel.DAY))); result.setLessonNumber(c.getInt(c.getColumnIndex(LessonTableModel.NUMBER))); result.setInformation(getLessonInformation(lesonId)); } return result; }