Database transaction Usage Analysis in Android development _android

This example describes the usage of database transactions in Android development. Share to everyone for your reference, specific as follows:

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 the operations into one transaction can greatly improve processing speed.

The second is to ensure that the data is consistent so that all operations in one transaction are executed 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 and will not be accidentally aborted, but on the Android platform you will be surprised by the interruption over and over 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.

Implementing an 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.

A simple database transaction operation is shown below:

Mdatabase.begintransaction ();
try{
 //In the execution of multiple database operations
 //execution may throw an exception
 mdatabase.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
  mdatabase.endtransaction ();
  Throwe;
 }
 Ends a transaction mdatabase.endtransaction () when all operations are completed
 ;

For more information on Android-related content readers can view the site topics: "Android Database Operating skills summary", "Android programming activity Operation Skills Summary", "Android File Operation skills Summary", " Android programming development of the SD card operation method Summary, "Android Development introduction and Advanced Course", "Android Resource Operation skills Summary", "Android View tips Summary" and "Android Control usage Summary"

I hope this article will help you with the Android program.