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

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();

}

}

}