modimm.pas

欢迎大家相互学习。delphi系统 四个文件夹分别对应书中的四个实例

unit ModiMM;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Borland.Vcl.StdCtrls, System.ComponentModel, DB, DBTables;

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

var
  ModiMMForm: TModiMMForm;

implementation

uses main;

{$R *.nfm}

procedure TModiMMForm.Button1Click(Sender: TObject);
var yhm,oldpass,newpass,qrpass,sqlstr:string;
begin
  yhm:=trim(main_form.dlname);
  oldpass:=trim(edit1.text);
  newpass:=trim(edit2.text);
  if length(newpass)<3 then
  begin
    showmessage('密码由3-20个字符组成！');
    exit;
  end;
  qrpass:=trim(edit3.text);
  if length(qrpass)<3 then
  begin
    showmessage('密码由3-20个字符组成！');
    exit;
  end;
  if newpass<>qrpass then
  begin
    showmessage('确认密码不相同，请确认！');
    exit;
  end;
  sqlstr:='select * from [user] where (yhm='''+yhm+''') and (mm='''+oldpass+''')';
  with tquery.Create(nil) do
  begin
    try
    close;
    SessionName:=main_form.Database1.SessionName;
    DatabaseName:=main_form.Database1.DatabaseName;
    SQL.clear;
    SQL.Add(sqlstr);
    Open;
    if recordCount<1 then
    begin
      showmessage('原密码错误，你不能修改--'+yhm+'--用户的密码！');
      exit;
    end;
    sqlstr:='update [user] set mm='''+newpass+''' where (yhm='''+yhm+''')';
    SQL.Clear;
    SQL.Add(sqlstr);
    ExecSQL;
    finally
    Free;
    end;
  end;
  showmessage('密码修改成功！');
  Close;
end;

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

procedure TModiMMForm.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Close;
  main_form.N12.Enabled:=True;
end;

end.