unit1.pas

数据库编程 人事档案管理

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    Database1: TDatabase;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Table1: TTable;
    Edit2: TEdit;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;
  count:integer;
implementation
uses unit2;
{$R *.dfm}

procedure TForm1.BitBtn1Click(Sender: TObject);
var
  results:variant;
begin
  count:=count+1;{计数加1}
  results:=table1.Lookup('用户名',edit1.text,'口令');{检索数据库中对应用户名的密码项}
  if results=edit2.Text then
    begin
    showmessage('密码确认，即将进入库存管理系统。');
    form2.Show ;
    form1.Hide ;
    end
  else
  begin
    showmessage('错误的用户名或密码！');{密码不确认}
    edit1.Text :='';
    edit2.Text :='';
    edit1.SetFocus ;
    if (count=3) then
      close;{三次输入错误，退出}
end;
end;
procedure TForm1.BitBtn2Click(Sender: TObject);
begin
close;
end;

procedure TForm1.FormCreate(Sender: TObject);
begin
table1.Open ;
end;

end.