普通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, 排序);