Question

写查询SQL的工具类,不管输入什么SQL,都能显示出查询结果.应该怎么做.编程语言是Java

谢谢大家

Answer 1

var
sql:string;
begin
sql :=select dfxx.zhh as 总户号,jbxx.dh as 段号,dfxx.nf as 年份,dfxx.yf as 月份,dfxx.je as 金额,dfxx.znj as 滞纳金,dfxx.je+dfxx.znj as 合计,dfxx.sfqf as 是否欠费,jbxx.hm as 户名 from dfxx,jbxx where (jbxx.dh=:edit1.text) and xx.zhh=jbxx.zhh ';
if combobox1.text <> '' then
sql := sql + ' and jbxx.sffs=:combobox1.text';
if combobox2.text <> '' then
sql := sql + ' and dfxx.nf=:combobox2.text';
if combobox3.text <> '' then
sql := sql + ' and dfxx.yf=:combobox3.text';
adoquery.sql.text := sql;
adoquery.open;

end;