delphi FDQuery1 Update 更新数据

FDQuery1.Close;

FDQuery1.SQL.Clear;

FDQuery1.SQL.Text:='Update user SET userjf=:userjf where username=:username';

FDQuery1.ParamByName('username').Value:=trim(UserName);

FDQuery1.ParamByName('userjf').Value:=trim('30000');

FDQuery1.ExecSQL;

方法：2

FDConnection1.ExecSQL('UPDATE user SET userjf=:a WHERE username=:b', [10000, UserName]);

FDQuery1.Refresh;