程序中的事务

1. 

sql.append("begin ");
      sql.append("update TB_CARD_PAYOFFCollect set bh= "+card_bh+ " where PAY_ID="+pay_id+" and bh is null; ");
      sql.append("update TB_CARD_PAYOFFDETAIL set CHECKFLAG=3 where PAY_ID="+pay_id+"; ");
      sql.append("end ;") ;

 

 

2.

  StringBuffer sql=new StringBuffer();
   sql.append("declare begin savepoint bg;");   
   sql.append("update TB_CARD_PAYOFFDETAIL set CHECKFLAG=3 where PAY_ID="+pay_id);
      sql.append(";commit; exception when others then   rollback to bg;  end;");
      DBHelper.update(sql.toString());