mybatis分页(PageHelper)

最新推荐文章于 2025-07-06 15:30:22 发布

LM_AC

最新推荐文章于 2025-07-06 15:30:22 发布

阅读量573

点赞数

CC 4.0 BY-SA版权

分类专栏：第三阶段框架

本文链接：https://blog.youkuaiyun.com/Myair_AC/article/details/78464059

第三阶段框架专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一种基于Java和JSP实现的分页技术，利用PageHelper进行分页查询，并展示了如何通过前端JSP页面展示分页效果。文章详细解释了控制器类中分页查询的实现方式，并提供了完整的JSP页面代码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

需求:实现分页(xml+接口)
page页面(公共页面,在别的jsp使用include引用)

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>

<!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=UTF-8">
<title>Insert title here</title>
</head>
<body>
        <c:if test="${!pageinfo.isFirstPage}">
            <input type="button" value="上一页" name="${pageinfo.prePage}"/> 
            </c:if>
            <c:if test="${!pageinfo.isLastPage}">
            <input type="button" value="下一页" name="${pageinfo.nextPage}"/> 
            </c:if>
            <input type="button" value="首页" name="${pageinfo.firstPage}"/> 
            <input type="button" value="尾页" name="${pageinfo.lastPage}"/>

    <br />
    <!-- 页码 -->
                <c:forEach begin="1" end="${pageinfo.pages}" varStatus="st">

                  <input type="button" value="第${st.count}页" name="${st.count}"/>

                </c:forEach>
    <br>
</body>
</html>

useradmin.jsp(显示全部数据的页面)

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>

<html>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Insert title here</title>
<script type="text/javascript" src="js/jquery-1.8.3.min.js"></script>
<script type="text/javascript">
    $(function() {
        $("#id1").change(
                function() {
                    // 当前页数           pageNum="+$("#id1").find("option:selected").text() 
                    // 每页显示的数据条数    pageSize="+$("#id1").val()
                    window.location.href = "userlist?pageNum="
                            + $("#id1").find("option:selected").text()
                            + "&pageSize=" + $("#id1").val();
                })
        $("#id3").click(function() {
            window.location.href = "userlist?pageNum=" + $("#id2").val();
        })
        $("input:button").click(function(){    
        window.location.href = "userlist?pageNum=" + $(this).attr("name");
    }) 
    })
</script>

<link type="text/css" rel="stylesheet" href="css/style.css">
<script type="text/javascript">
    function doit(flag, id) {
        if (flag == "del") {
            if (confirm("确认删除吗？") != true)
                return;
        }
    }
</script>
</head>
<body>




    <div class="menu">

        <table>
            <tbody>
                <tr>
                    <td><form method="post" action="user.do">
                            <input name="flag" value="search" class="input-text"
                                type="hidden"> 用户名称：<input name="userName"
                                class="input-text" type="text">&nbsp;&nbsp;&nbsp;&nbsp;
                            <input value="查 询" type="submit">
                        </form></td>
                </tr>
            </tbody>
        </table>
    </div>
    <div class="main">

        <div class="optitle clearfix">
            <em><input value="添加数据" class="input-button"
                onclick="window.location='userAdd.html'" type="button"></em>
            <div class="title">用户管理&gt;&gt;</div>
        </div>
        <div class="content">
            <table class="list">
                <tbody>
                    <tr>
                        <td width="70" height="29"><div class="STYLE1" align="center">编号</div></td>
                        <td width="80"><div class="STYLE1" align="center">用户名称</div></td>
                        <td width="100"><div class="STYLE1" align="center">性别</div></td>
                        <td width="100"><div class="STYLE1" align="center">年龄</div></td>

                        <td width="150"><div class="STYLE1" align="center">电话</div></td>
                        <td width="150"><div class="STYLE1" align="center">地址</div></td>
                        <td width="150"><div class="STYLE1" align="center">权限</div></td>
                    </tr>

                    <c:forEach items="${ users}" var="user">
                        <tr>
                            <td height="23"><span class="STYLE1"> <c:out
                                        value="${user.uid}"></c:out>
                            </span></td>
                            <td><span class="STYLE1"><a
                                    href="userdetail.jsp?uid=${user.uid}&name=${user.name}&password=${user.password}&usex=${user.usex}&uage=${user.uage}&uaddress=${user.uaddress}&utel=${user.utel}&uissupper=${user.uissupper}">
                                        <c:out value="${user.name}"></c:out>
                                </a></span></td>

                            <td><span class="STYLE1"> <c:out
                                        value="${user.usex==1?'男':'女'}"></c:out>
                            </span></td>
                            <td><span class="STYLE1"> <c:out value="${user.uage}"></c:out>
                            </span></td>
                            <td><span class="STYLE1"> <c:out value="${user.utel}"></c:out>
                            </span></td>
                            <td><span class="STYLE1"> <c:out
                                        value="${user.uaddress}"></c:out>
                            </span></td>
                            <td><span class="STYLE1"> <c:out
                                        value="${user.uissupper==1?'经理':'员工'}"></c:out>
                            </span></td>

                        </tr>
                    </c:forEach>
                </tbody>
            </table>


        </div>
    </div>

    <select id="id1">
        <c:forEach begin="1" end="${pageinfo.pages}" varStatus="st">
            <option value="${pageinfo.pageSize}">
                  ${st.count}
               </option>
        </c:forEach>
    </select>
</body>
    <%@ include file="page.jsp"%>
</html>

注意在最后一行的引用(include标签)

contoller类中:

@RequestMapping("/userlist")
    public String selectAllUsers1(Map<String, Object> map,
            @RequestParam(name = "pageNum", required = true, defaultValue = "0") Integer pageNum) {

        System.out.println("获取用户列表");
        // 访问第一页，pageNum，pageSize的值为0，查询第一页数据，还需要pageinfo信息一并传递到前端页面

        // 第二页。。。
        List<User> users = null;
        PageInfo<User> pageinfo = null;
        if (pageNum == 0 || size == 0) {
            PageHelper.startPage(1, size);
            users = userService.selectAll();

        } else {

            PageHelper.startPage(pageNum, size);
            users = userService.selectAll();

        }
        System.out.println(users);
        pageinfo = new PageInfo<User>(users);

        map.put("users", users);
        map.put("pageinfo", pageinfo);
        System.out.println("获取成功");

        return "userAdmin";
    }