sqlunit.pas

航班管理

unit sqlUnit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Buttons, Grids, DBGrids, DB, ADODB, StdCtrls;

type
  TForm8 = class(TForm)
    Memo1: TMemo;
    Label1: TLabel;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    DBGrid1: TDBGrid;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form8: TForm8;

implementation

{$R *.dfm}

procedure TForm8.SpeedButton1Click(Sender: TObject);
begin
  with adoquery1 do
  begin
     close;
     sql.clear;
     sql.add(memo1.Text);
     open;
     if ADOQuery1.RecordCount=0 then
      begin
       showmessage('无此记录，请确认！');
      end;
   end;  
end;

procedure TForm8.SpeedButton2Click(Sender: TObject);
begin
   close;
end;

end.