- public void payment(){
- SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
- db.beginTransaction();//开启事务
- try{
- db.execSQL("update person set amount=amount-10 where personid=?", new Object[]{1});
- db.execSQL("update person set amount=amount+10 where personid=?", new Object[]{2});
- db.setTransactionSuccessful();//设置事务标志为成功,当结束事务时就会提交事务
- }finally{
- db.endTransaction();
- }
- }
Android SQLite 事物操作
最新推荐文章于 2021-05-27 03:47:00 发布