testado_p.pas

该程序可用于com+中delphi组件的交易控制

unit testADO_p;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Grids, DBGrids, Db, ADODB, StdCtrls;

type
  TForm1 = class(TForm)
    ADOConnection1: TADOConnection;
    Button1: TButton;
    Memo1: TMemo;
    Button2: TButton;
    Memo2: TMemo;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Button3: TButton;
    ADOConnection2: TADOConnection;
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.DFM}

procedure TForm1.Button1Click(Sender: TObject);
var i,n:integer;
begin
  adoconnection1.Connected:=false;
  adoconnection1.Connected:=true;
  try
    adoconnection1.BeginTrans;
    for i:=0 to memo1.Lines.count-1 do
    begin
      if memo1.Lines[i]<>'' then
      begin
       adoconnection1.Execute(memo1.lines[i],n);
       memo2.Lines.Add(inttostr(n));
      end;
    end;
    adoconnection1.CommitTrans;
  except
    on e:exception do
    begin
      showmessage(e.message);
      adoconnection1.RollbackTrans;
    end;
  end;
  adoconnection1.Connected:=false;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
  adoquery1.close;
  adoquery1.Open;
end;

procedure TForm1.Button2Click(Sender: TObject);
var i,n:integer;
begin
  adoconnection1.Connected:=false;
  adoconnection1.Connected:=true;
  try
    adoconnection1.BeginTrans;
    for i:=0 to memo1.Lines.count-1 do
    begin
      if memo1.Lines[i]<>'' then
      begin
       adoconnection1.Execute(memo1.lines[i],n);
       memo2.Lines.Add(inttostr(n));
      end;
    end;
    adoconnection1.RollbackTrans;
  except
    on e:exception do
    begin
      showmessage(e.message);
      adoconnection1.RollbackTrans;
    end;
  end;
  adoconnection1.Connected:=false;
end;

end.