delphi NetHttpClient1 数据库查询
1）使用INDY 的HTTP控件进行查询：
procedure TForm1.查询1Click(Sender: TObject);
begin
var url: TynUrl := TynUrl.Create;
var serial: TynSerial := TynSerial.Create;
var send: TMemoryStream := TMemoryStream.Create;
try
url.url := 'http://127.0.0.1:5566';
url.command := 'query8';
url.params.Add('accountno=1');
url.params.Add('sql=select * from tunit');
serial.Text := IdHttpClient1.Post(url.text, send);
serial.ReadFDDataSet('dataset', FDMemTable1);
finally
serial.Free;
send.Free;
url.Free;
end;
end;
2）使用DELPHI10.2新增的TNetHttpClient控件进行查询：
procedure TForm1.查询2Click(Sender: TObject);
begin
var url: TynUrl := TynUrl.Create;
var serial: TynSerial := TynSerial.Create;
var send: TMemoryStream := TMemoryStream.Create;
try
url.url := 'http://127.0.0.1:5566';
url.command := 'query8';
url.params.Add('accountno=1');
url.params.Add('sql=select * from tunit');
serial.Text := NetHttpClient1.Post(url.text, send).ContentAsString;
serial.ReadFDDataSet('dataset', FDMemTable1);
finally
serial.Free;
send.Free;
url.Free;
end;
end;
推荐分享
图文皆来源于网络，内容仅做公益性分享，版权归原作者所有，如有侵权请告知删除！
Copyright © 2014 DelphiW.com 开发 源码 文档 技巧 All Rights Reserved
晋ICP备14006235号-8 晋公网安备 14108102000087号
执行时间: 0.035249948501587 seconds