初学者！寻精确查询代码？

Question

  Query1.Close;
  Query1.Text = Format(
'SELECT *'#13#10 +
'FROM 表1'#13#10 +
'WHERE 姓名=%s'#13#10,
    [QuotedStr(Edit1.Text)]);
  Query1.Open;

Answer 1

Query1.Close;
Query1.sql.add('select * from tablename where fieldname=:p1');
Query1.parambyname('fieldname').assting:=strim(edit.text);
Query1.openthat's ok.

Answer 2

Query1.sql.add('select * from tablename where fieldname=:p1');
Query1.parambyname('fieldname').assting:=strim(edit.text);

Answer 3

Query1.sql.add('select * from tablename where fieldname='''+Edit1.text+'''');

Answer 4

with Query1 do
 begin
   Close;
   Sql.Clear;
   Sql.Add('select * from Tablename');
   Sql.add('where fieldname='''+Edit1.Text+'''');
   Open;
 end;

Answer 5

Query1.close;
Query1.sql.clear;
Query1.sql.add('select * from tablename where fieldname='''+Edit1.text+'''');
Query1.open;