JSP+servlet+javabean实现分页

 

1. package bean;
3. import java.util.ArrayList;
4. /**
5. * 分页bean
6. *
7. *@author micron E-mail: 328074337@qq.com
8. *
9. */
10. public class checkPage implements java.io.Serializable{
12.     public checkPage() {
13.         try {
14.             jbInit();
15.         } catch (Exception ex) {
16.             ex.printStackTrace();
17.         }
18.     }
20.     public int queryPageNo;       // 请求的页号
21.     public int rowsPerPage ;    // 每页的行数
22.     public String querySql ;   // 查询的Sql语句
24.     public int totalPage;      // 总页数
25.     public int totalRows;      // 总行数
26.     public int lastPageRows;   // 最后一页的行数
27.     public ArrayList resultDataVec;  // 显示在当前页面中的数据
29.     public int getQueryPageNo() {
30.         return queryPageNo;
31.     }
33.     public int getTotalPage() {
34.         return totalPage;
35.     }
37.     public int getTotalRows() {
38.         return totalRows;
39.     }
41.     public int getRowsPerPage() {
42.         return rowsPerPage;
43.     }
45.     public String getQuerySql() {
46.         return querySql;
47.     }
49.     public ArrayList getResultDataVec() {
50.         return resultDataVec;
51.     }
53.     public int getLastPageRows() {
54.         return lastPageRows;
55.     }
57.     public void setQueryPageNo(int queryPageNo) {
58.         this.queryPageNo = queryPageNo;
59.     }
61.     public void setTotalPage(int totalPage) {
62.         this.totalPage = totalPage;
63.     }
65.     public void setTotalRows(int totalRows) {
66.         this.totalRows = totalRows;
67.     }
69.     public void setRowsPerPage(int rowsPerPage) {
70.         this.rowsPerPage = rowsPerPage;
71.     }
73.     public void setQuerySql(String querySql) {
74.         this.querySql = querySql;
75.     }
77.     public void setResultDataVec(ArrayList resultDataVec) {
78.         this.resultDataVec = resultDataVec;
79.     }
81.     public void setLastPageRows(int lastPageRows) {
82.         this.lastPageRows = lastPageRows;
83.     }
85.     private void jbInit() throws Exception {
86.     }
88. }
89. 1. package bean;
    3. import java.sql.*;
    4. import java.util.ArrayList;
    5. import java.util.Vector;
    7. /**
    8. * 数据操作bean
    9. *
    10. *@author micron E-mail: 328074337@qq.com
    11. *
    12. */
    14. public class doBossBean {
    15.     private Connection conn = null;
    16.     private ResultSet rs = null;
    17.     private PreparedStatement pst = null;
    18.     private Statement stmt=null;        
    19.     public doBossBean() {
    20.         try
    21.                 {
    22.                     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    23.                     conn = DriverManager.getConnection("jdbc:odbc:newhotel");
    24.                 }
    25.                 catch (SQLException ex)
    26.                 {
    27.                     System.out.println(ex.getMessage() + "路径错误");
    28.                 }
    29.                 catch (ClassNotFoundException ex)
    30.                 {
    31.                     System.out.println(ex.getMessage() + "驱动错误");
    32.                 }    
    33.     }  
    34.      
    35.     
    36.     public int getTotalRows(String sql) {
    37.            int count = 0;
    38.            try {
    39.                this.stmt = conn.createStatement();
    40.                rs = stmt.executeQuery(sql);
    41.                while (rs.next()) {
    42.                    count++;
    43.                }
    44.            } catch (SQLException ex) {
    45.             ex.printStackTrace();
    46.              System.out.print("getTotalRows errors"+ex.getMessage());
    47.            } 
    48.            return count;
    49.        }
    51.    public Vector list_room(String username, int queryPageNo,checkPage pageBean,int rowsPerPage ){
    52.         Vector vc=new Vector();
    53.       
    54.        String sql="select r_number,r_photo,if_book,r_area,r_price,r_facility,insert_time from room_info where username='"+username+"' order by insert_time desc";
    55.       
    56.           queryPageNo=pageBean.getQueryPageNo(); // 请求的页号
    57.           System.out.print("queryPageNo:"+queryPageNo+"||");
    58.           rowsPerPage=pageBean.getRowsPerPage();// 每页的行数
    59.          if( pageBean.getQuerySql()!= null )
    60.              sql = pageBean.getQuerySql();  // 如果有查询语句，则用指定的查询语句
    61.                  // 统计总行数
    62.          int totalRows = getTotalRows(sql);  //向getTotalRows传递sql语句，返回总行数
    63.          pageBean.setTotalRows(totalRows);
    64.                  // 统计总页数
    65.          int totalPage = totalRows % rowsPerPage == 0 ? totalRows / rowsPerPage :totalRows / rowsPerPage + 1;
    66.          pageBean.setTotalPage(totalPage);
    67.                  // 统计最后一页的行数
    68.          int lastPageRows = totalRows % rowsPerPage == 0 ? rowsPerPage :totalRows % rowsPerPage;        
    69.          pageBean.setLastPageRows(lastPageRows);
    70.       
    71.        try{
    72.          this.stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    73.          rs=stmt.executeQuery(sql);   
    74.           int skipRows = (queryPageNo - 1) * rowsPerPage;
    75.           for (int i = 0; i < skipRows; i++)
    76.           rs.next();
    77.           int count = rowsPerPage;
    78.          while( rs!=null && rs.next() && count>0)         
    79.          {  
    80.             bossBean bos=new bossBean();
    81.             bos.setR_number(rs.getString("r_number"));
    82.             bos.setR_photo(rs.getString("r_photo"));
    83.             bos.setR_area(rs.getString("r_area"));
    84.             bos.setR_price(rs.getString("r_price"));
    85.             bos.setR_facility(rs.getString("r_facility"));
    86.             bos.setInsert_time(rs.getString("insert_time"));
    87.             bos.setIf_book(rs.getString("if_book"));          
    88.             vc.add(bos);  
    89.             count--;  
    90.             }
    91.        
    92.        }       
    93.        catch(Exception e)
    94.        {e.printStackTrace();}
    95.        return vc;
    96.       
    97.    }
    98.     
    99. }
    100. 1. package servlet;
         3. import java.io.IOException;
         4. /**
         5. * 控制跳转的servlet
         6. *
         7. *@author micron E-mail: 328074337@qq.com
         8. *
         9. */
         10. import bean.*;
         11. import java.util.ArrayList;
         12. import java.util.Vector;
         13. import javax.servlet.*;
         14. import javax.servlet.http.*;
         16. public class select_list extends HttpServlet {
         17.     private static final String CONTENT_TYPE = "text/html; charset=GBK";
         19.     public void init(ServletConfig config) throws ServletException {
         20.         super.init(config);
         21.     }
         23.     public void service(HttpServletRequest request, 
         24.                         HttpServletResponse response) throws ServletException, IOException {response.setContentType(CONTENT_TYPE);
         25.          
         26.         HttpSession session=request.getSession();
         27.         String username=null;  
         28.        if(request.getParameter("send").equals("list_room")){
         29.                 username=(String)session.getAttribute("username");            
         30.                 
         31.                 checkPage pageBean=new checkPage();                                            
         32.                 int queryPageNo=1;  // 请求的页号
         33.                 int rowsPerPage=1;    // 每页的行数
         34.                 pageBean.setRowsPerPage(rowsPerPage);
         35.                 if(request.getParameter("action")!=null){
         36.                                      
         37.                     if(request.getParameter("queryPageNo")!=null)
         38.                     {
         39.                         queryPageNo= Integer.parseInt(request.getParameter("queryPageNo"));
         40.                     }
         41.                    
         42.                         if(request.getParameter("action").equals("first")){
         43.                               queryPageNo=1;
         44.                               pageBean.setQueryPageNo(queryPageNo);
         45.                         }                    
         46.                      else if(request.getParameter("action").equals("back"))
         47.                         {
         48.                             queryPageNo -= 1;
         49.                             pageBean.setQueryPageNo(queryPageNo);
         50.                         }                      
         51.                         else if(request.getParameter("action").equals("next"))
         52.                         { 
         53.                             queryPageNo += 1;
         54.                             pageBean.setQueryPageNo(queryPageNo);
         55.                         }
         56.                         else if(request.getParameter("action").equals("check"))
         57.                         {   String check=request.getParameter("queryPageNo");
         58.                             queryPageNo=Integer.valueOf(check);
         59.                             pageBean.setQueryPageNo(queryPageNo);
         60.                         }
         61.                         else if(queryPageNo<=1){
         62.                             queryPageNo=1;
         63.                             pageBean.setQueryPageNo(queryPageNo);
         64.                         }
         65.                         else if(request.getParameter("action").equals("last"))
         66.                         {   String no=request.getParameter("queryPageNo");
         67.                             queryPageNo=Integer.valueOf(no);
         68.                             System.out.print("queryPageNo"+queryPageNo);
         69.                             pageBean.setQueryPageNo(queryPageNo);
         70.                         }
         71.                        
         72.                     }
         73.                 
         74.                 Vector result=db.list_room(username,queryPageNo,pageBean,rowsPerPage);
         75.                 request.getSession().setAttribute("list_room",(Object)result); 
         76.                 request.setAttribute("queryPageNo",queryPageNo);
         77.                 request.setAttribute("totalPage",pageBean.getTotalPage());
         78.                 int pagecount=pageBean.getTotalPage();//得到总页数              
         79.                 request.setAttribute("pagecount",pagecount);
         80.                 int currentPage=pageBean.getQueryPageNo();//得到当前页
         81.                 request.setAttribute("currentPage",currentPage);
         82.                 
         83.                 request.getSession().setAttribute("boss_info",null);  
         84.                 request.getSession().setAttribute("search",null);
         85.                 request.getSession().setAttribute("addroom",null);
         86.                 request.getSession().setAttribute("upload_success",null);
         87.                 request.getSession().setAttribute("nullresult",null); 
         88.                 RequestDispatcher rd=request.getRequestDispatcher("trader_index.jsp");
         89.                 rd.forward(request,response);
         90.                 
         91.             }       
         92.             
         93.         }
         94.        
         95.                             
         96.     }
         97. }
         98. 1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
             2. "http://www.w3.org/TR/html4/loose.dtd">
             3. <%@ page contentType="text/html;charset=GBK"%>
             4. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
             6. <div align="center">     
             7.           
             8.     <c:if test="${not empty sessionScope.list_room}">
             9.       <c:forEach items="${sessionScope.list_room}" var="listRoom">
             10.       <table width="80%" border="1" align="center" bordercolor="#FF6600">
             11.   <tr>
             12.     <td width="89" height="31">房间编号：</td>
             13.     <td width="92">
             14.               ${pageScope.listRoom.r_number}
             15.             </td>
             16.     <td width="82">预定信息：</td>
             17.     
             18.     
             19.       <c:if test="${pageScope.listRoom.if_book ==null}">
             20.        <td width="99" >
             21.       <font color="#e70000">没有预定</font><img src="Image/sad.jpg" height="25"
             22.                                            width="25"></img>
             23.       </td>
             24.       </c:if>    
             25.        <c:if test="${pageScope.listRoom.if_book !=null}">
             26.          <td width="99" bgcolor="Yellow">
             27.       <font color="#101010">已经预定</font><img src="Image/happy.jpg" height="25"
             28.                                            width="25"></img>
             29.       </td>
             30.       </c:if>   
             31.     
             32.    
             33.   </tr>
             34.   <tr>
             35.     <td height="33">房间价格：</td>
             36.     <td>
             37.               ${pageScope.listRoom.r_price}
             38.             </td>
             39.     <td>房间面积：</td>
             40.     <td>
             41.               ${pageScope.listRoom.r_area}
             42.             </td>
             43.   </tr>
             44.   <tr>
             45.     <td height="36">发布时间：</td>
             46.     <td colspan="3">
             47.               ${pageScope.listRoom.insert_time}
             48.             </td>
             49.   </tr>
             50.   <tr>
             51.     <td height="56">房间描述：</td>
             52.     <td colspan="3">
             53.               ${pageScope.listRoom.r_facility}
             54.             </td>
             55.   </tr>
             56.   <tr>
             57.     <td height="113">图片：</td>
             58.     <td colspan="3"><img src="${pageScope.listRoom.r_photo}" height="150"
             59.                          width="150"></img></td>
             60.             
             61.           </tr>
             62. </table>
             63. </c:forEach>
             64. <table width="80%">
             65.       <tr>
             66.         <td bgcolor="#E0FFFF" onmouseover="javascript:this.bgColor='#D3D3D3'" onmouseout="javascript:this.bgColor='#E0FFFF'">
             67.           <a href="select_list?send=list_room&action=first&queryPageNo=${requestScope.queryPageNo}">首页</a>
             68.         </td>
             69.         <td bgcolor="#E0FFFF" onmouseover="javascript:this.bgColor='#D3D3D3'" onmouseout="javascript:this.bgColor='#E0FFFF'">
             70.         <c:if test="${requestScope.currentPage>1}">
             71.              <c:if test="${requestScope.queryPageNo==1}">上一页</c:if>
             72.               <c:if test="${requestScope.queryPageNo!=1}">
             73.                 <a href="select_list?send=list_room&action=back&queryPageNo=${requestScope.queryPageNo}">上一页</a>
             74.                </c:if>
             75.         </c:if>
             76.         </td>
             77.         
             78.         <c:forEach begin="1" end="${requestScope.totalPage}" varStatus="status">
             79.          <td width="5%" bgcolor="#E0FFFF" onmouseover="javascript:this.bgColor='#D3D3D3'" onmouseout="javascript:this.bgColor='#E0FFFF'">
             80.             <c:if test="${status.index == pageNo}">
             81.               <span class="currentPage">${status.index}</span>
             82.             </c:if>
             83.             <c:if test="${status.index != pageNo}">
             84.             <span><a href="select_list?send=list_room&action=check&queryPageNo=${status.index}" >${status.index}</a></span>
             85.             </c:if>
             86.        </td>
             87.       </c:forEach>
             89.        
             90.         <td bgcolor="#E0FFFF" onmouseover="javascript:this.bgColor='#D3D3D3'" onmouseout="javascript:this.bgColor='#E0FFFF'">
             91.         <c:if test="${requestScope.currentPage<requestScope.totalPage}">       
             92.             <c:if test="${requestScope.queryPageNo!=requestScope.pagecount}">
             93.              <a href="select_list?send=list_room&action=next&queryPageNo=${requestScope.queryPageNo}">下一页</a>
             94.            </c:if>
             95.        </c:if>
             96.         </td>
             97.           <td bgcolor="#E0FFFF" onmouseover="javascript:this.bgColor='#D3D3D3'" onmouseout="javascript:this.bgColor='#E0FFFF'">
             98.             <a href="select_list?send=list_room&action=last&queryPageNo=${requestScope.totalPage}">
             99.               尾页
             100.             </a>
             101.           </td>
             102.           <td bgcolor="#E0FFFF">
             103.           共${requestScope.totalPage}页
             104.         </td>
             105.         <td>   
             106.        
             107.         <select name="pageNo">
             108.          <c:forEach begin="1" end="${requestScope.totalPage}" varStatus="status">
             109.          <option value="${status.index}" ${status.index == pageNo ? 'selected' : ''}>
             110.          ${status.index}
             111.          </option>         
             112.         </c:forEach>
             113.         </select>     
             114.       
             115.         </td>
             116.       </tr>
             117.     </table>
             118. </c:if>
             119.   </p>
             120. </div>