Why it can't paging?!

[Yashnoo lyo]

Hi everyone:
I have a guestbook using mysql.I want to paging and each page have six record.But it remain the first page when I click the "next page"!But I have eighteen record in all.Why?My jsp code is:
////////////////////////////////////////main.jsp///////////////////////////////////////////////
........ ........... ........... ......... ........... .......... .......... ..........
<%
String sql="select * from statement where fatherid is null";
String sqlnum="select count(*) from statement";
ResultSet rs;
int numCount=0;
int pageSize=6;
int intpage=1;
String strPage="";
rs = lyo.executequery(sql);
while(rs.next()){
%>
<tr><%String sid=rs.getString("id");%>
<td><a href="/lyojsp/viewtitle.jsp?id=<%=sid%>"><%=rs.getString("title")%></a></td>
<td><%=rs.getString("content")%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("time")%></td>
</tr>
<%
}
rs=lyo.executequery(sqlnum);

if(rs.next()){
numCount=rs.getInt(1);
if(intpage>numCount)
intpage=numCount;
}
int pageint=(numCount+pageSize-1)/pageSize;
if(intpage>numCount) intpage=pageint;
strPage=request.getParameter("id");
if (strPage==null){
intpage=1;}else{
intpage=Integer.parseInt(strPage);
if(intpage<1)
intpage=1;
}
%>
</table><h5>The Total is</h5><font color=red><%=numCount%></font><h5>record</h5><h4><%=pageint%></h4><h4>page</h4><p>
The<%=intpage%>page <%if(intpage<numCount){%><a href="/lyojsp/main.jsp?id=<%=intpage+1%>">next page</a><%}%>
<%if(intpage>1){%><a href="/lyojsp/main.jsp?id=<%=intpage-1%>">previous</a><%}%>
Why?Anyone want to help me?Thank you.

[Andres Gonzalez]

you must be doing something wrong with your calculations. I usually do not do this manually (paging), since there are existings tools that allow you to do it very easily...
For instance, I use the pager taglib, which pretty much does the same as you're trying to do. You can set up how many records you want in every page very easy without doing "complex" calculations...Have you tried it...? I'm sure your code will be a lot cleaner and it'll save you lots of times
hope it helps

[Yashnoo lyo]

Hi Andres Gonzalez :
I use it but it is difficult to control.And it don't work property.When I click the "next page" the page dosn't change.Why?
I had give the tag the parameter And it have pageurl,pagenumber.
[ April 27, 2003: Message edited by: lyo lyo ]

[Andres Gonzalez]

It is not difficult to control once you've configured properly . you must be missing something
quick example:

<%@ taglib uri="/WEB-INF/pager-taglib.tld" prefix="pg" %>
... jsp stuff....
<pg :-P	 ager maxItems="20" maxPageItems="30" maxIndexPages="10">
Iterator i = yourDBResults.iterator();
while (i.hasNext())
{
   SomeBean yourBean = (SomeBean)i.next();
   <pg:item>
      <tr>
         response.encodeURL("/displayMessage.jsp?messageID=" + yourBean.getItem_id());   
      </tr>
   </pg:item>
}
<pg:index>
    <pg :-P	 rev><a href="<%= pageUrl %>">[<< Prev]</pg :-P	 rev>
    <pg :-P	 ages>
<%
      if (pageNumber.intValue() < 10) { 
        %> <%
      }
      if (pageNumber == pagerPageNumber) 
      { 
%>
        <b><%= pageNumber %></b>
<%
      } 
      else 
      { 
%>
        <a href="<%= pageUrl %>"><%= pageNumber %></a>
<%
      }
%>
    </pg :-P	 ages>
    <pg:next><a href="<%= pageUrl %>">[Next >>]</a></pg:next>
  </pg:index>
</pg :-P	 ager> 

this is just a quick and dirty example... have a look at the documentation, they explained all this step by step

[Andres Gonzalez]

sorry .. forgot to disable smiles...

[Yashnoo lyo]

Thank you Andres Gonzalez !It works well!