with SQL do
begin
SQL.clear;
SQL.Add(’UPDATE ADOQ_userlogin SET password =:newpass where serviceman=:username’);
end;
Parameters.ParamByName('username').Asstring:=name; //需要改动的就是这两句,此外,注意引号的全角和半角
Parameters.ParamByName('newpass').Asinteger:=pass;
open;
procedure TF_changepass.BT_changepassClick(Sender: TObject);
var
name:string;
pass:integer;
begin
name:= F_userlogin.DB_username.text;
pass:=strtoint(ED_newpass.text);
IF ED_newpass.text=ED_confirm.text then
begin
with F_userlogin.ADOQ_userlogin do
with SQL do
begin
SQL.clear;
SQL.Add(’UPDATE ADOQ_userlogin SET password =:newpass where serviceman=:username’);
end;
paramByName(’username’).Asstring:=name;
ParamByName(’newpass’).Asinteger:=pass;
open;
end
else showmessage(’两次密码输入不一致,请重新输入’);
end;
var lcname:shortstring;
begin
lcname:='计划';
adoquery2.sql.Add('select userid from users where username=:lcname');
adoquery2.paramet(0).value:='计划' //这个单词忘了怎么写的。
adoquery2.Active:=true;
end;