Android Database Transactions __ Database

In the development of Android applications, transaction processing is very important when using a database.


        first Android database operations (especially write operations) are very slow, and packing all operations into one transaction can greatly improve processing speed.


        is followed by ensuring that data is consistent so that all operations in one transaction execute successfully or fail, or all operations are rolled back.


        If you prefer to use a different platform (such as PHP + MySQL), the code is usually run on a powerful server, typically not accidentally aborted, but on the Android platform, You will be surprised by the interruption of the accident again and again. The android system kills Apps/threads/activities and so on, and the battery will run out or be removed. So it's important to use database things. The


        Implementation of the Android database transaction is simple and requires only three methods of using the Sqlitedatabase class.


        BeginTransaction ();
        settransactionsuccessful ();
        endtransaction ();

        when endtransaction () is invoked, all operations starting from BeginTransaction () are committed.


        

Db.begintransaction ();
try{
  //In the execution of multiple database operations
  //execution may throw an exception
  db.settransactionsuccessful ();
  No database operations between Settransactionsuccessful and Endtransaction
  }catch (Exception e) {
    //When an error occurs in the database operation, you need to catch the exception to end the transaction
    db.endtransaction ();
    throw e;
  }
  Ends a transaction db.endtransaction () when all operations are completed
  ;