分页处理代码

int pageSize=3;
String spageNow=req.getParameter("pageNow");//用来获取需要看的页面的页号
int pageNow;
int rowCount=0;
int pageCount=0;
if(spageNow==null)
{
pageNow=1;//第一次进入页面
}
else
{
pageNow=Integer.parseInt(spageNow);//请求进入
}



Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=spdb","sa","sa");

sm=ct.createStatement();
rs=sm.executeQuery("select count(*) from users ");


if(rs.next())//获取记录的条数
{
rowCount=rs.getInt(1);
}


if(rowCount%pageSize==0)//获取总的页数
{
pageCount=rowCount/pageSize;
}
else
{
pageCount=rowCount/pageSize+1;
}

sm=ct.createStatement();
rs=sm.executeQuery("select top "+pageSize+" * from users where userId not in (select top "+pageSize*(pageNow-1)+" userId from users)");

pw.println("<table>");
while(rs.next())
{
pw.println("<tr>");
pw.println("<td>");
pw.println(rs.getInt(1));
pw.println("<td>");
pw.println("<td>");
pw.println(rs.getString(2));
pw.println("<td>");
pw.println("<td>");
pw.println(rs.getString(3));
pw.println("<td>");
pw.println("</tr>");

}
pw.println("</table>");


pw.println("<a href=welcomeall?pageNow="+(pageNow-1)+">上一页</a>"); 
for(int i=1;i<=pageCount;i++)
{
pw.println("<a href=welcomeall?pageNow="+i+">"+i+"</a>");
}
pw.println("<a href=welcomeall?pageNow="+ (pageNow+1) +">下一页</a>");