unit Unit4;

interface

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

type
  TForm4 = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Button1: TButton;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Button2: TButton;
    Image1: TImage;
    Button3: TButton;
    Label5: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form4: TForm4;
  str0,str00:string;

implementation
      uses unit1;
{$R *.dfm}

procedure TForm4.Button2Click(Sender: TObject);
var
   str:string;
begin
   str:='select Staff#,pwd from Staff where Staff#='+quotedstr(unit1.str0);
   adoquery1.Close;
   adoquery1.SQL.Clear ;
   adoquery1.SQL.Add(str);
   adoquery1.Open ;
end;

procedure TForm4.Button1Click(Sender: TObject);
 var
    str:string;
  
begin
if   (edit4.Text <>edit5.Text)      then
   showmessage('修改失敗！')
   else
   begin
   str:='update Staff set  pwd='+quotedstr(edit4.Text);
   str:=str+'where Staff#='+quotedstr(edit1.Text)+'and pwd='+quotedstr(edit2.Text);
   adoquery1.Close;
   adoquery1.SQL.Clear ;
   adoquery1.SQL.Add(str);
   adoquery1.ExecSQL ;
   showmessage('修改成功！')
   end
  
end;

procedure TForm4.Button3Click(Sender: TObject);
begin
   form4.Close ;
end;

end.