在线等待，各位兄弟帮帮忙，特别急的事情！

[zflfaufa]

做了一个jsp网站，运行了几天好好的，突然报如下错误：
快帮帮我！！！！！！！！！！！！！！！！！！！
org.apache.jasper.JasperException: Before start of result set
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:536)

[zflfaufa]

org.apache.jasper.JasperException: Before start of result set 是什么问题，交交我

[香芋元宇宙]

把代码发上来，我给你看看

[香芋元宇宙]

ResultSet rs=null;

取得rs结果集后，是否应增加一句：rs.next()

[zflfaufa]

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection conn= DriverManager.getConnection("jdbc:mysql://127.0.0.1/www?useUnicode=true&characterEncoding=GBK","www","wwww");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
%>
<%
String iLink_no=request.getParameter("no");
String rand = (String)session.getAttribute("rand");//验证码
String code = request.getParameter("code");//获得的验证码
if(rand==null || code==null || code.trim().length()<=0 || no==null || im().length()<=0)
{
response.sendRedirect("service.jsp");
}
else
{
int no=Integer.parseInt(iLink_no);
String condition="select user_no from users where user_no="+no;
ResultSet rs=stmt.executeQuery(condition);
rs.next();
int id=rs.getInt("user_no");
rs.close();

if(id==no && rand.equals(code))
{
session.setAttribute("noid",new Integer(id)); //设置用户会话
String pwdprotsql="select user_no from pwdprot where user_no="+no;
ResultSet rs1=stmt.executeQuery(pwdprotsql);
if(rs1.next())
{
response.sendRedirect("show.jsp");
rs1.close();
}
else
{
response.sendRedirect("error6.jsp");
rs1.close();
}
}
else
{
response.sendRedirect("error.jsp");
}
}
%>

[zflfaufa]

特急，这是我的代码，帮在称看看

[zflfaufa]

<%@ page contentType= "text/html; charset=gb2312 "% >
<%@ page import= "java.sql.* "% >
<%
Class.forName( "org.gjt.mm.mysql.Driver ").newInstance();
Connection conn= DriverManager.getConnection( "jdbc:mysql://127.0.0.1/www?useUnicode=true&characterEncoding=GBK ", "www ", "wwww ");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
% >
<%
String no=request.getParameter( "no ");
String rand = (String)session.getAttribute( "rand ");//验证码
String code = request.getParameter( "code ");//获得的验证码
if(rand==null ¦ ¦ code==null ¦ ¦ code.trim().length() <=0 ¦ ¦ no==null ¦ ¦ im().length() <=0)
{
response.sendRedirect( "service.jsp ");
}
else
{
int no=Integer.parseInt(no);
String condition= "select user_no from users where user_no= "+no;
ResultSet rs=stmt.executeQuery(condition);
rs.next();
int id=rs.getInt( "user_no ");
rs.close();

if(id==no && rand.equals(code))
{
session.setAttribute( "noid ",new Integer(id)); //设置用户会话
String pwdprotsql= "select user_no from pwdprot where user_no= "+no;
ResultSet rs1=stmt.executeQuery(pwdprotsql);
if(rs1.next())
{
response.sendRedirect( "show.jsp ");
rs1.close();
}
else
{
response.sendRedirect( "error6.jsp ");
rs1.close();
}
}
else
{
response.sendRedirect( "error.jsp ");
}
}
% >

[monkeyhjl]

if(rs.next()){
id=rs.getInt("user_no");
}

[dalianwang]

关注

[不徻写代码]

up

[zflfaufa]

感谢monkeyhjl(爬上墙头等红杏) ( 的回答，的确是应该我没有做rs.next的判断，导致数据库指针的问题，各位朋友，可要千万忘记啊，不知楼主多少我的是81832527 ，以后多多交流