我的一段实现分页的代码

原创

youxue 2007-11-19 21:15:42 博主文章分类：程序设计 ©著作权

©著作权归作者所有：来自51CTO博客作者youxue的原创作品，请联系作者获取转载授权，否则将追究法律责任

package com.webtier;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.ResultSet;
import java.util.*;
import com.domain.DutyVO;
import com.dao.DutyDao;
import com.tool.*;
//职务信息的servlet
public class DutyServlet extends HttpServlet {
private DutyVO vo = null;
private DutyDao dao = null;
private int method;

public void doGet(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    request.setCharacterEncoding("gb2312");

    method = Integer.parseInt(request.getParameter("method"));
    vo = new DutyVO();
    dao = new DutyDao();
    switch (method) {
      case 0: {
        this.dutySelect(request, response); //查询全部信息
        break;
      }
}
public void dutySelect(HttpServletRequest request,
                         HttpServletResponse response) throws
      ServletException, IOException {
   try{
    response.setContentType("text/html;charset=gb2312");
    JDBConnection connection=new JDBConnection();
    HttpSession session=request.getSession();
    String accouts=(String)session.getAttribute("accouts");//得到员工工号
    String rt_number=null;
    String sql="select * from tb_employee where em_accouts='"+accouts+"'";//查询到员工表中的员工工号
    ResultSet rs=connection.executeQuery(sql);//执行
    if(rs.next()){
     rt_number=rs.getString("em_number");
  // System.out.print(number);
    }

    String sql2="select *from tb_right where rt_number ='"+rt_number+"' and rt_code="+1;
    ResultSet rs2=connection.executeQuery(sql2);

  if(rs2.next()){

     List list = dao.dutySelect();
     int pageNumber = list.size(); //计算出有多少条记录
     int maxPage = pageNumber; //计算有多少页数
     String number = request.getParameter("i");
     if (maxPage % 5 == 0) {
       maxPage = maxPage / 5;
     }
     else {
       maxPage = maxPage / 5 + 1;
     }
     if (number == null) {
       number = "0";
     }
     request.setAttribute("number", String.valueOf(number));
     request.setAttribute("maxPage",String.valueOf(maxPage));
     request.setAttribute("pageNumber",String.valueOf(pageNumber));
     request.setAttribute("list", list);
     RequestDispatcher requestDispatcher = request.getRequestDispatcher(
         "dataDuty/dutySelect.jsp");
     requestDispatcher.forward(request, response);
   }
   else{
    PrintWriter out = response.getWriter();
    out.print("<script language='javascript'> " +
     "window.alert('您没有此权限功能');" +
     "window.location='login.jsp'; </script>");
   return;
   }
}catch(Exception e){

}

}

public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
doGet(request, response);
}

}
===========================================================================

<%@page contentType="text/html; charset=gb2312"%>
<%@page import="com.domain.DutyVO"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@ page import="com.dao.DutyDao" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css/style.css" rel="stylesheet" type="text/css">
<title>查询职务信息</title>
</head>
<%
List list = (List) request.getAttribute("list");
int number=Integer.parseInt((String)request.getAttribute("number"));
   int maxPage=Integer.parseInt((String)request.getAttribute("maxPage"));
int pageNumber=Integer.parseInt((String)request.getAttribute("pageNumber"));
   int start=number * 5;//开始条数
   int over=(number+1) * 5;//结束条数
   int count=pageNumber-over;//还剩多少条记录
   if(count<=0){
   over=pageNumber;
}
%>
<body>
<table width="803" height="136" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#004C86" class="tableBorder_r" >
<tr align="left" valign="top">
    <td height="21" colspan="3">
   <jsp:include page="../shouye.jsp"/>
    </td>
</tr>
<tr>
    <td width="192" height="80%" background="picture/left.jpg" scope="row">
    <jsp:include page="../da.jsp"/>    </td>
    <td width="635" height="80%" scope="row">
      <div align="center"><p> </p></div>

      <table width="68%" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#819BBC" bordercolorlight="#FFFFFF">
   <tr bgcolor="#EFF6FE">
      <td height="28" colspan="4"><div align="center"><strong>查询职务信息</strong></div></td>
   </tr>
         <tr align="center" bgcolor="#EFF6FE">
           <td width="14%" height="25">编号</td>
           <td width="23%" bgcolor="#EFF6FE">名称</td>
     <td width="30%">职责范围</td>
     <td width="33%" bgcolor="#EFF6FE">操作</td>
         </tr>
      <%
        for (int i =start; i < over; i++) {
          DutyVO duty = (DutyVO) list.get(i);
      %>
        <tr align="center">
          <td height="29"><%=duty.getDuty_number()%></td>
          <td><%=duty.getDuty_name()%></td>
    <td><%=duty.getDuty_remark()%></td>
          <td><a href="dutyservlet?method=3&number=<%=duty.getDuty_number()%>">修改</a>   <a href="dutyservlet?method=2&id=<%=duty.getId()%>">删除</a></td>
        </tr>
      <%}%>
      </table>