- 人气:
- 放大
- 缩小
- 二维码
- 赞赏
delphi 数据库获取所有用户名
function Tform1.GetAllUser: TStringList;
begin
Result := TStringList.Create;
Result.Clear;
with TADOQuery.Create(nil) do
try
Connection := FdbJbda;
Close;
SQL.Clear;
SQL.Add('select name from data');
Open;
while not Eof do
begin
Result.Add(Format('%s', [Fields[0].AsString]));
Next;
end;
Close;
finally
Free;
end;
end;