2,497
社区成员
发帖
与我相关
我的任务
分享
with FormLogin.ADOQuery1 do
begin
close;
sql.Clear;
sql.Add('select * from b1 where username=:username and password=:password');
Parameters[0].Value := trim(EditUsr.Text);
Parameters[1].Value := trim(EditPwd.Text);
open;
if isempty then
begin
showmessage('请核对您的用户名和密码信息!');
end
else
begin
close;
sql.Clear;
sqlstr:='update b1 set [password] ='''+trim(EditSPwd.Text)+'''where [username] ='''+trim(EditUsr.Text)+'''';
sql.Text:=sqlstr;
ExecSql;
ShowMessage('密码修改成功!');
end;
end;