如此分页错在哪??

将你的for循环显示部分
<%
for(int i=1;i<=PageSize;i++)
{
%>
<........table..........>
<%}%>
改为
<%
int i=0;
do{
//显示语句
}while(++i<pageSize&&rs.next());
//pageSize为你每页要显示的记录数目
%>

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

参见http://expert.csdn.net/Expert/topic/1219/1219004.xml?temp=.0123865，里面有详细解答
500 Servlet Exception
java.lang.NullPointerException
at _gbook._index__jsp._jspService(/study/gbook/index.jsp:116)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:312)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:221)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:536)
to  freefalcon(心宇)
我改成你那样了也出现..
500 Servlet Exception
java.lang.NullPointerException
at _gbook._index__jsp._jspService(/study/gbook/index.jsp:116)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:312)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:221)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:536)____________
没改之前也出现这个...我不用分页只显示记录的话.可以正常显示..
____________________________________________________
|探索JSP的小菜鸟..望大家多多指教.因为我实在是太菜了.|
|___________________________________________________|
<input type="text" name=ToPage style="height:25px;width:40px" value=<%=ShowPage%>>
改为：
<input type="text" name=“ToPage” style="height:25px;width:40px" value=“<%=ShowPage%>”>
记录集为NULL,再调用next()就会出现java.lang.NullPointerException提示,你可以先用if(rs!=null)判断再执行分页.
116行是:rs.absolute((ShowPage-1)*PageSize+1);
师傅还是不行.我试着把后面的删掉.还是不行.
建议你用return
断点测试
看看到底问题在那？然后告诉我是哪个地方！
我再帮你看看。
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*" %>
<%!
int PageSize=10;
int ShowPage=1;
int RowCount=0;
int PageCount=0;
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;public void jspInit()
{
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/nncndata?user=huifei&password=showme&useUnicode=true&characterEncoding=8859_1" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="SELECT * FROM ggbook";
ResultSet rs=stmt.executeQuery(sql);
rs.last();
RowCount=rs.getRow();
PageCount=((RowCount%PageSize)==0?
(RowCount/PageSize):(RowCount/PageSize)+1);
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
public void jspDestroy()
{
try{
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
%>
<html>
<head>
<title>留言本</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<DIV align=center>
<CENTER>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#4f4f4f cellSpacing=0 cellPadding=0 width=500 border=1>
<TBODY>
<TR>
<TD width="100%" bgColor=#efefef>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#4f4f4f cellSpacing=0 cellPadding=5 width="100%" border=0>
<TBODY>
<TR>
<TD align=middle width="100%" background=images/table.gif><B><FONT color=#ffffff>留言本</FONT></B></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD width="100%" bgColor=#ffffff>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#4f4f4f cellSpacing=0 cellPadding=2 width="100%" border=0>
<TBODY>
<TR>
<TD class=shadow width="75%">当前位置:<A href="http://www.nncn.com/">时尚数码</A> -  浏览留言</TD>
<TD class=shadow align=right width="25%"></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></CENTER></DIV>
<DIV align=center>
<CENTER>
<TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" borderColor=#4f4f4f cellSpacing=0 cellPadding=0 width=500 border=0>
<TBODY>
<TR>
<TD style="BORDER-RIGHT: 1px solid; BORDER-LEFT: 1px solid" width="100%" bgColor=#ffffff>
<TABLE id=AutoNumber3 style="BORDER-COLLAPSE: collapse" borderColor=#4f4f4f cellSpacing=0 cellPadding=3 width="100%" border=0>
<TBODY>
<TR>
<TD align=middle width="15%"><A href="add.jsp"><IMG src="images/new.jpg" border=0></A></TD>
<TD align=middle width="15%"><A href=""><IMG src="images/read.jpg" border=0></A></TD>
              <TD width="40%">  </TD>
              <TD align=middle width="15%"><IMG src="images/register.jpg" width="50" height="49" border=0></TD>
              <TD align=middle width="15%"><IMG src="images/admin.jpg" width="50" height="49" border=0></TD>
            </TR>
            </TABLE></TD></TR></TBODY></TABLE></CENTER></DIV>
<DIV align=center>
<CENTER>
<TABLE id=AutoNumber10 style="BORDER-COLLAPSE: collapse" borderColor=#4f4f4f height=20 cellSpacing=0 cellPadding=0 width=500 border=1>
<TBODY>
<TR>
          <TD vAlign=top align=middle width="100%" bgColor=#efefef height=20> 
          </TD>
        </TR></TBODY></TABLE></CENTER></DIV>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#4f4f4f height=3 cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD width="100%"></TD></TR></TBODY></TABLE>
<DIV align=center>
<CENTER>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#4f4f4f cellSpacing=0 cellPadding=0 width=500 border=1>
<TBODY>
<TR>
<TD vAlign=top width="30%" bgColor=#efefef>
<%
String ToPage=request.getParameter("ToPage");
if(ToPage!=null)
{
ShowPage=Integer.parseInt(ToPage);
if(ShowPage>PageCount)
{
ShowPage=PageCount;
}
else if(ShowPage<=0)
{
ShowPage=1;
}
}
rs.absolute((ShowPage-1)*PageSize+1);
for(int i=1;i<=PageSize;i++)
{
%>
<TABLE style="TABLE-LAYOUT: fixed; BORDER-COLLAPSE: collapse" borderColor=#111111 cellSpacing=0 cellPadding=2 width="100%" border=0>
<TBODY>
<TR>
                  <TD class=shadow align=middle width="100%"><IMG src="<%=rs.getString("face")%>" border=0></TD>
                </TR>
<TR>
                  <TD class=shadow width="100%">  网友大名:</TD><%=rs.getString("username")%>
                </TR>
<TR>
                  <TD class=shadow width="100%">  腾讯OICQ:</TD><%=rs.getString("qq")%>
                </TR></TBODY></TABLE></TD>
<TD width="70%" bgColor=#ffffff>
<TABLE id=AutoNumber6 style="BORDER-COLLAPSE: collapse" borderColor=#111111 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width="100%" bgColor=#efefef>
<TABLE id=AutoNumber7 style="BORDER-COLLAPSE: collapse" borderColor=#111111 cellSpacing=0 cellPadding=3 width="100%" border=0>
<TBODY>
<TR>
<TD class=shadow width="100%">第 <%=rs.getString("id")%> 条留言是在 <%=rs.getString("addtime")%> 发表的</TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD style="BORDER-TOP: 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-BOTTOM: 1px solid; BORDER-RIGHT-WIDTH: 1px" width="100%">
<TABLE id=AutoNumber8 style="TABLE-LAYOUT: fixed; BORDER-COLLAPSE: collapse" borderColor=#111111 height=40 cellSpacing=0 cellPadding=3 width="100%" border=0>
<TBODY>
<TR>
                          <TD class=shadow vAlign=top align=middle width="8%"><IMG src="<%=rs.getString("brow")%>" border=0></TD>
                          <TD class=shadow vAlign=top width="92%"><BR></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD width="100%" bgColor=#efefef>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#111111 cellSpacing=0 cellPadding=3 width="100%" border=0>
                      <TBODY>
                        <TR>
                          <TD width="18%" height="22" align=middle class=shadow><A title=<%=rs.getString("username")%>的邮件地址是：<%=rs.getString("email")%> href="mailto:<%=rs.getString("email")%>">电子邮件</A></TD>
                          <TD class=shadow align=middle width="18%"><A href="<%=rs.getString("homeurl")%>" target=_blank>个人主页</A></TD>
                          <TD class=shadow align=middle width="18%"><A title=<%=rs.getString("username")%>的QQ号码是：<%=rs.getString("qq")%>href="http://search.tencent.com/cgi-bin/friend/user_show_info?ln=<%=rs.getString("qq")%>">腾讯OICQ</A></TD>
                        </TR>
                      </TBODY>
                    </TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<%
  if(!rs.next())
  break;
}
  %>

</CENTER></DIV>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#4f4f4f height=3 cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD width="100%"></TD></TR></TBODY></TABLE>
<%
   if(ShowPage!=1)
{
  %>
  <a href=index.jsp?ToPage=<%=1%>>到第一页</a>
  <a href=index.jsp?ToPage=<%=ShowPage-1%>到上一页</a>
  <%
}
  if(ShowPage!=PageCount)
{
  %>
<a href=index.jsp?ToPage=<%=ShowPage+1%>>到下一页</a>
<a href=index.jsp?ToPage=<%=PageCount%>>到最后一页</a>
<%
}
  %>
  <td width=150>
  <form action=index.jsp method=post>
  到<input type="text" name="ToPage" style="height:25px;width:40px" value="<%=ShowPage%>">页</form>
  </td><DIV align=center>
<CENTER>
  </CENTER></DIV>
</body>
</html>
这是全部代码..看看吧.
这分页是我从书上抄下来的.
____________________________________________________
|探索JSP的小菜鸟..望大家多多指教.因为我实在是太菜了.|
|________________
ToPage这个参数名与提交页哪个参数名一致吗？
请仔细检查！