csearch.txt

来自「Delphi 7 数据库编程(Powerpoint 幻灯片格式)」· 文本 代码 · 共 72 行

CSearch.pas程序清单

unit; CSearch
interface
uses
  Windows, Messages, Classes, SysUtils, Graphics, Controls, StdCtrls, Forms,
  Dialogs, DBCtrls, DB, DBGrids, DBTables, Grids, ExtCtrls, Buttons;
type
  TForm2 = class(TForm)
    customerTableCustNum: TFloatField;
    customerTableLastName: TStringField;
    customerTableFirstName: TStringField;
    DBGrid1: TDBGrid;
    DBNavigator: TDBNavigator;
    Panel1: TPanel;
    DataSource1: TDataSource;
    Panel2: TPanel;
    customerTable: TTable;
    cmdExit: TButton;
    cmdSearch: TBitBtn;
    procedure FormCreate(Sender: TObject);
    procedure cmdExitClick(Sender: TObject);
    procedure cmdSearchClick(Sender: TObject);
  private
    { private declarations }
  public
    { public declarations }
  end;
var
  Form2: TForm2;
implementation
{$R *.DFM}
procedure TForm2.FormCreate(Sender: TObject);
begin
  CustomerTable.Open;
end;
procedure TForm2.cmdExitClick(Sender: TObject);
begin
Application.Terminate;
end;
procedure TForm2.cmdSearchClick(Sender: TObject);
var
CustNumToSearchString:String;
ResultBoolean:Boolean;
begin
{
CustNumToSearchString:=
 InputBox('Serch',
          'Type the Customer Number to be searched:',
          '');
 }
 {
 ResultBoolean:=CustomerTable.Findkey([CustNumToSearchString]);
  }
  CustomerTable.IndexName:='MyLastName';
  ResultBoolean:=
      CustomerTable.FindKey(['Anderson']);
      CustomerTable.IndexName:='';
 if not ResultBoolean then
    MessageDlg('没找到!',
    mtInformation,
    [mbOK],
    0);
 if ResultBoolean then
 MessageDlg('记录找到!',
    mtInformation,
    [mbOK],
    0);
end;
end.