ADO的事务处理例子(Delphi)

ADOConnection1.BeginTrans;   //开始事务
try
with ADOCommand1 do
begin
Connection:=ADOConnection1;
commandtext:='update [country] set [population]=10000 where [name]=''Venezuela''';//正确的SQL语句
Execute;
CommandText:='Wrong SQL Command';//错误的SQL
Execute;
ADOConnection1.CommitTrans; //提交事务
end;
except
on E: Exception do
begin
ADOConnection1.RollbackTrans; //如有异常，事务回滚
ShowMessage(E.Message);
end
end;
end;

转载于:https://www.cnblogs.com/martian6125/archive/2008/04/29/9631449.html