急救：jsp多条件复合查询的问题！

[mengxin123]

请各位高手帮我看一下这个错误，最好能帮我写一下查询的代码，小弟多谢了！
以下是查询页面的代码段：

String fgs = request.getParameter("fgs");
String yddd = request.getParameter("yddd");
String ydlx = request.getParameter("ydlx");
//这三个变量是我要查询的条件，全部为空或者全部有值等等的任意组合查询


String strsql = "select * from dfbzb where 1=1";
if(!fgs.equals(""))
strsql = strsql+" and fgs like '%"+fgs+"%'";
if(!yddd.equals(""))
strsql = strsql+ " and yddd like '%"+yddd+"%'";
if(!ydlx.equals(""))
strsql = strsql+ " and ydlx like '%"+ydlx+"%'";
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
Connection con = java.sql.DriverManager.getConnection("jdbc:jtds:sqlserver://134.206.9.7:1433/dfbz", "sa", "glxtsjk");
Statement stmt = con.createStatement();
ResultSet rst = ExecuteWay.exeSqlQuery("strsql");


while (rst.next()) {
out.println("<tr>");
out.println("<td>" + rst.getString("fgs") + "</td>");
out.println("<td>" + rst.getString("yddd") + "</td>");
out.println("<td>" + rst.getString("ydlx") + "</td>");
out.println("<td>" + rst.getString("fprq") + "</td>");
out.println("<td>" + rst.getString("scdbrq") + "</td>");
out.println("<td>" + rst.getString("bcdbrq") + "</td>");
out.println("<td>" + rst.getString("syds") + "</td>");
out.println("<td>" + rst.getString("byds") + "</td>");
out.println("<td>" + rst.getString("bl") + "</td>");
out.println("<td>" + rst.getString("dj") + "</td>");
out.println("<td>" + rst.getString("bs") + "</td>");
out.println("<td>" + rst.getString("dwf") + "</td>");
out.println("<td>" + rst.getString("zddbs") + "</td>");
out.println("<td>" + rst.getString("dds") + "</td>");
out.println("<td>" + rst.getString("bzts") + "</td>");
out.println("<td>" + rst.getString("mysjds") + "</td>");
out.println("<td>" + rst.getString("myhdds") + "</td>");
out.println("<td>" + rst.getString("df") + "</td>");
out.println("<td>" + rst.getString("bz") + "</td>");
out.println("<td>" + rst.getString("sblx") + "</td>");
out.println("<td>" + rst.getString("rl") + "</td>");
out.println("<td>" + rst.getString("sz") + "</td>");
out.println("<td>" + rst.getString("ktzgl") + "</td>");
out.println("<td>" + rst.getString("ktzps") + "</td>");
out.println("</tr>");
}
rst.close();
stmt.close();
con.close();
%>

[color=#FF0000]
以下是出现的错误：[/color]

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: java.lang.NullPointerException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:532)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:426)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause

java.lang.NullPointerException
org.apache.jsp.result1_jsp._jspService(result1_jsp.java:180)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


note The full stack trace of the root cause is available in the Apache Tomcat/6.0.10 logs.


--------------------------------------------------------------------------------

[Shine_Panda]

ResultSet rst = ExecuteWay.exeSqlQuery("strsql");
去掉 ""
ResultSet rst = ExecuteWay.exeSqlQuery(strsql);
试下.

[mengxin123]

改了虽然不出错
但是查询结果什么都没有
帮看一下我的条件查询语句错在哪里？

[老紫竹]

重复问题，看另一个的回复。

你的SQL肯定有问题啦? 或者.... 你的数据确实没有满足条件的！

[zhj92lxs]

把你的sql语句打印出来，放在查询分析器里看看