public void update(int id, String title, String location) { SQLiteDatabase db = this.getWritableDatabase(); String where = FIELD_ID + "=?"; String[] whereValue = {Integer.toString(id)}; db.update(TABLE_NAME, createValues(title, location), where, whereValue); mListener.onFavoriteDatabaseChanged(); }
public void delete(String location) { SQLiteDatabase db = this.getWritableDatabase(); String where = FIELD_LOCATION + "=?"; String[] whereValue = {location}; db.delete(TABLE_NAME, where, whereValue); mListener.onFavoriteDatabaseChanged(); }
public void delete(long id, boolean notify) { SQLiteDatabase db = this.getWritableDatabase(); String where = FIELD_ID + "=?"; String[] whereValue = {Long.toString(id)}; db.delete(TABLE_NAME, where, whereValue); if (notify) mListener.onFavoriteDatabaseChanged(); }
public long insert(String title, String location) { if (isFavorite(location)) return -1; SQLiteDatabase db = this.getWritableDatabase(); long ret = db.insert(TABLE_NAME, null, createValues(title, location)); mListener.onFavoriteDatabaseChanged(); return ret; }