mybatis分页查询

最新推荐文章于 2025-05-02 13:24:53 发布

原创最新推荐文章于 2025-05-02 13:24:53 发布 · 132 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis

mybatis 专栏收录该内容

4 篇文章

订阅专栏

maven项目引入bootStrap的方式

坐标

          <dependency>
            <groupId>org.webjars</groupId>
            <artifactId>bootstrap</artifactId>
            <version>3.3.5</version>
        </dependency>

引入

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
    <title>Title</title>
    <script src="webjars/jquery/3.1.1/jquery.min.js"></script>
    <script src="webjars/bootstrap/3.3.5/js/bootstrap.min.js"></script>
    <link href="webjars/bootstrap/3.3.5/css/bootstrap.min.css" rel="stylesheet">

1.导入PageHelper的坐标

    <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>5.1.2</version>
    </dependency>

    <dependency>
      <groupId>com.github.jsqlparser</groupId>
      <artifactId>jsqlparser</artifactId>
      <version>1.2</version>
    </dependency>

2.在mybatis核心配置文件中配置分页插件，告诉mybatis用的是哪个数据库的分页

    <plugins>
        <plugin interceptor="com.github.pagehelper.PageHelper">
            <property name="dialect" value="mysql"/>
        </plugin>
    </plugins>

测试

版本不匹配的问题

https://blog.youkuaiyun.com/sinat_34104446/article/details/92679046

<plugins>
	<!-- PageHelper4版本插件配置 -->
	<plugin interceptor="com.github.pagehelper.PageHelper"/>
</plugins>
<!-- PageHelper4版本依赖 -->
<dependency>
	<groupId>com.github.pagehelper</groupId>
	<artifactId>pagehelper</artifactId>
	<version>4.1.6</version>
</dependency
 
---------------------------------------------------------------------
 
<plugins>
	<!-- PageHelper5版本配置 -->
	<plugin interceptor="com.github.pagehelper.PageInterceptor"/>
</plugins>
<!-- PageHelper5版本依赖 -->
<dependency>
	<groupId>com.github.pagehelper</groupId>
	<artifactId>pagehelper</artifactId>
	<version>5.1.6</version>
</dependency>

UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bbu.mapper.UserMapper">
      <select id="findAllUser" parameterType="user" resultMap="userMap">
        SELECT u.id,user_name,pass_word,birthday,sex,deptName
        FROM tb_user u LEFT JOIN tb_dept d
        ON d.id = u.deptId
       </select>
    <resultMap id="userMap" type="user">
        <id property="id" column="id"></id>
        <result property="userName" column="user_name"></result>
        <result property="passWord" column="pass_word"></result>
        <result property="birthday" column="birthday"></result>
        <result property="sex" column="sex"></result>
        <association property="dept" javaType="dept">
            <result property="deptName" column="deptName"></result>
        </association>
    </resultMap>

    <select id="checkUsername" resultType="user" parameterType="string">
        select username from tb_user where username = #{username}
    </select>
</mapper>

控制层

    @RequestMapping("/findAllUser")
    public String findAllUser(@RequestParam(required = false,defaultValue = "1")int pageNum, Model model){
        PageHelper.startPage(pageNum,3);
        List<User> userList = userService.findAllUser(null);
        PageInfo<User> pageInfo = new PageInfo<>(userList);
        model.addAttribute("userList",userList);
        model.addAttribute("pageInfo",pageInfo);
        return "user/userList";
    }

view层

<%--
  Created by IntelliJ IDEA.
  User: y
  Date: 2021/4/24
  Time: 12:10
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<html>
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
    <title>Title</title>
    <script src="webjars/jquery/3.1.1/jquery.min.js"></script>
    <script src="webjars/bootstrap/3.3.5/js/bootstrap.min.js"></script>
    <link href="webjars/bootstrap/3.3.5/css/bootstrap.min.css" rel="stylesheet">
    <script>
        $(document).ready(function () {
            $("#pageCut").html("");
            $("#pageCut").append("        <li>\n" +
                "                <a href=\"findAllUser?pageNum=${pageInfo.pageNum-1 < 1?1:pageInfo.pageNum-1}\" aria-label=\"Previous\">\n" +
                "                    <span aria-hidden=\"true\">&laquo;</span>\n" +
                "                </a>\n" +
                "            </li>")
            $("#pageCut").append()
            for (var i = 1; i <= ${pageInfo.pages}; i++) {
                $("#pageCut").append(
                    "<li><a href='findAllUser?pageNum="+i+"'>"+i+"</a></li>"
                );
            }
            $("#pageCut").append("            <li>\n" +
                "                <a href=\"findAllUser?pageNum=${pageInfo.pageNum+1 > pageInfo.pages?pageInfo.pages:pageInfo.pageNum+1}\" aria-label=\"Next\">\n" +
                "                    <span aria-hidden=\"true\">&raquo;</span>\n" +
                "                </a>\n" +
                "            </li>")
        })
    </script>
<body>
<form>
    <table class="table table-bordered" style="width: 80%;">
        <tr>
            <td class="warning">序号</td>
            <td class="warning">用户名</td>
            <td class="warning">密码</td>
            <td class="warning">性别</td>
            <td class="warning">生日</td>
            <td class="warning">部门</td>
        </tr>
        <c:forEach var="user" items="${requestScope.userList}" varStatus="status">
            <tr>
                <td class="success">${status.count}</td>
                <td class="success">${user.userName}</td>
                <td class="success">${user.passWord}</td>
                <td class="success">${user.sex == 1?"男":"女"}</td>
                <td class="success">${user.birthday}</td>
                <td class="success">${user.dept.deptName}</td>
            </tr>
        </c:forEach>
    </table>
    <nav aria-label="Page navigation">
        <ul class="pagination" id="pageCut">
            <li>
                <a href="findAllUser?pageNum=${pageInfo.pageNum-1 < 1?1:pageInfo.pageNum-1}" aria-label="Previous">
                    <span aria-hidden="true">&laquo;</span>
                </a>
            </li>
            <li>
                <a href="findAllUser?pageNum=${pageInfo.pageNum+1 > pageInfo.pages?pageInfo.pages:pageInfo.pageNum+1}" aria-label="Next">
                    <span aria-hidden="true">&raquo;</span>
                </a>
            </li>
        </ul>
    </nav>
</form>
</body>
</html>

效果：