java.lang.NullPointerException探讨
strSQL="select * FROM data where ";
if(!tousu_start_date1.trim().equals("") && !tousu_end_date1.trim().equals(""))
strSQL=strSQL+" tousu_date between #"+tousu_start_date1+"# and #"+tousu_end_date1+"# order by tousu_date desc";
if(!tousu_class1.trim().equals("") )
strSQL=strSQL+" and tousu_class like '%"+tousu_class1+"%' ";
if(!depart1.trim().equals("") )
strSQL=strSQL+" and depart = '"+depart1+"' ";
if(!handle1.trim().equals("") )
strSQL=strSQL+" and handle = '"+handle1+"' ";
if(!details1.trim().equals("") )
strSQL=strSQL+" and details like '%"+details1+"%' ";
if(!person1.trim().equals("") )
strSQL=strSQL+" and person = '"+person1+"' ";
我做了个查询怎么有时候报如下错误:如果把if条件语句换个顺序,在输入不通类别时它报同样下面的错
java.lang.NullPointerException
at _0002fsql_0005fok_0002ejspsql_0005fok_jsp_57._jspService(_0002fsql_0005fok_0002ejspsql_0005fok_jsp_57.java:210)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:184)