zlchaxun.pas

学员管理系统 (delphi+ACCESS)

unit zlchaxun;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DBActns, ActnList, ExtDlgs, StdCtrls, Grids, DBGrids, DBCtrls,
  Mask, ExtCtrls, ComCtrls, DB, ADODB;

type
  TFrmchaxun = class(TForm)
    PageControl1: TPageControl;
    TSlr1: TTabSheet;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Bevel1: TBevel;
    DBEdit1: TDBEdit;
    DBImage1: TDBImage;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    DBMemo1: TDBMemo;
    GroupBox2: TGroupBox;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Label21: TLabel;
    Label22: TLabel;
    DBEdit8: TDBEdit;
    DBEdit9: TDBEdit;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    DBEdit12: TDBEdit;
    DBEdit13: TDBEdit;
    DBEdit14: TDBEdit;
    DBEdit15: TDBEdit;
    DBEdit16: TDBEdit;
    DBEdit17: TDBEdit;
    DBMemo2: TDBMemo;
    TSlr2: TTabSheet;
    DBGrid1: TDBGrid;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button9: TButton;
    ActionList1: TActionList;
    DataSetFirst1: TDataSetFirst;
    DataSetPrior1: TDataSetPrior;
    DataSetNext1: TDataSetNext;
    DataSetLast1: TDataSetLast;
    DataSetInsert1: TDataSetInsert;
    DataSetDelete1: TDataSetDelete;
    DataSetPost1: TDataSetPost;
    DataSetCancel1: TDataSetCancel;
    DataSetRefresh1: TDataSetRefresh;
    CBcxtj: TComboBox;
    Label23: TLabel;
    edcx: TEdit;
    Label24: TLabel;
    Button5: TButton;
    DBEdit18: TDBEdit;
    DBEdit19: TDBEdit;
    adoquery1: TADOQuery;
    DataSource1: TDataSource;
    procedure Button5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frmchaxun: TFrmchaxun;

implementation
 uses login,data,zlzhu;
{$R *.dfm}

procedure TFrmchaxun.Button5Click(Sender: TObject);
 var
  str1,strsql:string;
begin

  str1:=edcx.Text;

  case cbcxtj.ItemIndex of
   0:begin
     strsql:='select * from zl01 where 姓名='''+str1+'''';
     adoquery1.close;
     adoquery1.SQL.Clear;

     adoquery1.SQL.add(strsql);

     adoquery1.Prepared;
     adoquery1.Open;
     end;
    1:begin
       strsql:='select * from zl01 where 固定电话='''+str1+'''';
       adoquery1.close;
       adoquery1.SQL.Clear;

       adoquery1.SQL.add(strsql);

       adoquery1.Prepared;
       adoquery1.Open;
       end;
    2:begin
     strsql:='select * from zl01 where 移动电话='''+str1+'''';
     adoquery1.close;
     adoquery1.SQL.Clear;

     adoquery1.SQL.add(strsql);

     adoquery1.Prepared;
     adoquery1.Open;
     end;
     3:begin
       strsql:='select * from zl01 where 出证日期='''+str1+'''';
       adoquery1.close;
       adoquery1.SQL.Clear;
       adoquery1.SQL.add(strsql);
       adoquery1.Prepared;
       adoquery1.Open;
       end;
      4:begin
       strsql:='select * from zl01 where 领证日期='''+str1+'''';
       adoquery1.close;
       adoquery1.SQL.Clear;
       adoquery1.SQL.add(strsql);
       adoquery1.Prepared;
       adoquery1.Open;
       end;
      5:begin
       strsql:='select * from zl01 where 类型='''+str1+'''';
       adoquery1.close;
       adoquery1.SQL.Clear;
       adoquery1.SQL.add(strsql);
       adoquery1.Prepared;
       adoquery1.Open;
       end;
   end
end;

end.