query1.close; query1.sql.clear; query1.sql.add('select * from 表 where 列 like "%电脑%"'); query1.execute;
query1.close; query1.sql.clear; query1.sql.add('select * from table1 where 名称 like "%电脑%"'); query1.open;
他们讲的都对,但是是一个死的查询,要是想作成个动态的就要象下面这样写: query1.close; query1.sql.clear; query1.sql.add('select * from 表名 where name=:num'); query1.parambyname('num').asstring:=Edit1.text; query1.prepare; query1.open; 在EDIT1中输入要查询的内容就可以了
query1.close; query1.sql.clear; query1.sql.add('select * from table1 where 名称 like =:num'); query1.parambyname('num').asstring:='%'+trim(Edit1.text)+'%'; query1.open;
query1.sql.clear;
query1.sql.add('select * from 表 where 列 like "%电脑%"');
query1.execute;
query1.sql.clear;
query1.sql.add('select * from table1 where 名称 like "%电脑%"');
query1.open;
query1.close;
query1.sql.clear;
query1.sql.add('select * from 表名 where name=:num');
query1.parambyname('num').asstring:=Edit1.text;
query1.prepare;
query1.open;
在EDIT1中输入要查询的内容就可以了
query1.sql.clear;
query1.sql.add('select * from table1 where 名称 like =:num');
query1.parambyname('num').asstring:='%'+trim(Edit1.text)+'%';
query1.open;