Java开发网 - 500 Servlet Exception

Topic: 500 Servlet Exception

1.500 Servlet Exception

Posted by: sdlwhb
Posted on: 2006-05-07 18:25

java.sql.SQLException: Illegal operation on empty result set
  at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:3617)
  at com.mysql.jdbc.ResultSet.getString(ResultSet.java:1772)
  at com.mysql.jdbc.ResultSet.getString(ResultSet.java:1837)
  at _reg._login__jsp._jspService(/reg/info/grade.jsp:54)
  at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
  at com.caucho.jsp.Page.subservice(Page.java:506)
  at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
  at com.caucho.server.http.Invocation.service(Invocation.java:315)
  at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
  at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:346)
  at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
  at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
  at java.lang.Thread.run(Thread.java:534)

------------------------------------------------------------------------------------------------
能不能看出是哪里的错误？

2.Re:500 Servlet Exception [Re: sdlwhb]	Copy to clipboard
Posted by: sunjavaduke Posted on: 2006-05-07 18:44 Illegal operation on empty result set 这不是写得很清楚吗应该是你的结果集对象（ResultSet）是没有任何结果的也就是说 stmt.excuteQuery(sql);方法返回了一个空的结果集，那么你对这个对象进行操作的话，当然是非法的了

3.Re:500 Servlet Exception [Re: sdlwhb]	Copy to clipboard
Posted by: sdlwhb Posted on: 2006-05-07 20:31 rs=stmt.executeQuery("SELECT * from users where username ='"+username+"'"); 看来问题就在这了，谢谢你哦，不过怎么改呢？

4.Re:500 Servlet Exception [Re: sdlwhb]	Copy to clipboard
Posted by: sdlwhb Posted on: 2006-05-07 20:32 users 里面有值的啊

5.Re:500 Servlet Exception [Re: sdlwhb]	Copy to clipboard
Posted by: wbfeixue Posted on: 2006-05-10 13:08 看看数据库吧,你的名称对不对??? 输入的username对不对???

6.Re:500 Servlet Exception [Re: sdlwhb]	Copy to clipboard
Posted by: wbfeixue Posted on: 2006-05-10 13:09 我最近也做了一个类似的中间也出现了这个问题页面提交的信息有问题

7.Re:500 Servlet Exception [Re: sdlwhb]	Copy to clipboard
Posted by: damondeng Posted on: 2006-05-10 14:35 可以考虑将你的查询语句System.out.println出来, 确认这个语句能查到东西, 最好print来出后拷贝到数据库客户端上手工试一下. 如果手工是对的, 程序查就不对的话, 给数据库厂商报个bug吧, 说不定人家重谢你, 呵呵