项目中高级查询_分页的一些注意点

红太狼 2023-06-28 06:27 9阅读 0赞

***1.后台实现***  
①PageResult类

import lombok.Getter;
    import lombok.Setter;
    import lombok.ToString;
    import java.util.Collections;
    import java.util.List;
    @Getter
    @Setter
    @ToString
    public class PageResult { 
        private List<?> listData;//分页查询的结果集
        private Integer prevPage;//上一页
        private Integer nextPage;//下一页
        private  Integer currentPage;//当前页
        private Integer pageSize;//页面大小
        private Integer totalCount;//总条数
        private Integer beginPage;//首页
        private Integer totalPage;//总页数
        public  static  PageResult EMPTY_RESULT = new PageResult(Collections.emptyList(),1,5,0);
        public PageResult(List<?> listData, Integer currentPage, Integer pageSize, Integer totalCount) { 
            this.listData = listData;
            this.currentPage = currentPage;
            this.pageSize = pageSize;
            this.totalCount = totalCount;
            this.beginPage=1;
            this.totalPage=this.totalCount%this.pageSize==0?(this.totalCount/this.pageSize):(this.totalCount/this.pageSize+1);
            this.prevPage=this.currentPage==1?1:this.currentPage-1;
            this.nextPage=this.currentPage==this.totalPage?this.totalPage:this.currentPage+1;
        }
    }

②QueryObject类

import lombok.Getter;
    import lombok.Setter;
    import lombok.ToString;
    @Setter@Getter@ToString
    public class EmployeeQueryObject extends QueryObject { 
        private String keywords;
        private Long deptId;
    }

③xxxQueryObject类(自定义的查询条件)

import lombok.Getter;
    import lombok.Setter;
    import lombok.ToString;
    @Setter
    @Getter
    @ToString
    public class QueryObject { 
       private Integer currentPage=1;
       private Integer pageSize=5;
       public Integer getBeginIndex(){ 
           return (currentPage-1)*pageSize;
       }
    }

④service实现类中实现高级查询的方法

public PageResult pageQuery(EmployeeQueryObject qo) { 
            Long totalCount = empMapper.getTotalCount(qo);
            if(totalCount==0){ 
                return  PageResult.EMPTY_RESULT;
            }
            List<Employee> listData = empMapper.getListData(qo);
            return new PageResult(listData,qo.getCurrentPage(),qo.getPageSize(),totalCount.intValue());
        }

⑤前端页面–查询条件+按钮

⑥分页条

⑦相关的js代码

//点击查询时提交表单
        $(".btn_search").click(function(){ 
           /*//得到表单 var searchForm = document.getElementById("searchForm"); //提交表单 submit(searchForm);*/
           $("#searchForm").submit();
        });
        $(".btn_page").click(function(){ 
             //获取到当前页并设置到表单
             //var pageNo = $(this).attr("data-page");
            //使用data()方法来获取到data-xxx的值,等同于上面的
             var pageNo = $(this).data("page")||$("input[name='qo.currentPage']").val();
             $("input[name='qo.currentPage']").val(pageNo);
            //提交表单
            $("#searchForm").submit();
        });
        //页面大小的设置
        $("#pageSize").change(function(){ 
            $("#searchForm").submit();
        });

![在这里插入图片描述][20200107231630976.png]  
![在这里插入图片描述][20200107231642927.png]

[20200107231630976.png]: https://img-blog.csdnimg.cn/20200107231630976.png
[20200107231642927.png]: https://img-blog.csdnimg.cn/20200107231642927.png