コード例 #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;
  }
コード例 #2
0
 public void deleteWord(Word word) {
   if (word == null) {
     return;
   }
   SQLiteDatabase db = this.getWritableDatabase();
   db.delete(TABLE_WORDS, TABLE_WORDS_KEY_ID + " = " + word.getId(), null);
   db.close();
 }
コード例 #3
0
  public void updateWord(Word word) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();
    values.put(TABLE_WORDS_KEY_WORD, word.getWord());
    values.put(TABLE_WORDS_KEY_TRANSLATION, word.getTranslation());
    values.put(TABLE_WORDS_KEY_DATE_ADDED, word.getDateCreated());
    values.put(TABLE_WORDS_KEY_DATE_MODIFIED, word.getDateModified());
    values.put(TABLE_WORDS_KEY_WORD_LANGUAGE, word.getWordLanguage());
    values.put(TABLE_WORDS_KEY_TRANSLATION_LANGUAGE, word.getTranslationLanguage());

    db.update(TABLE_WORDS, values, TABLE_WORDS_KEY_ID + "=" + word.getId(), null);
    db.close();
  }
コード例 #4
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;
  }