Example #1
0
  public ArrayList<Word> getWords() {
    ArrayList<Word> wordsList = new ArrayList<Word>();
    String selectQuery = "SELECT  * FROM " + TABLE_WORDS;

    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);

    if (cursor.moveToFirst()) {
      do {
        Word word = new Word();
        word.setId(cursor.getInt(0));
        word.setWord(cursor.getString(1));
        word.setTranslation(cursor.getString(2));
        word.setDateCreated(cursor.getString(3));
        word.setDateModified(cursor.getString(4));
        word.setWordLanguage(cursor.getString(5));
        word.setTranslationLanguage(cursor.getString(6));
        wordsList.add(word);
      } while (cursor.moveToNext());
    }

    cursor.close();
    db.close();

    return wordsList;
  }
Example #2
0
  public Word getWord(int wordId) {
    Word word = new Word();
    String selectQuery =
        "SELECT  * FROM " + TABLE_WORDS + " WHERE " + TABLE_WORDS_KEY_ID + "=" + wordId;

    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);

    if (cursor.moveToFirst()) {
      word.setId(cursor.getInt(0));
      word.setWord(cursor.getString(1));
      word.setTranslation(cursor.getString(2));
      word.setDateCreated(cursor.getString(3));
      word.setDateModified(cursor.getString(4));
      word.setWordLanguage(cursor.getString(5));
      word.setTranslationLanguage(cursor.getString(6));
    }

    cursor.close();
    db.close();

    return word;
  }