增加:
db.insert(TABLE_NAME, null, values);
删除:
db.execSQL("DELETE FROM upload_batch WHERE batch_id = ?", new String[]{batchId});
查询:
Cursor cursor = db.query(TABLE_NAME, null,"upload_state = ? and user = ? and is_show = ?",new String[]{"3",userId,"1"}, null, null, null);
Cursor cursor = db.query(TABLE_NAME, null,"(upload_state = ? or upload_state = ? or upload_state = ?) and user = ? and is_show = ?",new String[]{"0","1","2",userId,"1"}, null, null, null);
修改:
db.update(TABLE_NAME,values,"batch_id = ?",new String[]{temporaryId});