错误是在这一段代码~,谁帮我看下,看看是哪里出错?connDB conn=new connDB();
String sql="";
if(request.getParameter("Oaddress")==null||request.getParameter("Oaddress")==null||(request.getParameter("Oaddress")==""||request.getParameter("Oaddress")==""){ sql="select t.Tname,t.Taddress,o.Oaddress,t.Tkind,count(t.Tprice*oi.Onumber) as salemoney from tea t,orders o,order_item oi where oi.Oid=o.Oid and oi.Tid=t.Tid";}
else{String s="select t.Tname,t.Taddress,o.Oaddress,t.Tkind,count(t.Tprice*oi.Onumber) as salemoney from tea t,orders o,order_item oi where oi.Oid=o.Oid and oi.Tid=t.Tid and ";
String Taddress=new String(request.getParameter("Taddress").toString().getBytes("ISO-8859-1"),"GB2312");
String Oaddress=new String(request.getParameter("Oaddress").toString().getBytes("ISO-8859-1"),"GB2312");
String Tkind=request.getParameter("Tkind");
String and=" and ";
sql=s+and+Taddress+and+Oaddress+and+Tkind;}
out.print(sql);TOMCAT报错信息:org.apache.jasper.JasperException: 无法编译JSP
An error occurred at line: 142 in the jsp file: /admi/xiaoshoutj.jsp
Generated servlet error:
Syntax error on token ")", ) expected after this token
String sql="";
if(request.getParameter("Oaddress")==null||request.getParameter("Oaddress")==null||(request.getParameter("Oaddress")==""||request.getParameter("Oaddress")==""){ sql="select t.Tname,t.Taddress,o.Oaddress,t.Tkind,count(t.Tprice*oi.Onumber) as salemoney from tea t,orders o,order_item oi where oi.Oid=o.Oid and oi.Tid=t.Tid";}
else{String s="select t.Tname,t.Taddress,o.Oaddress,t.Tkind,count(t.Tprice*oi.Onumber) as salemoney from tea t,orders o,order_item oi where oi.Oid=o.Oid and oi.Tid=t.Tid and ";
String Taddress=new String(request.getParameter("Taddress").toString().getBytes("ISO-8859-1"),"GB2312");
String Oaddress=new String(request.getParameter("Oaddress").toString().getBytes("ISO-8859-1"),"GB2312");
String Tkind=request.getParameter("Tkind");
String and=" and ";
sql=s+and+Taddress+and+Oaddress+and+Tkind;}
out.print(sql);TOMCAT报错信息:org.apache.jasper.JasperException: 无法编译JSP
An error occurred at line: 142 in the jsp file: /admi/xiaoshoutj.jsp
Generated servlet error:
Syntax error on token ")", ) expected after this token
Syntax error on token ")", ) expected after this token
if(request.getParameter("Oaddress")==null||request.getParameter("Oaddress")==null||(request.getParameter("Oaddress")==""||request.getParameter("Oaddress")==""){
这个if 有错
在后边多加一个)if(request.getParameter("Oaddress")==null||request.getParameter("Oaddress")==null||(request.getParameter("Oaddress")==""||request.getParameter("Oaddress")=="") ) {
request.getParameter("Oaddress")经常用到,先把它读到变量里,然后直接使用变量,这样的话就清析很多了