unittestform.pas

手机批发商进销存管理

unit UnitTestForm;

interface

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

type
  TTestForm = class(TForm)
    DBGrid1: TDBGrid;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    DBNavigator1: TDBNavigator;
    Panel1: TPanel;
    Button2: TButton;
    Button1: TButton;
    Memo1: TMemo;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  TestForm: TTestForm;

implementation

uses UnitDM;

{$R *.DFM}

procedure TTestForm.Button1Click(Sender: TObject);
begin
  try
    ADOQuery1.Close;
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Text := Memo1.Lines.Text;
    ADOQuery1.Open;
  except
    ADOQuery1.Close;
  end;
end;

procedure TTestForm.Button2Click(Sender: TObject);
begin
  try
    ADOQuery1.Close;
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Text := Memo1.Lines.Text;
    ADOQuery1.ExecSQL;
    ADOQuery1.Close;    
  except
    ADOQuery1.Close;
  end;
end;

procedure TTestForm.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  ADOQuery1.Close;
  Action := caFree;
  TestForm := Nil;
end;

procedure TTestForm.FormCreate(Sender: TObject);
begin
  Memo1.Lines.Clear;
  ADOQuery1.Close;  
end;

end.