android SQLite 事物处理

最新推荐文章于 2023-06-12 15:02:59 发布

cappuccinoLau

最新推荐文章于 2023-06-12 15:02:59 发布

阅读量3.4k

点赞数

分类专栏： Android 数据库技术文章标签： android Android nested sqlite SQLite transactions

本文链接：https://blog.csdn.net/cappuccinoLau/article/details/8180339

版权

Android 同时被 2 个专栏收录

39 篇文章 0 订阅

订阅专栏

数据库技术

3 篇文章 0 订阅

订阅专栏

android SQLite 对事物处理的支持提供了4个方法。

public void beginTransaction()

Begins a transaction in EXCLUSIVE mode.

Transactions can be nested. When the outer transaction is ended all of the work done in that transaction and all of the nested transactions will be committed or rolled back. The changes will be rolled back if any transaction is ended without being marked as clean (by calling setTransactionSuccessful). Otherwise they will be committed.

Here is the standard idiom for transactions:

   db.beginTransaction();//开启事物
   try {
     //批量处理
     ...
     db.setTransactionSuccessful();//事物处理成功
   } finally {
     db.endTransaction();//结束事物
   }

此外还提供其他类似方法：
public void beginTransactionNonExclusive() //Begins a transaction in IMMEDIATE mode.
public void beginTransactionWithListener(SQLiteTransactionListener transactionListener)//Begins a transaction in EXCLUSIVE mode.
public void beginTransactionWithListenerNonExclusive(SQLiteTransactionListener transactionListener)//Begins a transaction in IMMEDIATE mode