给下面代码增加分页功能,要求细致,逻辑清楚,<form action="./../selectNews" method="post"> <input type="text" name="key" id="key" placeholder="请输入标题"/> <input type="submit" value="查询"/> <a href="zhuce.jsp">发布新闻</a> <a href="../user01/index.jsp">返回主页</a> </form> <table> <thead> <tr> <th>新闻编号</th> <th>新闻标题</th> <%-- <th>新闻内容</th>--%> <th>新闻类别</th> <th>发布人</th> <th>发布时间</th> <th>状态</th> <th>是否头条</th> <th colspan="4" align="center">操作</th> </tr> </thead> <tbody> <c:forEach items="${newslist}" var="u"> <tr> <td>${u.nid}</td> <td>${u.title}</td> <%-- <td>${u.content}</td>--%> <td>${u.type}</td> <td>${u.userName}</td> <td>${u.pubTime}</td> <td> <c:choose> <c:when test="${u.state==0}"><span style="color: ghostwhite">未审核</span></c:when> <c:when test="${u.state==1}"><span style="color: green">审核通过</span></c:when> <c:otherwise><span style="color: red">未通过</span></c:otherwise> </c:choose> </td> <td> <c:choose> <c:when test="${u.top==0}">否</c:when> <c:otherwise>是</c:otherwise> </c:choose> </td> <c:choose> <c:when test="${user.rule==1}"> <td> <a href="../NewsDetailServlet?nid=${u.nid}&op=show">查看</a> </td> <td> <a href="../NewsDetailServlet?nid=${u.nid}&op=update">修改</a> </td> <td> <a href="NewsDelete.jsp?nid=${u.nid}&title=${u.title}&userName=${user.userName}">删除</a> </td> <td> <a href="Newsshenhe.jsp?nid=${u.nid}&title=${u.title}&userName=${user.userName}">审核</a> </td> </c:when> <c:when test="${user.rule==0 && user.uid==u.uid}"> <td><a href="../NewsDetailServlet?nid=${u.nid}&op=show">查看</a></td> <td><a href="../NewsDetailServlet?nid=${u.nid}&op=update">修改</a></td> <td><a href="NewsDelete.jsp?nid=${u.nid}&title=${u.title}&userName=${user.userName}">删除</a></td> </c:when> <c:otherwise> <td><a href="../NewsDetailServlet?nid=${u.nid}&op=show">查看</a></td> </c:otherwise> </c:choose> </tr> </c:forEach> </table>
时间: 2023-07-09 22:22:46 浏览: 128
bootstrap-select-pagination:修改引导选择源代码,添加支持分页的新功能-bootstrap source code
首先,我们需要在表单中添加一个分页控件,例如:
<form action="./../selectNews" method="post">
<input type="text" name="key" id="key" placeholder="请输入标题"/>
<input type="submit" value="查询"/>
<a href="zhuce.jsp">发布新闻</a>
<a href="../user01/index.jsp">返回主页</a>
<!-- 分页控件 -->
<div class="pagination">
<c:if test="${currentPage > 1}">
<a href="./../selectNews?page=${currentPage - 1}&key=${param.key}">上一页</a>
</c:if>
<c:forEach begin="${minPage}" end="${maxPage}" var="i">
<c:choose>
<c:when test="${i == currentPage}">
<span class="current">${i}</span>
</c:when>
<c:otherwise>
<a href="./../selectNews?page=${i}&key=${param.key}">${i}</a>
</c:otherwise>
</c:choose>
</c:forEach>
<c:if test="${currentPage < totalPages}">
<a href="./../selectNews?page=${currentPage + 1}&key=${param.key}">下一页</a>
</c:if>
</div>
</form>
我们使用了一个名为 "pagination" 的 div 元素来包含分页控件。其中,currentPage 表示当前页数,totalPages 表示总页数,minPage 和 maxPage 分别表示当前页数左边和右边的页数范围。
在 Java Servlet 中,我们需要对请求参数进行解析,计算出分页所需的各个参数,并将它们传递给 JSP 页面。例如:
int page = Integer.parseInt(request.getParameter("page"));
int pageSize = 10; // 每页显示的记录数
int start = (page - 1) * pageSize; // 计算起始记录数
String key = request.getParameter("key");
List<News> newslist = NewsDAO.selectNews(start, pageSize, key);
int totalCount = NewsDAO.getNewsCount(key);
int totalPages = (int) Math.ceil(totalCount * 1.0 / pageSize);
int minPage = Math.max(1, page - 5);
int maxPage = Math.min(totalPages, page + 5);
request.setAttribute("newslist", newslist);
request.setAttribute("currentPage", page);
request.setAttribute("totalPages", totalPages);
request.setAttribute("minPage", minPage);
request.setAttribute("maxPage", maxPage);
request.getRequestDispatcher("newslist.jsp").forward(request, response);
在 JSP 页面中,我们需要根据传递过来的参数来生成分页控件。我们可以使用 JSTL 标签库中的 forEach 标签来循环生成分页链接。例如:
<c:if test="${currentPage > 1}">
<a href="./../selectNews?page=${currentPage - 1}&key=${param.key}">上一页</a>
</c:if>
<c:forEach begin="${minPage}" end="${maxPage}" var="i">
<c:choose>
<c:when test="${i == currentPage}">
<span class="current">${i}</span>
</c:when>
<c:otherwise>
<a href="./../selectNews?page=${i}&key=${param.key}">${i}</a>
</c:otherwise>
</c:choose>
</c:forEach>
<c:if test="${currentPage < totalPages}">
<a href="./../selectNews?page=${currentPage + 1}&key=${param.key}">下一页</a>
</c:if>
注意,我们在分页链接中传递了当前页数和查询关键字两个参数,这样在用户点击分页链接时就可以保持查询关键字不变,同时跳转到相应的页数。
最后,我们需要在查询语句中添加 LIMIT 子句来限制返回的记录数。例如:
SELECT * FROM news WHERE title LIKE '%${key}%' LIMIT ${start}, ${pageSize};
其中,${start} 和 ${pageSize} 分别表示起始记录数和每页显示的记录数。这样就可以实现分页功能了。
阅读全文