ssm使用pagehelper插件进行分页操作

分页插件不需要进行编写分页sql语句

1.  导入插件pagehelper坐标

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

2.  在spring配置文件里加入插件配置，注意  是在SqlSessionFactoryBean里面加

        <property name="plugins">
            <array>
                <bean class="com.github.pagehelper.PageInterceptor">
                    <property name="properties">
                       <value>

                       </value>
                    </property>
                </bean>
            </array>
        </property>

3.  编写工具类

public class util {

    // 当前页数,默认为第一页
    private int page = 1;

    // 要查询的记录数，默认一次查询3条记录
    private int size = 3;

    //get and set 方法省略
}

4.  在service层加入接口

PageInfo<需要分页的对象> findAll(util u);

5. serviceImpl实现类

    public PageInfo<Job> findAll(util u) {
		int Page = u.getPage();
		int Size = u.getSize();

		PageHelper.startPage(Page, Size);
		List<Job> blogs = jobInf.findAll();
		//用PageInfo对结果进行包装
		PageInfo<Job> pageInfo = new PageInfo(blogs);
		return pageInfo;
	}

6.  controller层

@RequestMapping("/findJobInf")
	public String findJobInf(util u, Model model) {
		//PageInfo是前面pom导入的插件类
		PageInfo<Job> pageInfo = jobInfService.findAll(u);
		List<Job> joblist = pageInfo.getList();
		model.addAttribute("jobModel",joblist);
		model.addAttribute("pageInfo",pageInfo);

		return "jobPage/qureyJob";
	}

jsp 界面 基本上都是对象 点 方法 ，更多参数自行baidu

        <ul>
            <li>本次检索&nbsp${pageInfo.total}&nbsp条数据</li>
            <li>共&nbsp${pageInfo.pages}&nbsp页</li>
            <li>当前第&nbsp${pageInfo.pageNum}&nbsp页</li>
            <li>
                <c:if test="${pageInfo.isFirstPage == true}">
                    <a>首页</a>
                </c:if>
                <c:if test="${pageInfo.isFirstPage == false}">
                    <a href="${ctx}/Job/findJobInf?page=1">首页</a>
                </c:if>
            </li>
            <li>
                <c:if test="${pageInfo.hasPreviousPage == false}">
                    上一页
                </c:if>
                <c:if test="${pageInfo.hasPreviousPage == true}">
                    <a href="${ctx}/Job/findJobInf?page=${pageInfo.pageNum-1}">上一页</a>
                </c:if>
            </li>
            <li>
                <c:if test="${pageInfo.hasNextPage == false}">
                    下一页
                </c:if>
                <c:if test="${pageInfo.hasNextPage == true}">
                    <a href="${ctx}/Job/findJobInf?page=${pageInfo.pageNum+1}">下一页</a>
                </c:if>
            </li>
            <li>
                <c:if test="${pageInfo.isLastPage == true}">
                    <a>尾页</a>
                </c:if>
                <c:if test="${pageInfo.isLastPage == false}">
                    <a href="${ctx}/Job/findJobInf?page=${pageInfo.pages}">尾页</a>
                </c:if>
            </li>
        </ul>