普通sqlite和谷歌API操作数据区别小结

普通sqlite和谷歌API操作数据区别小结

1.增

insert into tableName(columnName1,columnName2,...) values (?,?,...) 

ContentValues values = new ContentValues();
values.put(columnName, value);
db.insert(tableName,null,values);

2.删

delete from tableName where columnName=?    

db.delete(tableName, "name=?", new String[]{value});

3.改

update tableName set columnName1 = ? where columnName2 = ?

ContentValues values = new ContentValues();
values.put(columnName, value);
db.update(tableName, values, "name=?", new String[] { value });

4.查

select * from tableName where columnName = ?    

Cursor cursor = db.query(tableName, 需要查询的列(new String[]{"name","age"}), "name=?", new String[]{value},null,null, 排序);