unit1.pas

用来查询搜索数据库数据的查询模块,可以通过设置的条件查询

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DB, ADODB, DBTables;

type
  TForm1 = class(TForm)
    ADOTable1: TADOTable;
    ADOConnection1: TADOConnection;
    DataSource1: TDataSource;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Memo1: TMemo;
    Button1: TButton;
    Button2: TButton;
    Table1: TTable;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
   label3.Caption:='';
   //indexfieldnames:='BH';
   //setkey;
   if edit1.Text='' then
   begin
   showmessage('请输入查询编号');
   end
   else
   begin
   ADOTable1.FieldByName('BH').AsString:=edit1.Text;
  //if gotokey then
  end ;
    begin
    label3.Caption:='查找成功';
  Edit2.Text:=ADOTable1.Fieldbyname('XM').AsString+'-'+ADOTable1.fieldbyname('XX').AsString;
   memo1.Lines[0]:='编号：'+ADOTable1.fieldbyname('BH').AsString;
    memo1.Lines[1]:='姓名：'+ADOTable1.fieldbyname('XM').AsString;
    memo1.Lines[2]:='信息：'+ADOTable1.fieldbyname('XX').AsString;
    end;
    {//else
     //begin
     edit2.Text:='此人不存在';
     label3.Caption:='查找失败';
     memo1.Lines[0]:='此人不存在';
    memo1.Lines[1]:='';
    memo1.Lines[2]:=''; }
    end;
    //end;
    //end;

//end;

procedure TForm1.Button2Click(Sender: TObject);
begin
close;
end;

end.