android 数据库事务处理简单介绍

参照上篇日志的代码结构，添加该文件

TestTransaction.java

package com.demo.introductiontothedb.test;import com.demo.introductiontothedb.PersonDBOpenHelper;import android.database.sqlite.SQLiteDatabase;import android.test.AndroidTestCase;public class TestTransaction extends AndroidTestCase {public void testTran(){PersonDBOpenHelper helper = new PersonDBOpenHelper(getContext());SQLiteDatabase db = helper.getWritableDatabase();db.beginTransaction();try {db.execSQL("update personInfo set money='5000' where id = '20'");db.execSQL("update personInfo set money='9500' where id = '21'");db.setTransactionSuccessful();//只有设置了事务执行成功数据才会在endTransaction()的时候提交到数据库}catch(Exception e){}finally {db.endTransaction();}}}