赞
踩
SELECT TOP 20 lzzt=dbo.getlzzt(lzzt,p2),* FROM zcrkd WHERE ( (scdjbz='0' or scdjbz='1' or scdjbz='2') and rkdlx=0 and zclablelbbm like '%' and bmbm like '%' and zclbbm like '%' and isnull(zcmc,'') like '%%' and zclabel like '%' and (isnull(ty_lyr,'') like '%%') and (rksj <= getdate() AND (rksj >= '1900-01-01')) and isnull(zcxh,'') like '%%' and 1 = 1 and isnull(p3,'') like '%%' and isnull(p1,'') like '%%' and isnull(bz,'') like '%%' and isnull(newp1,'') like '%%' and jsfs='1' ) AND zcbh NOT IN(SELECT TOP 0 zcbh FROM zcrkd WHERE ( (scdjbz='0' or scdjbz='1' or scdjbz='2') and rkdlx=0 and zclablelbbm like '%' and bmbm like '%' and zclbbm like '%' and isnull(zcmc,'') like '%%' and zclabel like '%' and (isnull(ty_lyr,'') like '%%') and (rksj <= getdate() AND (rksj >= '1900-01-01')) and isnull(zcxh,'') like '%%' and 1 = 1 and isnull(p3,'') like '%%' and isnull(p1,'') like '%%' and isnull(bz,'') like '%%' and isnull(newp1,'') like '%%' and jsfs='1' ) ORDER BY zcmc ASC,zclabel) ORDER BY zcmc ASC,zclabel
select cnt=sum(zcsl),sum(dwje*zcsl) from zcrkd where ( (scdjbz='0' or scdjbz='1' or scdjbz='2') and rkdlx=0 and zclablelbbm like '%' and bmbm like '%' and zclbbm like '%' and isnull(zcmc,'') like '%%' and zclabel like '%' and (isnull(ty_lyr,'') like '%%') and (rksj <= getdate() AND (rksj >= '1900-01-01')) and isnull(zcxh,'') like '%%' and 1 = 1 and isnull(p3,'') like '%%' and isnull(p1,'') like '%%' and isnull(bz,'') like '%%' and isnull(newp1,'') like '%%' and jsfs='1' )
strSQL:select cnt=sum(zcsl),sum(dwje*zcsl) from zcrkd where ( (scdjbz='0' or scdjbz='1' or scdjbz='2') and rkdlx=0 and zclablelbbm like '%' and bmbm like '%' and zclbbm like '%' and isnull(zcmc,'') like '%%' and zclabel like '%' and (isnull(ty_lyr,'') like '%%') and (rksj <= getdate() AND (rksj >= '1900-01-01')) and isnull(zcxh,'') like '%%' and 1 = 1 and isnull(p3,'') like '%%' and isnull(p1,'') like '%%' and isnull(bz,'') like '%%' and isnull(newp1,'') like '%%' and jsfs='1' )
ERROR - Dispatch[/extdata] to method lzzt returned an exception
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at com.gam.util.Dis2008.execute(Dis2008.java:57)
at org.apache.struts.act
at org.apache.struts.act
at org.apache.struts.act
at org.apache.struts.act
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationFil
at com.gam.util.SetCharacterEncodingFil
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineV
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NoClassDefFoundError: org/apache/commons/collections/map/MultiKeyMap
at net.sf.json.JsonConfig.<init>(JsonConfig.java:65)
at net.sf.json.JSONObject.fromObject(JSONObject.java:149)
at com.ext.util.JSON.toJSON(JSON.java:27)
at com.ext.util.JSON.B2J(JSON.java:370)
at com.ext.dao.DaoData.getLzzt(DaoData.java:315)
at com.ext.act
... 28 more
Caused by: java.lang.ClassNotFoundException: org.apache.commons.collections.map.MultiKeyMap
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
... 34 more
JSON-sql:SELECT TOP 20 lzzt=dbo.getlzzt(lzzt,p2),* FROM zcrkd WHERE ( (scdjbz='0' or scdjbz='1' or scdjbz='2') and rkdlx=0 and zclablelbbm like '%' and bmbm like '%' and zclbbm like '%' and isnull(zcmc,'') like '%%' and zclabel like '%' and (isnull(ty_lyr,'') like '%%') and (rksj <= getdate() AND (rksj >= '1900-01-01')) and isnull(zcxh,'') like '%%' and 1 = 1 and isnull(p3,'') like '%%' and isnull(p1,'') like '%%' and isnull(bz,'') like '%%' and isnull(newp1,'') like '%%' and jsfs='1' ) AND zcbh NOT IN(SELECT TOP 0 zcbh FROM zcrkd WHERE ( (scdjbz='0' or scdjbz='1' or scdjbz='2') and rkdlx=0 and zclablelbbm like '%' and bmbm like '%' and zclbbm like '%' and isnull(zcmc,'') like '%%' and zclabel like '%' and (isnull(ty_lyr,'') like '%%') and (rksj <= getdate() AND (rksj >= '1900-01-01')) and isnull(zcxh,'') like '%%' and 1 = 1 and isnull(p3,'') like '%%' and isnull(p1,'') like '%%' and isnull(bz,'') like '%%' and isnull(newp1,'') like '%%' and jsfs='1' ) ORDER BY zcmc ASC,zclabel) ORDER BY zcmc ASC,zclabel
ERROR - Dispatch[/extdata] to method xcyslyd returned an exception
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at com.gam.util.Dis2008.execute(Dis2008.java:57)
at org.apache.struts.act
at org.apache.struts.act
at org.apache.struts.act
at org.apache.struts.act
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationFil
at com.gam.util.SetCharacterEncodingFil
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineV
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NoClassDefFoundError: org/apache/commons/collections/map/MultiKeyMap
at net.sf.json.JsonConfig.<init>(JsonConfig.java:65)
at net.sf.json.JSONObject.fromObject(JSONObject.java:149)
at com.ext.util.JSON.toJSON(JSON.java:27)
at com.ext.util.JSON.B2J(JSON.java:370)
at com.ext.dao.DaoData.getXcyslyd_rkd(DaoData.java:511)
at com.ext.act
... 28 more
2009-7-10 17:53:16 org.apache.catalina.core.ApplicationDispatcher invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at org.apache.jsp.jsp.error._500_jsp._jspService(_500_jsp.java:75)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:447)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:424)
at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:144)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineV
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
2009-7-10 17:53:16 org.apache.catalina.core.StandardHostValve custom
严重: Exception Processing ErrorPage[errorCode=500, location=/jsp/error/500.jsp]
org.apache.jasper.JasperException: An exception occurred processing JSP page /jsp/error/500.jsp at line 11
8: <%
9: java.io.ByteArrayOutputStream osbyte = new java.io.ByteArrayOutputStream();
10: java.io.PrintStream ps = new java.io.PrintStream(osbyte);
11: exception.printStackTrace(ps);
12: String stack = osbyte.toString();
13: if(ps!=null) ps.close();
14: if(osbyte!=null) osbyte.close();
Stacktrace:
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:447)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:424)
at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:144)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineV
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
at org.apache.jsp.jsp.error._500_jsp._jspService(_500_jsp.java:75)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
... 19 more
2009-7-10 17:53:16 org.apache.catalina.core.ApplicationDispatcher invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at org.apache.jsp.jsp.error._500_jsp._jspService(_500_jsp.java:75)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:447)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:424)
at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:144)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineV
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
2009-7-10 17:53:16 org.apache.catalina.core.StandardHostValve custom
严重: Exception Processing ErrorPage[errorCode=500, location=/jsp/error/500.jsp]
org.apache.jasper.JasperException: An exception occurred processing JSP page /jsp/error/500.jsp at line 11
8: <%
9: java.io.ByteArrayOutputStream osbyte = new java.io.ByteArrayOutputStream();
10: java.io.PrintStream ps = new java.io.PrintStream(osbyte);
11: exception.printStackTrace(ps);
12: String stack = osbyte.toString();
13: if(ps!=null) ps.close();
14: if(osbyte!=null) osbyte.close();
Stacktrace:
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationFil
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:447)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:424)
at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:144)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineV
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
at org.apache.jsp.jsp.error._500_jsp._jspService(_500_jsp.java:75)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
... 19 more
解决方案:下一个commons-collections-3.1.jar 我的126邮箱有下载
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。