rs.next()中的SQLException
这错就是它为什么读不出来那个传参的数据 还有,还有个错 就是从这开始报错 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current
cursor position. ?at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) ?at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) ?at com.microsoft.jdbc.base.BaseResultSet.validateCursorPosition(Unknown Source) ?at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source) ?at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source) ?at org.apache.jsp.userEdit_jsp._jspService(userEdit_jsp.java:64) ?at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) ?at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311) ?at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) ?at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) ?at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:284) ?at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) ?at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) ?at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) ?at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) ?at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245) ?at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199) ?at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) ?at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) ?at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195) ?at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) ?at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) ?at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) ?at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) ?at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) ?at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) ?at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) ?at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) ?at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:211) ?at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:805) ?at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(Http11Protocol.java:696) ?at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605) ?at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677) ?at java.lang.Thread.run(Thread.java:619)
?
这一行就这一句话 这是按照一半方法实现的 用存储过程也是一样这个错 很郁闷 数据库也没什么可改的了 就这了 那天问你又不知道怎么改啊
?
注意: 错误解决: 缺少rs.next();语句,原因:在调用到rs的记录集的时间,指针的指向还是空(null)的,所以,要向下移动一行,从
而获得数据下次请注意!
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|