main.~pas

多线程管理发现处理数据库死锁问题

unit Main;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ComCtrls, ToolWin, StdCtrls, DB, ADODB,Helper,ReleaseThread;

type
  TForm1 = class(TForm)
    RichEdit1: TRichEdit;
    StatusBar1: TStatusBar;
    ToolBar1: TToolBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    procedure ToolButton1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
  private
    constring:string;
    rt:ReleaseThreads;
    bExit:TBRun;
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.ToolButton1Click(Sender: TObject);
begin
  bExit.FRun := true;
  constring:='Provider=SQLOLEDB.1;Password=888;Persist Security Info=True;User ID=sa;Data Source=134.242.6.200';
  rt:=ReleaseThreads.Create(self.RichEdit1,bExit,constring);
  ToolButton1.Enabled :=false;
end;

procedure TForm1.FormCreate(Sender: TObject);
begin
  bExit:= TBRun.Create;
  bExit.FRun := true;
end;

procedure TForm1.ToolButton3Click(Sender: TObject);
begin
  Application.Terminate;
end;

procedure TForm1.ToolButton2Click(Sender: TObject);
begin
  bExit.FRun := false;
  ToolButton1.Enabled :=true;
end;

end.