SQLiteDatabase的增删查改

增

• 单条数据插入

    ContentValues values = new ContentValues();
    // Column1和Column2表示列名，下同
    values.put("Column1", user.id);
    values.put("Column2", user.name);
    // TableName表示表名，下同
    db.insert("TableName", null, values);

• 批量数据插入

db.beginTransaction();
try {
    ContentValues values = new ContentValues();
    for (User user :
            list) {
        values.put("Column1", user.id);
        values.put("Column2", user.name);
        db.insert("TableName", null, values);
    }
        db.setTransactionSuccessful();
    } finally {
        db.endTransaction();
}

删

• 根据条件删除

// 删除Column1的值等于id的行
db.delete("TableName", "Column1" + " = ?", new String[]{id});

• 删除数据表中所有数据

db.delete("TableName", null, null);

查

• 根据条件查询

// 查询数据表中Column1列的值大于id且Column2列的值等于name的行，只需返回Column2列的值，
// 如果需要所有列，将"SELECT Column2 FROM"改为"SELECT * FROM"
Cursor cursor = mSqLiteDatabase.rawQuery("SELECT Column2 FROM " + "TableName" + " WHERE Column1 > ? and Column2 = ?", new String[]{id, name});
while (cursor.moveToNext()) {
    User user = new User();
    user.id= cursor.getInt(1);
    user.name = cursor.getString(2);
    list.add(record);
}
cursor.close();

• 查询数据表中所有数据

Cursor cursor = mSqLiteDatabase.rawQuery("SELECT * FROM " + "TableName", null);
while (cursor.moveToNext()) {
    User user = new User();
    user.id= cursor.getInt(1);
    user.name = cursor.getString(2);
    list.add(record);
}
cursor.close();

改

ContentValues values = new ContentValues();
values.put("Column1", newId);
values.put("Column2", newName);
db.update("TableName", values, "id = ?", new String[]{id});