unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Button1: TButton;
    Button2: TButton;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    ADOTable1: TADOTable;
    DataSource1: TDataSource;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

uses Unit2;

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
var u,p :string;
begin
   u:=edit1.Text ;
   p:=edit2.Text ;
   Adoquery1.Close ;
   ADOQuery1.SQL.Clear ;
   ADOQuery1.SQL.Add('select usname,uspwd from pwd where usname='+''''+u+''''+'and uspwd='+''''+p+'''');
   ADOQuery1.Open ;
   if ADOQuery1.RecordCount=0 then
   begin
     Application.MessageBox('密碼錯誤，請重新輸入','提示');
     edit1.SetFocus;
   end else
      begin
          main.show();
          form1.Hide;
          edit2.Text:='';
end;

end;
procedure TForm1.Button2Click(Sender: TObject);
begin
 Close;
end;

end.