springboot内置分页技术

1,在pom.xml中注入分页的配置

<dependency>

        <groupId>com.github.pagehelper</groupId>

        <artifactId>pagehelper</artifactId>

        <version>4.1.0</version>

    </dependency>

2,定义公共实体类,包含页码,页尺寸

import java.io.Serializable;

import com.github.pagehelper.PageHelper;

public abstract class AbstractPageForm<T extends AbstractPageForm<T>> implements Serializable {

    private static final long serialVersionUID = 1L;

    /**

     * @Description 页码为首页

     */

    protected int pageNum = 1;

    /**

     * @Description 每页显示数量，默认为5

     */

    protected int pageSize = 10;

    public int getPageNum() {

        return pageNum;

    }

    public void setPageNum(int pageNum) {

        this.pageNum = pageNum;

    }

    public int getPageSize() {

        return pageSize;

    }

    public void setPageSize(int pageSize) {

        this.pageSize = pageSize;

    }

    /**

     * @Title enablePaging

     * @Description 启用分页

     * @return

     */

    @SuppressWarnings("unchecked")

    public final T enablePaging() {

        PageHelper.startPage(pageNum, pageSize);

        return (T) this;

    }

}

import java.util.Properties;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import com.github.pagehelper.PageHelper;

@Configuration

public class PageBean{

    @Bean

    public PageHelper pageHelper() {

         PageHelper pageHelper = new PageHelper();

         Properties p = new Properties();

         p.setProperty("offsetAsPageNum", "true");

         p.setProperty("rowBoundsWithCount", "true");

         p.setProperty("reasonable", "true");

         pageHelper.setProperties(p);

         return pageHelper;

    }

}

3,定义分页查询条件的VO,要继承AbstractPageForm注意<>中要与继承类保持一致

import com.ulic.gis.util.paging.AbstractPageForm;

public class RolePageVO extends AbstractPageForm<RolePageVO>{

    private static final long serialVersionUID = 1L;

    private String roleName;

    public String getRoleName() {

        return roleName;

    }

    public void setRoleName(String roleName) {

        this.roleName = roleName;

    }

}

4,controller层的关键分页代码

    @RequestMapping(value="/findAllRole")

    public ModelAndView findAllRole(HttpServletRequest request,HttpServletResponse response,@ModelAttribute RolePageVO rolePageVO){

        ModelAndView mav = new ModelAndView();

        log.info("rolePageVO:{}",JSONUtils.object2json(rolePageVO));

        PageHelper.startPage(rolePageVO.getPageNum(), rolePageVO.getPageSize());

        List<RoleVO> roleList = roleManageService.getRoleByparam(rolePageVO);

        PageInfo<RoleVO> rolePageList = new PageInfo<>(roleList);

        mav.addObject("roleList", rolePageList);

        mav.addObject("rolePageVO",rolePageVO);

        mav.setViewName("/authorityManage/roleInfoList");

        return mav;

    }

此处需要注意,上面粉红色查询代码必须放在两行红色代码之间,且只能有一条查询语句。如果出现多条查询语句，则只给第一条查询语句分页。

5，jsp页面中通过下面的方式去除分页数据

PageInfo<RoleVO> info = (PageInfo<RoleVO>)request.getAttribute("roleList");

List<RoleVO> roleList = info.getList(); //分页数据

RolePageVO conditionVo = (RolePageVO)request.getAttribute("rolePageVO");//参数

巴特西

springboot内置分页技术

最新文章

热门文章