jsp中分页显示的处理样例

最新推荐文章于 2022-03-05 17:51:10 发布

tdslg

最新推荐文章于 2022-03-05 17:51:10 发布

阅读量546

点赞数

分类专栏：动态网站开发文章标签： jsp string sqlserver microsoft iterator exception

本文链接：https://blog.csdn.net/tdslg/article/details/457075

版权

动态网站开发专栏收录该内容

1 篇文章 0 订阅

订阅专栏

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,shop.*,java.util.*" errorPage="" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<%     int curPage;
       int maxPage;
    int maxRowCount;
    int rowsPerPage=2;
    String strPage;
%>
<%   strPage = request.getParameter("page");
      if(strPage==null){
         curPage = 1;
   }
   else
   {
   curPage = java.lang.Integer.parseInt(strPage);
         if(curPage<1) curPage = 1;
   }
  String strSQL = "select * from book order by createTime desc";
  Statement stmt=con.createStatement();
    ResultSet rst=stmt.executeQuery(strSQL);
  Collection ret=new ArrayList();
  while(rst.next())
  {
   Book temp=new Book();
   temp.setName(rst.getString("name"));
   temp.setCreateTime(rst.getDate("createTime"));

   ret.add(temp);
  }
  maxRowCount=ret.size();
  maxPage=(maxRowCount%rowsPerPage==0)?(maxRowCount/rowsPerPage):(maxRowCount/rowsPerPage+1);
  %>
  <form method="POST" action="a.jsp">
         第<%=curPage%>页共<%=maxPage%>页

<%if(curPage<maxPage){%><a

href="a.jsp?page=<%=curPage+1%>">下一页

</a><%}%> <%if(curPage>1){%><a href="a.jsp?page=<%=curPage-1%>">

          上一页</a><%}%>
           转到第:<input type="text" name="page" size="8"> 页

          </form>

   <%

    /* Iterator it=ret.iterator();
    while(it.hasNext())
                {
       Book book=(Book)it.next();
                    out.println(book.getName());

     }*/
    session.setAttribute("ret",ret);
    int i=(curPage-1)*rowsPerPage;
    int j=curPage*rowsPerPage-1;
    session.setAttribute("i",i);
    session.setAttribute("j",j);

    %>

    <c:forEach var="r" items="${ret}" begin="${i}" end="${j}">

           <c:out value="${r.name}<br>" escapeXml="false"/>
          </c:forEach>

</body>
</html>