优秀论坛课程设计 有可行的代码。1、翻页功能的实现
在这里可以实现翻页功能，根据你的实际需求进行选择。
程序为：
<%
int MaxNum = 10;//每页容纳的主题论文的最大数目
int count = 0, firstPage = 1, lastPage, firstNum, lastNum, prePage, nextPage, pageNO;
//firstPage表示首页，lastPage表示末页，pageNO表示第几页，
//firstNum表示该页的起始贴的ID，lastNum表示该页的末帖的ID，
//prePage表示前一页，nextPage表示后一页
sql = "select * from discuss";
rs = stm.executeQuery(sql);
while (rs.next())
count++;
if (request.getParameter("pageNO") == null)
pageNO = 0;
else
pageNO = Integer.parseInt(request.getParameter("pageNO"));
lastPage = (int) Math.ceil((double) count / MaxNum);
if (pageNO == 0)
pageNO = 1;
if (pageNO > lastPage)
pageNO = lastPage;
firstNum = (pageNO - 1) * MaxNum + 1;
lastNum = pageNO * MaxNum;
if (pageNO == 1)
prePage = 1;
else
prePage = pageNO - 1;
if (pageNO == lastPage)
nextPage = pageNO;
else
nextPage = pageNO + 1;
sql = "select * from discuss where id between " + firstNum
+ " and " + lastNum;
rs = stm.executeQuery(sql);
%>
