android只更新一行数据,Sqlite数据库更新了一行android

有关了解如何更新数据库行的更一般帮助，documentation这次实际上非常有用：

SQLiteDatabase db = mDbHelper.getReadableDatabase();

// New value for one column

ContentValues values = new ContentValues();

values.put(FeedEntry.COLUMN_NAME_TITLE, title);

// Which row to update, based on the ID

String selection = FeedEntry.COLUMN_NAME_ENTRY_ID + " LIKE ?";

String[] selectionArgs = { String.valueOf(rowId) };

int count = db.update(

FeedReaderDbHelper.FeedEntry.TABLE_NAME,

values,

selection,

selectionArgs);

在我的情况下，我做了这样的方法：

public long updateTime(long rowId) {

// get current Unix epoc time in milliseconds

long date = System.currentTimeMillis();

SQLiteDatabase db = helper.getWritableDatabase(); // helper is MyDatabaseHelper, a subclass database control class in which this updateTime method is resides

ContentValues contentValues = new ContentValues();

contentValues.put(MyDatabaseHelper.DATE_TIME, date); // (column name, new row value)

String selection = MyDatabaseHelper.ID + " LIKE ?"; // where ID column = rowId (that is, selectionArgs)

String[] selectionArgs = { String.valueOf(rowId) };

long id = db.update(MyDatabaseHelper.FAVORITE_TABLE_NAME, contentValues, selection,

selectionArgs);

db.close();

return id;

}