分页

在pom文件中加两个依赖jar包

<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>4.0.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.github.jsqlparser/jsqlparser -->
<dependency>
    <groupId>com.github.jsqlparser</groupId>
    <artifactId>jsqlparser</artifactId>
    <version>0.9.5</version>
</dependency>

mybatis-config.xml 里配置插件：

<!-- 配置分页插件 -->
<plugins>
   <!-- com.github.pagehelper为PageHelper类所在包名 -->
   <plugin interceptor="com.github.pagehelper.PageHelper">
      <!-- 4.0.0以后版本可以不设置该参数 -->
      <property name="dialect" value="mysql"/>

   </plugin>
</plugins>

jsp页面：

注意：（
<c:forEach items="${pagelist.list}" var="s">  用页面list调用原本的list集合
）

共<span>${pagelist.total}条记录当前显示</span><span>现在显示第${pagelist.pageNum}页</span>

<a href="/stock/mhselect.action?pageNo=${pagelist.firstPage}&pageSize=${pagelist.pageSize}" >首页</a>

<c:choose>
    <c:when test="${pagelist.isFirstPage==true}">
        <a href="/stock/mhselect.action?pageNo=${pagelist.firstPage}&pageSize=${pagelist.pageSize}" >上一页</a>

    </c:when>

    <c:otherwise>
        <a href="/stock/mhselect.action?pageNo=${pagelist.prePage}&pageSize=${pagelist.pageSize}" >上一页</a>

    </c:otherwise>

</c:choose>

<c:choose>
    <c:when test="${pagelist.isLastPage==true}">
        <a href="/stock/mhselect.action?pageNo=${pagelist.lastPage}&pageSize=${pagelist.pageSize}" >下一页</a>

    </c:when>

    <c:otherwise>
        <a href="/stock/mhselect.action?pageNo=${pagelist.nextPage}&pageSize=${pagelist.pageSize}" >下一页</a>

    </c:otherwise>

</c:choose>



<a href="/stock/mhselect.action?pageNo=${pagelist.lastPage}&pageSize=${pagelist.pageSize}">尾页</a>

controller不分页的代码

@RequestMapping(value = "/mhselect.action", method = RequestMethod.GET)
public String toall(String stockName, Model model) {
    HashMap<String, Object> map = new HashMap<>();
    System.out.println(stockName);
    List<Stock> list = stockService.mhselect(stockName);
    System.out.println(list);

    model.addAttribute("list", list);

    return "/all";
}
controller分页后的代码：
//查询所有带分页
@RequestMapping(value = "/mhselect.action",method = RequestMethod.GET)
public  String findStockAll(Model model,String pageNo, String pageSize,String stockName){
    /**
     *  * @param pageNum      页码
     * @param pageSize     每页显示数量
     * @param count        是否进行count查询
     * @param reasonable   分页合理化,null时用默认配置
     * @param pageSizeZero true且pageSize=0时返回全部结果，false时分页,null时用默认配置
     */
    int num = 1;
    int size = 3;

    if(pageNo != null && !"".equals(pageNo)) {
        num = Integer.parseInt(pageNo);
    }
    if (pageSize != null && !"".equals(pageSize)) {
        size = Integer.parseInt(pageSize);
    }
    //开始分页
    PageHelper.startPage(num,size);

    //查询数据库信息

    List<Stock> list = stockService.mhselect(stockName);
    System.out.println(list);
    //将信息放入Pagelist进行分页
    PageInfo<Stock> pagelist = new PageInfo<Stock>(list);

    System.out.println(pagelist.getPageNum());
    System.out.println(pagelist.getPageSize());
    System.out.println(pagelist.getTotal());
    System.out.println(pagelist.getFirstPage());
    System.out.println(pagelist.getLastPage());
    System.out.println(pagelist.getPrePage());
    System.out.println(pagelist.getNextPage());

    model.addAttribute("pagelist",pagelist);
    return  "/all";
}