Jsp分页

 

<%
		int dipage=1;          //当前页码数默认为1
		String pages=request.getParameter("dipage");
		
		if(pages==null)
		{
		  pages="1";
		}
		
		try
		{
		  dipage=Integer.parseInt(pages);
		}
		catch(Exception e)
		{
		  dipage=1; 
		}
		
    try 
    {  //Connection conn;
       Statement stm; 
       ResultSet rs;
       conn=DBToolsX.getConnection();
       stm=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
        
       String sql="select * from equipment order by id desc";
       rs=stm.executeQuery(sql);
       int countRecord=0;                         //记录条数
       int countPageRecord=0;                     //每页记录条数
       int countPage=0;                           //总页数
       countPageRecord=20;                        //每页20条记录，要设置每页记录条数就更改这个变量的值
       rs.last();                                 //得到记录的条数  
       countRecord=rs.getRow();
       countPage=countRecord/countPageRecord+1;   //得到总页数      
       if((dipage-1)*countPageRecord==0)          //把记录指针移至当前页第一条记录之前
          rs.beforeFirst();
       else
          rs.absolute((dipage-1)*countPageRecord);
          int i=0;
       while(rs.next())
       { 
       String id=rs.getString("id");
	     String equipment_class2=rs.getString("equipment_class");
       String equipment_name2=rs.getString("equipment_name");
	     String guige2=rs.getString("guige");   
%>

 

<%
    i++;
    if(i>=countPageRecord) break; //当前页显示完，则退出循环
    }
    out.print("<TR><td colspan=8 align=center>");
    out.print("共"+countRecord+"条记录,共"+countPage+"页，当前第"+dipage+"页，每页"+countPageRecord+"条记录，");
		if(dipage==1)//当前是首页
		;
		else         //当前不是首页
		 {
		   out.print("<a href=equipment.jsp?dipage=1>首页</a> ");
		   out.print("<a href=equipment.jsp?dipage="+(dipage-1)+"><上一页</a> ");
		 }
		if(dipage==countPage)//当前是末页
		;
		else//当前不是末页
		 {
		   out.print("<a href=equipment.jsp?dipage="+(dipage+1)+">下一页></a> ");
		   out.print("<a href=equipment.jsp?dipage="+countPage+">末页</a>");
		 }          
		 out.print("</td></tr>"); 
		 conn.close();
     }
   catch(SQLException e1) 
   {
      out.print(e1);
   }
%>