unit5.pas

利用数据库后SQL台操作的

unit Unit5;

interface

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

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

var
  Form5: TForm5;

implementation

uses Unit3;

{$R *.dfm}

procedure TForm5.Button1Click(Sender: TObject);
begin
if edit2.text<>edit3.Text then
showmessage('两次输入密码不一致,请检验')
else
with query1 do
begin
close;
sql.Clear;
sql.Add('update login set password='''+trim(edit3.text)+''',quanxian='''+trim(combobox1.text)+'''where name='''+trim(edit1.Text)+'''');
execsql;
showmessage('修改成功');
form3.adoquery1.active:=false;
form3.adoquery1.Active:=true;
end;
end;
procedure TForm5.Button2Click(Sender: TObject);
begin
close;
end;
end.