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';
   begin
   //setkey;
   if edit1.Text='' then
   showmessage('请输入查询编号');
   end
   //else
   //ADOTable1.FieldByName('BH').AsString:=edit1.Text;
  // if gotokey then
    //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.