unit4.~pas

关于delphi的相关源码

unit Unit4;

interface

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

type
  TForm4 = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    DBGrid1: TDBGrid;
    BitBtn1: TBitBtn;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    BitBtn2: TBitBtn;
    procedure BitBtn1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form4: TForm4;

implementation

uses Unit3;

{$R *.dfm}

procedure TForm4.BitBtn1Click(Sender: TObject);
var
 sqlstr:string;
begin
  if trim(edit1.Text)='' then
  begin
    showmessage('姓名查洵项不能为空!');
    edit1.SetFocus;
    exit;
  end;
  sqlstr:='';
  sqlstr:='name like''%'+edit1.text+'%''and unit like ''%'+edit2.text+'%''and telphone like ''%'+edit3.text+'%''and mobile like ''%'+edit4.text+'%''';
  adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Text:='select * from tongxianlu where '+sqlstr+'';
  adoquery1.Open;
end;

procedure TForm4.FormClose(Sender: TObject; var Action: TCloseAction);
begin

 form3.show;
end;

end.