@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;
}
