unit Unit4;

interface

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

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

var
  Form4: TForm4;

implementation
    uses unit5;
{$R *.dfm}

procedure TForm4.Button1Click(Sender: TObject);
var  bb:string;
begin
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from account where account_number=:num');
adoquery1.Parameters[0].Value:=edit1.Text;
adoquery1.Open;
bb:=adoquery1.fieldbyname('pasword').AsString;
if strtoint(edit2.Text)=strtoint(bb)
  then
  begin
   form5.show;
  //close;
   end
  else
  ShowMessage('卡號或密碼錯誤！');
end;

procedure TForm4.Button2Click(Sender: TObject);
begin
close;
end;

end.