seek_user.pas

来自「该是一个比较好的图书馆系统,是现在大学生软件课程设计的好模板」· PAS 代码 · 共 85 行

unit seek_user;

interface

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

type
  Tseekuser = class(TForm)
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    GroupBox1: TGroupBox;
    Button1: TButton;
    GroupBox2: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    Button2: TButton;
    Button3: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  seekuser: Tseekuser;

implementation

{$R *.dfm}

procedure Tseekuser.Button1Click(Sender: TObject);
begin
 adoquery1.Close;
 adoquery1.SQL.Clear;
 adoquery1.SQL.Text:='select StuID as ''图书证号'',Name as ''姓名'',StuGroup as''学历'',Gender as ''性别'',Phone ''电话号码'',Mail ''邮件'' from [User]';
 adoquery1.Open;
end;

procedure Tseekuser.Button2Click(Sender: TObject);
begin
if Edit1.Text=''then
 begin
 showmessage('请输入您想要查询的关键字！');
 end
 else
 begin
 adoquery1.Close;
 adoquery1.SQL.Clear;
 adoquery1.SQL.Text:='select StuID  from [User] where StuID='''+Edit1.text+'''';
 adoquery1.Open;
 if adoquery1.FieldByName('StuID').AsString='' then
 begin
 showmessage('对不起，该用户不存在！');
 end
 else
 begin                            adoquery1.Close;
 adoquery1.SQL.Clear;
 adoquery1.SQL.Text:='select StuID as ''图书证号'',Name as ''姓名'',StuGroup as''学历'',Gender as ''性别'',Phone ''电话号码'',Mail ''邮件'' from [User] where StuID='''+Edit1.text+'''';
 adoquery1.Open;
 
 end;
end;
end;

procedure Tseekuser.Button3Click(Sender: TObject);
begin
close;
end;

procedure Tseekuser.FormShow(Sender: TObject);
begin
 edit1.Text:='';
 adoquery1.Close;
 adoquery1.SQL.Clear;
end;

end.