adoquery模糊参数查询问题（在线等待）(10分)

P

patriot

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #1

用adoquery查询数据库，edit1.text的文本作为条件如下

with adoQuery1 do
begin
Close;
Sql.Clear;
SQL.Add('select * from cipher where cus_serial='''+edit1.text+'''');
open;
end;

若把edit1.text的文本作为模糊查询条件怎么改？

 

D

dlnew

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #2

//以edit1.text的文本作为开始的substring
....
....where cus_serial like ''' + edit1.text + '%''');
....

 

汪

汪向阳

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #3

可以格式化字符串
var
sqlstr: string;

with adoQuery1 do
begin
Close;
SQL.Clear;
sqlstr := 'select * from cipher where cus_serial = %s';
SQL.Add(Format(sqlstr,[edit1.text]);
Open;
end;

 

P

patriot

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #4

下面条件查询，怎么改，最好前后都加%，谢谢
SQL.Add('select * from cipher where cus_serial='''+edit1.text+''' or cus_key='''+edit2.text+'''');

 

J

jsxjd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #5

SQL.Add('select * from cipher where '+edit1.text);
=========
在 edit1 中录入完整的条件。

 

N

niceboy911

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #6

with adoQuery1 do
begin
Close;
Sql.Clear;
SQL.Add('select * from cipher where cus_serial=''%'+edit1.text+'%''');
open;
end;

 

汪

汪向阳

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-25

• #7

可以使用参数呀
with adoquery1 do begin
Close;
SQL.clear;
SQL.add('select * from cipher where cus_serial = :a or cus_key = :b');
Parameters.Parambyname('a').value := edit1.text;
parameters.parambyname('b').value := edit2.text;
Open;
end;

 

P

patriot

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-26

• #8

接受答案了.