u_frmchange.pas

sqllite3数据库基本应用(打开,关闭表,及更新数据表)

unit u_frmchange;

interface

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

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

var
  Frmchange: TFrmchange;

implementation

uses u_data, u_frmlogin;

{$R *.dfm}

procedure TFrmchange.Button1Click(Sender: TObject);
begin
with  data.Quser do
begin
close;
sql.Clear;
sql.Add('select * from department');
open;
end;
if not data.Quser.Locate('departmentpwd',edit1.Text,[]) then
begin
application.MessageBox('原始密码不正确，请重新输入','提示',0+64);
edit1.SetFocus;
end
else
if trim(edit2.Text)='' then
begin
application.MessageBox('密码不能为空!','提示',0+64);
edit2.SetFocus;
end
else
begin
data.Quser.Close;
data.Quser.SQL.Clear;
data.Quser.SQL.Add('update department set departmentpwd='''+edit2.Text+'''');
data.Quser.SQL.Add('where departmentname='''+frmlogin.ComboBoxname.Text+'''');
data.Quser.ExecSQL;

application.MessageBox('密码更改成功','提示',0+64);
end;
end;

procedure TFrmchange.Button2Click(Sender: TObject);
begin
close;
end;

end.