public void testTransaction() throws Exception{
SQLiteDatabase db = helper.getWritableDatabase();
db.beginTransaction();//开始事务
try{
db.execSQL("update account set money = money - 5 where id = ?", new String[]{"2"});
}finally{
}
SQLiteDatabase db = helper.getWritableDatabase();
db.beginTransaction();//开始事务
try{
db.execSQL("update account set money = money - 5 where id = ?", new String[]{"2"});
db.execSQL("update account set money = money + 5 where id = ?", new String[]{"3"});
db.setTransactionSuccessful();
}finally{
db.endTransaction();
db.close();
}