Springboot 分页

//分页返回类

@ApiModel(value ="分页内容", description ="分页数据返回内容")

public class PageRsp{

@ApiModelProperty(value ="数据总数", example ="6")

private Integertotal =0;

    @ApiModelProperty(value ="每页大小", example ="10")

private IntegerpageSize =0;

    @ApiModelProperty(value ="当前页码", example ="1")

private IntegerpageNo =1;

    @ApiModelProperty(value ="数据")

private Listlist =new LinkedList<>();

    public IntegergetTotal() {

return total;

    }

public void setTotal(Integer total) {

this.total = total;

    }

public IntegergetPageSize() {

return pageSize;

    }

public void setPageSize(Integer pageSize) {

this.pageSize = pageSize;

    }

public IntegergetPageNo() {

return pageNo;

    }

public void setPageNo(Integer pageNo) {

this.pageNo = pageNo;

    }

public ListgetList() {

return list;

    }

public void setList(List list) {

this.list = list;

    }

}

public CommonRsp>getEvaluationTaskList(

@ApiParam(value ="查询起始时间，如：1900-01-01 00:00:00")@RequestParam(defaultValue ="1900-01-01 00:00:00") Date startTime,

        @ApiParam(value ="查询结束时间，如：2100-01-01 00:00:00")@RequestParam(defaultValue ="2100-01-01 00:00:00") Date endTime,

        @ApiParam(value ="当前页码，如：1")@RequestParam(defaultValue ="1") Integer pageNo,

        @ApiParam(value ="每页大小，如：10")@RequestParam(defaultValue ="10") Integer pageSize,

        @ApiParam(value ="任务类型")@RequestParam(required =false) String type,

        @ApiParam(value ="模糊查询条件，如：王鸿凯")@RequestParam(required =false) String search,

        @ApiParam(value ="是否展示待评价的任务")@RequestParam(defaultValue ="true")boolean isWaitEval,

        @ApiParam(value ="是否展示已评价的任务")@RequestParam(defaultValue ="true")boolean isFinishEval

) {

PageRsp pageRsp;

    if(!isFinishEval && !isWaitEval ) {

pageRsp =new PageRsp<>();

        pageRsp.setPageSize(pageSize);

        pageRsp.setPageNo(pageNo);

        return new CommonRsp<>(pageRsp);

    }

pageRsp =evaluateService.selectEvaluation(startTime,endTime,pageNo,pageSize,type,search,isWaitEval,isFinishEval);

    return new CommonRsp<>(pageRsp);//通用返回类中接分页类

}

int offset = (pageNum -1) * pageSize;//从第几条数据开始查询

String id = RequestContextUtil.getUserId();

evaluationTaskVOS =evaluateMapper.selectEvaluation(startTime,endTime,pageSize,offset,type,search,isWaitEval,isFinishEval, id);

//查询语句

order by t.create_time asc

limit #{limit} offset #{offset}