unit5.pas

这是一个关于delphi数据库方面的源程序

unit Unit5;

interface

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

type
  TFormChPwd = class(TForm)
    Label2: TLabel;
    Label3: TLabel;
    Button1: TButton;
    Edit2: TEdit;
    Edit1: TEdit;
    Query1: TQuery;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    User: string;
  end;

var
  FormChPwd: TFormChPwd;

implementation

{$R *.dfm}

procedure TFormChPwd.Button1Click(Sender: TObject);
begin
  if Edit1.Text <> Edit2.Text then
  begin
    ShowMessage('两个密码不相同');
    Exit;
  end
  else
  begin
    Query1.SQL.Text := 'Update 密码.db set 密码="' + Edit1.Text
                        + '" where 学号="'+ User +'"';
    Query1.ExecSQL;
    Query1.Close;
    ShowMessage('修改成功!');
    Edit1.Text :='';
    Edit2.Text :='';
    FormChPwd.Close;
  end;
end;

end.