unit11.pas

学生学籍管理 delphi+sql2000 合力制作

unit Unit11;

interface

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

type
  TForm11 = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Button1: TButton;
    Button2: TButton;
    ADOQuery1: TADOQuery;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form11: TForm11;

implementation

{$R *.dfm}
 uses unit2;
procedure TForm11.Button1Click(Sender: TObject);
begin

   ADOQuery1.SQL.Clear;
   ADOQuery1.SQL.Add('select * from controller where 密码 =:pw');
   ADOQuery1.Parameters.ParamByName('pw').Value := edit1.Text;
   ADOQuery1.Open;
   if ADOQuery1.RecordCount = 0 then
    begin
      showmessage('你输入的旧密码不正确!');
      edit1.Clear;
      exit;
    end
    else if edit2.Text <> edit3.Text then
      begin
        showmessage('新密码两次输入不相符!') ;
        edit1.Clear;
        exit;
      end
        else
          begin
            ADOQuery1.SQL.Clear;
            ADOQuery1.SQL.Add('insert into controller values(:n5)');
            ADOQuery1.Parameters.ParamByName('n5').Value := edit2.text;
            ADOQuery1.Post;
            showmessage('密码已修改!');
          end;


end;

procedure TForm11.Button2Click(Sender: TObject);
begin
  self.Hide;
  Form2.show;
  self.close;
end;

end.