MyBatis PageHelper 分页插件 + JSP 实现员工列表分页

以下是使用MyBatis PageHelper插件配合JSP页面实现员工表的分页的代码示例：\n\n1. 引入PageHelper依赖和JSTL标签库：\n在pom.xml中添加以下依赖：\nxml\n<dependency>\n <groupId>com.github.pagehelper</groupId>\n <artifactId>pagehelper</artifactId>\n <version>5.2.0</version>\n</dependency>\n\n在JSP页面中引入JSTL标签库：\njsp\n<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>\n\n\n2. 在MyBatis配置文件中配置PageHelper插件：\nxml\n<plugins>\n <plugin interceptor="com.github.pagehelper.PageInterceptor">\n <property name="helperDialect" value="mysql"/>\n <property name="reasonable" value="true"/>\n </plugin>\n</plugins>\n\n\n3. 在Controller中获取员工列表并进行分页：\njava\nimport com.github.pagehelper.PageHelper;\nimport com.github.pagehelper.PageInfo;\nimport org.springframework.stereotype.Controller;\nimport org.springframework.ui.Model;\nimport org.springframework.web.bind.annotation.GetMapping;\n\nimport javax.annotation.Resource;\nimport java.util.List;\n\n@Controller\npublic class EmployeeController {\n\n @Resource\n private EmployeeService employeeService;\n\n @GetMapping("/employees")\n public String getEmployees(Model model, Integer pageNum, Integer pageSize) {\n // 设置分页参数\n if (pageNum != null && pageSize != null) {\n PageHelper.startPage(pageNum, pageSize);\n }\n\n // 获取员工列表\n List<Employee> employees = employeeService.getEmployees();\n\n // 封装分页结果\n PageInfo<Employee> pageInfo = new PageInfo<>(employees);\n\n // 将分页结果传递给JSP页面\n model.addAttribute("pageInfo", pageInfo);\n\n return "employee-list";\n }\n}\n\n\n4. 在JSP页面中显示员工列表和分页信息：\njsp\n<%@ page contentType="text/html;charset=UTF-8" language="java" %>\n<html>\n<head>\n <title>员工列表</title>\n</head>\n<body>\n <h1>员工列表</h1>\n\n <table>\n <tr>\n <th>ID</th>\n <th>姓名</th>\n <th>职位</th>\n </tr>\n <c:forEach items="${pageInfo.list}" var="employee">\n <tr>\n <td>${employee.id}</td>\n <td>${employee.name}</td>\n <td>${employee.position}</td>\n </tr>\n </c:forEach>\n </table>\n\n <div>\n <c:if test="${pageInfo.hasPreviousPage}">\n <a href="?pageNum=${pageInfo.prePage}&pageSize=${pageInfo.pageSize}">上一页</a>\n </c:if>\n\n <c:if test="${pageInfo.hasNextPage}">\n <a href="?pageNum=${pageInfo.nextPage}&pageSize=${pageInfo.pageSize}">下一页</a>\n </c:if>\n </div>\n</body>\n</html>\n\n\n以上代码示例展示了如何使用MyBatis PageHelper插件配合JSP页面实现员工表的分页功能。其中，Controller中的getEmployees方法接收pageNum和pageSize参数来进行分页，然后将分页结果传递给JSP页面进行展示。JSP页面使用JSTL标签库来遍历员工列表和生成分页导航链接。