unit3.pas

材料管理系统

unit Unit3;

interface

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

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

var
  frmChangePassword: TfrmChangePassword;

implementation
uses Unit2;
{$R *.dfm}

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

procedure TfrmChangePassword.Button1Click(Sender: TObject);
var
  Query1:TADOQuery;
begin
  if Trim(Edit1.Text) = '' then
  begin
    Application.MessageBox('新用户名不能为空!','提示',MB_OK OR MB_ICONINFORMATION);
    EXIT;
  end;
  if CompareStr(Trim(Edit2.Text),Trim(Edit3.Text)) <> 0 then
  begin
    Application.MessageBox('两次密码不一致.','错误',MB_OK OR MB_ICONERROR);
    Edit2.Clear;
    Edit3.Clear;
    exit;
  end;
  try
  begin
    Query1 := TADOQuery.Create(nil);
    Query1.ConnectionString := Frmmain.ADOConnection1.ConnectionString;
    with Query1 do
    begin
      close;
      sql.Clear;
      sql.Add('update CKuser set Username='''+trim(Edit1.Text)+''',Password='''+
        Trim(Edit2.Text)+'''where SuperRight=1');
      execSQL;
    end;
    FreeAndNil(Query1);
    ShowMessage('修改成功.');
    Self.Close;
  end;
  except
    Application.MessageBox('系统出错!','INFORMATION',MB_OK OR MB_ICONINFORMATION);
  end;

end;

end.