@Override public Word load(String name) { String selection = "NAME = ?"; String[] args = {name}; Cursor cursor = loadAll(Word.TABLE, Word.COLUMNS, selection, args); Word word = null; if (cursor.moveToFirst()) { word = new Word(); word.setID(cursor.getInt(cursor.getColumnIndex(Word._ID))); word.setName(cursor.getString(cursor.getColumnIndex(Word.NAME))); word.setType(WordType.valueOf(cursor.getString(cursor.getColumnIndex(Word.TYPE)))); word.setPlural(cursor.getString(cursor.getColumnIndex(Word.PLURAL))); word.setMeaning(cursor.getString(cursor.getColumnIndex(Word.MEANING))); word.setSynonym(cursor.getString(cursor.getColumnIndex(Word.SYNONYM))); word.setExample(cursor.getString(cursor.getColumnIndex(Word.EXAMPLE))); } return word; }
@Override public List<Word> loadAll() { List<Word> result = new ArrayList<Word>(); Cursor cursor = loadAll(Word.TABLE, Word.COLUMNS); if (cursor.moveToFirst()) { do { Word word = new Word(); word.setID(cursor.getInt(cursor.getColumnIndex(Word._ID))); word.setName(cursor.getString(cursor.getColumnIndex(Word.NAME))); word.setType(WordType.valueOf(cursor.getString(cursor.getColumnIndex(Word.TYPE)))); word.setPlural(cursor.getString(cursor.getColumnIndex(Word.PLURAL))); word.setMeaning(cursor.getString(cursor.getColumnIndex(Word.MEANING))); word.setSynonym(cursor.getString(cursor.getColumnIndex(Word.SYNONYM))); word.setExample(cursor.getString(cursor.getColumnIndex(Word.EXAMPLE))); result.add(word); } while (cursor.moveToNext()); } cursor.close(); return result; }