Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 结果集没有当前行。

本是古典何须时尚 2024-02-19 13:49 10阅读 0赞

### 十一月 27, 2018 8:59:31 下午 org.apache.catalina.core.StandardWrapperValve invoke   严重: Servlet.service() for servlet \[ShoppingServlet\] in context with path \[/JavaWebProgram\] threw exception   java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: 结果集没有当前行。   at cn.itcast.Servlet.com.ShoppingServlet.doGet(ShoppingServlet.java:23)   at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)   at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)   at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)   at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)   at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)   at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)   at org.apache.coyote.AbstractProtocol C o n n e c t i o n H a n d l e r . p r o c e s s ( A b s t r a c t P r o t o c o l . j a v a : 806 ) a t o r g . a p a c h e . t o m c a t . u t i l . n e t . N i o E n d p o i n t ConnectionHandler.process(AbstractProtocol.java:806) at org.apache.tomcat.util.net.NioEndpoint ConnectionHandler.process(AbstractProtocol.java:806)atorg.apache.tomcat.util.net.NioEndpointSocketProcessor.doRun(NioEndpoint.java:1498)   at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)   at java.util.concurrent.ThreadPoolExecutor W o r k e r . r u n ( U n k n o w n S o u r c e ) 加 粗 样 式 a t o r g . a p a c h e . t o m c a t . u t i l . t h r e a d s . T a s k T h r e a d Worker.run(Unknown Source)加粗样式 at org.apache.tomcat.util.threads.TaskThread Worker.run(UnknownSource)加粗样式atorg.apache.tomcat.util.threads.TaskThreadWrappingRunnable.run(TaskThread.java:61)   at java.lang.Thread.run(Unknown Source)   ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NOQ0RYWF84OA_size_16_color_FFFFFF_t_70]   原因:结果集rs的位置初始时位于第一条记录的前面，即为0。所以当用if来判断时，会出现结果集当前行为空。   这是ResultSet指向的问题，ResultSet取值后，指针默认指向index为-1的前一个元素,   即ResultSet中第一个元素的前面，这时指针默认指向是不存在元素的，因此出现错误。必须调用.next()函数才能，对ResultSet进行遍历。 ###

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NOQ0RYWF84OA_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/9838748ca10549898eafad0ba8cdaac7.png
[https_blog.csdn.net_luoxia0805_article_details_41957631]: https://blog.csdn.net/luoxia0805/article/details/41957631