直接上代码
public void testTransaction()throws Exception{
//数据库事务
PersonSQLiteOpenHelper helper = new PersonSQLiteOpenHelper(getContext(), "cwj.db", null, 4);
SQLiteDatabase db = helper.getWritableDatabase();
db.beginTransaction();
try {
db.execSQL("update person set account=account+5000 where name=?", new Object[]{"xiaozhui"});
db.execSQL("update person set account=account-5000 where name=?", new Object[]{"mumu"});
db.setTransactionSuccessful();
} finally {
db.endTransaction();
db.close();
}
}