Sqlite資料庫中的事務

標籤：

 

public void testTrasaction() throws Exception{
  PersonSQLiteOpenHelper helper = new PersonSQLiteOpenHelper(getContext());
  SQLiteDatabase db = helper.getWritableDatabase();
  db.beginTransaction();
  try{
   db.execSQL("update sys_user set account = account-500 where name=?",new Object[]{"zhangsan"});
   
   db.execSQL("update sys_user set account = account+500 where name=?",new Object[]{"lisi"});
   //標記資料庫事務執行成功。
   db.setTransactionSuccessful();
  }catch(Exception e)
  {
   Toast.makeText(getContext(), "轉賬出錯!", Toast.LENGTH_LONG).show();
  }
  
  finally{
   db.endTransaction();
   db.close();
  }

Sqlite資料庫中的事務