Android 数据库 存储过程

/*** 银行转账的方法*/public void transaction() {SQLiteDatabase db = dbOpenHelper.getWritableDatabase();if (db.isOpen()) {try {// 开启数据库的事务db.beginTransaction();// 给张三设置1000块钱的账户db.execSQL("update person set account=? where name=?",new Object[] { 1000, "zhangsan98" });// 把张三的账户扣除200块钱db.execSQL("update person set account=account-? where name=?",new Object[] { 200, "zhangsan98" });// 出现了异常// 把张三的钱给李四//初始化李四账户 为 0db.execSQL("update person set account=? where name=?",new Object[] { 0, "lisi" });db.execSQL("update person set account=account+? where name=?",new Object[] { 200, "lisi" });db.setTransactionSuccessful();}// 显示的设置事务是否成功catch (Exception e) {// TODO: handle exception} finally {db.endTransaction();db.close();}}}