需要先求出壹***有多少條記錄,並設置每頁顯示多少條記錄。
int pageSize=1,pageCount=0,rowCount=0,pageNow=1;
String pageNow_n=request.getParameter("pageNow");
if(pageNow_n!=null)
{
pageNow=Integer.parseInt(pageNow_n);
}
try
{
String sql3="select count(*) from 表名";
pstm=conn.prepareStatement(sql3);
rs=pstm.executeQuery();
if(rs.next())
{rowCount=rs.getInt(1);}
if(rowCount%pageSize==0)
{pageCount=rowCount/pageSize;}
else{pageCount=rowCount/pageSize+1;}
String sql2="select * from 表名limit ?,?";
pstm=conn.prepareStatement(sql2);
pstm.setInt(1,(pageNow-1)*pageSize);
pstm.setInt(2,pageSize);
rs=pstm.executeQuery();
}
catch(Exception e)
{
e.printStackTrace();
}
while(rs.next()){%>
<tr>
顯示查詢的內容<%}%>
<%if(rs.next()){%>
<%if(pageNow!=1){
%>
<a href="頁面名.jsp?pageNow=<%=pageNow-1%>">上壹題</a>
<%}
if(pageNow!=pageCount){
%>
<a href="頁面名.jsp?pageNow=<%=pageNow+1%>">下壹題</a>
<% }%>