插件-pageHelper

1、引入jar包：
pagehelper-5.0.3.jar
jsqlparser-0.9.5.jar
2、编写配置：
mybatis-config.xml

    <plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
    </plugins>

3、写代码
TeacherController.java

package com.atguigu.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import com.atguigu.bean.Teacher;
import com.atguigu.service.TeacherService;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;

@Controller
public class TeacherController {
    
    @Autowired
    TeacherService teacherService;
    
    @RequestMapping("/getall")
    public String getAll(@RequestParam(value="pn",defaultValue="1")Integer pn,Model model){
        //紧跟他的查询就是一个分页查询
        PageHelper.startPage(pn, 5);
        List<Teacher> list = teacherService.getAll();
        
        //我们可以将查询的结果使用；将查询的结果放在pageinfo中这个pageInfo就有非常多能够用的
        //第二份传入连续要显示的页码
        PageInfo<Teacher> info = new PageInfo<>(list, 6);
        System.out.println("当前页码："+info.getPageNum());
        System.out.println("总页码："+info.getPages());
        System.out.println("总记录数："+info.getTotal());
        System.out.println("当前页有几条记录："+info.getSize());
        System.out.println("当前页的pageSize："+info.getPageSize());
        System.out.println("前一页："+info.getPrePage());
        System.out.println("结果："+info.getList());//查询结果
        int[] nums = info.getNavigatepageNums();
        
        model.addAttribute("info", info);
        return "success";
    }

}

TeacherService.java

    @Autowired
    private TeacherDao teacherDao;

    public List<Teacher> getAll() {
        
        return teacherDao.getTeachers();
    }

TeacherDao.xml

    <!--public List<Teacher> getTeachers();  -->
    <select id="getTeachers" resultMap="teacherMap">
        select * from t_teacher
    </select>

success.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@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=UTF-8">
<title>Insert title here</title>
</head>
<body>
    <h1>成功！</h1>
    <table cellpadding="5" cellspacing="0" border="1">
        <tr>
            <th>id</th>
            <th>name</th>
            <th>course</th>
            <th>address</th>
        </tr>
        <c:forEach items="${info.list}" var="tea">
            <tr>
                <td>${tea.id }</td>
                <td>${tea.name }</td>
                <td>${tea.course }</td>
                <td>宝安区</td>
            </tr>
        </c:forEach>
        <tr>
            <td colspan="4">
                <a href="getall?pn=1">首页</a><a href="getall?pn=${info.prePage }">上一页</a> 
                
                <c:forEach items="${info.navigatepageNums}" var="num">
                    <c:if test="${num == info.pageNum }">
                            【${num }】
                    </c:if>
                    <c:if test="${num != info.pageNum }">
                            <a href="getall?pn=${num }">${num }</a>
                    </c:if>
                </c:forEach>
                
                <a href="getall?pn=${info.nextPage }">下一页</a><a href="getall?pn=${info.pages }">末页</a>
            
            </td>
        </tr>
    </table>
    
</body>
</html>

这里用了标签<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>