android sqlite增删改查语句

增加：

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});