//利用API进行数据库操作
public void insertApi() {
ContentValues values = new ContentValues();
values.put("name", "wen");
values.put("phone", "133");
values.put("salary", "1234");
//返回值是-1,插入失败
long l = db.insert("person", null, values);
}
//利用API进行数据库删除
public void deleteApi() {
int i = db.delete("person", "_id = ?", new String[]{"2"});
}
//利用API进行数据库更新
public void updateApi() {
ContentValues values = new ContentValues();
values.put("name", "wnwnewln");
db.update("person", values, "_id = ?",new String[]{"3"});
}
//查询
public void selectApi() {
Cursor cur = db.query("person", null, null, null, null, null, null);
while (cur.moveToNext()) {
String name = cur.getString(1);
String phone = cur.getString(2);
int salary = cur.getInt(3);
}
}
事务:保证多条语句同时生效或同时不生效,比如数据库数据转移,需要一增一减
<pre name="code" class="java">public void transaction() {
try{
//开启事务
db.beginTransaction();
ContentValues values = new ContentValues();
values.put("salary", 13000);
db.update("person", values, "name = ?", new String[]{"cui"});
//记住values在重新put时,要clean一下,否则会把别的数据不需要改的项也覆盖掉
values.clear();
values.put("salary", 13100);
db.update("person", values, "name = ?", new String[]{"wen"});
//需要设置事务执行成功,没有这一设置。会回滚
db.setTransactionSuccessful();
}catch(Exception e){
e.printStackTrace();
}
finally{
//关闭事务,提交数据
db.endTransaction();
}
}