分页: 后端代码思路
工具类整理如下:
Controller层:
这里使用:Result类 工具类2 封装数据
public Result selectData(HttpServletRequest request,@RequestBody String param) {
try {
Map<String, Object> paramMap = JsonUtils.readValue(param, Map.class);
return Result.success().result(ListService.selectData(request,paramMap));
} catch (Exception e) {
log.error("ListController selectDatais error===:" + e.getMessage(), e);
return Result.failure("数据查询失败");
}
}
Service层:
PageInfo<Map<String, Object>> selectData(HttpServletRequest request,Map<String, Object> paramMap);
ServiceImpl层:
这里使用:PageInfo类 工具类1 封装数据
import com.github.pagehelper.PageHelper;
public PageInfo<Map<String, Object>> selectData(HttpServletRequest request, Map<String, Object> paramMap) {
if (params.get("pageNum") != null) {
PageHelper.startPage(Integer.parseInt(String.valueOf(params.get("pageNum"))),
Integer.parseInt(String.valueOf(params.get("pageSize"))));
}
// 数据查询
List<Map<String, Object>> list = ListMapper.selectData(paramMap);
// 分页返回
PageInfo<Map<String, Object>> result = new PageInfo<>(list);
return result;
}
Mapper层:
List<Map<String, Object>> selectData(Map<String, Object> paramMap);
Mapper.xml:
<!-- 抽取公共方法 -->
<sql id="selectValue">
<!-- 分页字段 -->
<if test="null != processResult">
and processResult = #{processResult}
</if>
</sql>
<!-- 查询数据 -->
<select id="selectData" parameterType="map" resultType="map">
select * from list_form_data
where 1 = 1
<include refid="selectValue"/>
order by seqID desc
</select>
PageInfo类:
PageInfo类 工具类1:
package com.github.pagehelper;
import java.util.Collection;
import java.util.List;
public class PageInfo<T> extends PageSerializable<T> {
private int pageNum;
private int pageSize;
private int size;
private int startRow;
private int endRow;
private int pages;
private int prePage;
private int nextPage;
private boolean isFirstPage;
private boolean isLastPage;
private boolean hasPreviousPage;
private boolean hasNextPage;
private int navigatePages;
private int[] navigatepageNums;
private int navigateFirstPage;
private int navigateLastPage;
public PageInfo() {
this.isFirstPage = false;
this.isLastPage = false;
this.hasPreviousPage = false;
this.hasNextPage = false;
}
public PageInfo(List<T> list) {
this(list, 8);
}
public PageInfo(List<T> list, int navigatePages) {
super(list);
this.isFirstPage = false;
this.isLastPage = false;
this.hasPreviousPage = false;
this.hasNextPage = false;
if (list instanceof Page) {
Page page = (Page)list;
this.pageNum = page.getPageNum();
this.pageSize = page.getPageSize();
this.pages = page.getPages();
this.size = page.size();
if (this.size == 0) {
this.startRow = 0;
this.endRow = 0;
} else {
this.startRow = page.getStartRow() + 1;
this.endRow = this.startRow - 1 + this.size;
}
} else if (list instanceof Collection) {
this.pageNum = 1;
this.pageSize = list.size();
this.pages = this.pageSize > 0 ? 1 : 0;
this.size = list.size();
this.startRow = 0;
this.endRow = list.size() > 0 ? list.size() - 1 : 0;
}
if (list instanceof Collection) {
this.navigatePages = navigatePages;
this.calcNavigatepageNums();
this.calcPage();
this.judgePageBoudary();
}
}
public static <T> PageInfo<T> of(List<T> list) {
return new PageInfo(list);
}
public static <T> PageInfo<T> of(List<T> list, int navigatePages) {
return new PageInfo(list, navigatePages);
}
private void calcNavigatepageNums() {
int i;
if (this.pages <= this.navigatePages) {
this.navigatepageNums = new int[this.pages];
for(i = 0; i < this.pages; ++i) {
this.navigatepageNums[i] = i + 1;
}
} else {
this.navigatepageNums = new int[this.navigatePages];
i = this.pageNum - this.navigatePages / 2;
int endNum = this.pageNum + this.navigatePages / 2;
int i;
if (i < 1) {
i = 1;
for(i = 0; i < this.navigatePages; ++i) {
this.navigatepageNums[i] = i++;
}
} else if (endNum > this.pages) {
endNum = this.pages;
for(i = this.navigatePages - 1; i >= 0; --i) {
this.navigatepageNums[i] = endNum--;
}
} else {
for(i = 0; i < this.navigatePages; ++i) {
this.navigatepageNums[i] = i++;
}
}
}
}
private void calcPage() {
if (this.navigatepageNums != null && this.navigatepageNums.length > 0) {
this.navigateFirstPage = this.navigatepageNums[0];
this.navigateLastPage = this.navigatepageNums[this.navigatepageNums.length - 1];
if (this.pageNum > 1) {
this.prePage = this.pageNum - 1;
}
if (this.pageNum < this.pages) {
this.nextPage = this.pageNum + 1;
}
}
}
private void judgePageBoudary() {
this.isFirstPage = this.pageNum == 1;
this.isLastPage = this.pageNum == this.pages || this.pages == 0;
this.hasPreviousPage = this.pageNum > 1;
this.hasNextPage = this.pageNum < this.pages;
}
public int getPageNum() {
return this.pageNum;
}
public void setPageNum(int pageNum) {
this.pageNum = pageNum;
}
public int getPageSize() {
return this.pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getSize() {
return this.size;
}
public void setSize(int size) {
this.size = size;
}
public int getStartRow() {
return this.startRow;
}
public void setStartRow(int startRow) {
this.startRow = startRow;
}
public int getEndRow() {
return this.endRow;
}
public void setEndRow(int endRow) {
this.endRow = endRow;
}
public int getPages() {
return this.pages;
}
public void setPages(int pages) {
this.pages = pages;
}
public int getPrePage() {
return this.prePage;
}
public void setPrePage(int prePage) {
this.prePage = prePage;
}
public int getNextPage() {
return this.nextPage;
}
public void setNextPage(int nextPage) {
this.nextPage = nextPage;
}
public boolean isIsFirstPage() {
return this.isFirstPage;
}
public void setIsFirstPage(boolean isFirstPage) {
this.isFirstPage = isFirstPage;
}
public boolean isIsLastPage() {
return this.isLastPage;
}
public void setIsLastPage(boolean isLastPage) {
this.isLastPage = isLastPage;
}
public boolean isHasPreviousPage() {
return this.hasPreviousPage;
}
public void setHasPreviousPage(boolean hasPreviousPage) {
this.hasPreviousPage = hasPreviousPage;
}
public boolean isHasNextPage() {
return this.hasNextPage;
}
public void setHasNextPage(boolean hasNextPage) {
this.hasNextPage = hasNextPage;
}
public int getNavigatePages() {
return this.navigatePages;
}
public void setNavigatePages(int navigatePages) {
this.navigatePages = navigatePages;
}
public int[] getNavigatepageNums() {
return this.navigatepageNums;
}
public void setNavigatepageNums(int[] navigatepageNums) {
this.navigatepageNums = navigatepageNums;
}
public int getNavigateFirstPage() {
return this.navigateFirstPage;
}
public int getNavigateLastPage() {
return this.navigateLastPage;
}
public void setNavigateFirstPage(int navigateFirstPage) {
this.navigateFirstPage = navigateFirstPage;
}
public void setNavigateLastPage(int navigateLastPage) {
this.navigateLastPage = navigateLastPage;
}
public String toString() {
StringBuilder sb = new StringBuilder("PageInfo{");
sb.append("pageNum=").append(this.pageNum);
sb.append(", pageSize=").append(this.pageSize);
sb.append(", size=").append(this.size);
sb.append(", startRow=").append(this.startRow);
sb.append(", endRow=").append(this.endRow);
sb.append(", total=").append(this.total);
sb.append(", pages=").append(this.pages);
sb.append(", list=").append(this.list);
sb.append(", prePage=").append(this.prePage);
sb.append(", nextPage=").append(this.nextPage);
sb.append(", isFirstPage=").append(this.isFirstPage);
sb.append(", isLastPage=").append(this.isLastPage);
sb.append(", hasPreviousPage=").append(this.hasPreviousPage);
sb.append(", hasNextPage=").append(this.hasNextPage);
sb.append(", navigatePages=").append(this.navigatePages);
sb.append(", navigateFirstPage=").append(this.navigateFirstPage);
sb.append(", navigateLastPage=").append(this.navigateLastPage);
sb.append(", navigatepageNums=");
if (this.navigatepageNums == null) {
sb.append("null");
} else {
sb.append('[');
for(int i = 0; i < this.navigatepageNums.length; ++i) {
sb.append(i == 0 ? "" : ", ").append(this.navigatepageNums[i]);
}
sb.append(']');
}
sb.append('}');
return sb.toString();
}
}
PageInfo类 工具类2:
import java.util.ArrayList;
import java.util.List;
/**
* 功能:分页工具类
*/
public class PageBean<T> {
private int pageSize; // 每页记录数
private int pageNo; // 当前页
private int totalPages; // 总页数
private int totalRecords; // 总记录数
private List<T> list;
public int getPageSize() {
return pageSize;
}
// 设置每页记录数
public void setPageSize(int pageSize) {
if (pageSize > 0) {
this.pageSize = pageSize;
} else {
this.pageSize = 10;
}
}
public int getPageNo() {
return pageNo;
}
// 设置当前页
public void setPageNo(int pageNo) {
if (pageNo <= 1) {
this.pageNo = 1;
} else if (pageNo > this.totalPages) {
this.pageNo = this.totalPages;
} else {
this.pageNo = pageNo;
}
}
public int getTotalPages() {
return totalPages;
}
// 设置总页数
public void setTotalPages() {
this.totalPages = this.totalRecords % this.pageSize == 0 ? this.totalRecords / this.pageSize
: this.totalRecords / this.pageSize + 1;
}
public int getTotalRecords() {
return totalRecords;
}
// 设置总记录数
public void setTotalRecords(int totalRecords) {
if (totalRecords >= 0) {
this.totalRecords = totalRecords;
} else {
this.totalRecords = 0;
}
}
public List<T> getList() {
return list;
}
public void setList(List<T> list) {
this.list = list;
}
// 当前页记录列表
public void queryPager(int pageNo, int pageSize, List<T> list) {
// 设置总记录数
if (list != null && list.size() != 0) {
this.setTotalRecords(list.size());
} else {
this.setTotalRecords(0);
}
// 设置每页记录数
this.setPageSize(pageSize);
// 设置总页数
this.setTotalPages();
// 设置当前页
this.setPageNo(pageNo);
// 设置当前页记录数
if (list != null && list.size() != 0) {
if (pageNo == this.totalPages) {
this.list = list.subList((pageNo - 1) * pageSize, this.totalRecords);
} else {
this.list = list.subList((pageNo - 1) * pageSize, pageNo * pageSize);
}
} else {
this.list = new ArrayList<>();
}
}
public boolean isPrePage() {
if (this.pageNo > 1) {
return true;
}
return false;
}
public boolean isNextPage() {
if (this.pageNo < this.totalPages) {
return true;
}
return false;
}
public int getPrePageNo() {
if (isPrePage()) {
return this.pageNo - 1;
}
return this.pageNo;
}
public int getNextPageNo() {
if (isNextPage()) {
return this.pageNo + 1;
}
return this.pageNo;
}
}
Controller层使用:PageInfo类 工具类2:
public PageBean authorRankingList(@RequestParam(value = "page", defaultValue = "1") Integer page,
@RequestParam(value = "pageSize", defaultValue = "20") Integer pageSize) {
List<HelpcenterArticle> list = helpcenterArticleService.queryAuthorInfoList();
if (CollectionUtils.isNotEmpty(list)) {
PageBean<HelpcenterArticle> bean = new PageBean<>();
bean.queryPager(page, pageSize, list);
return bean;
}
return null;
}
Result类:返回前端的Result对象
Result类 工具类1:
import com.google.gson.Gson;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import java.io.Serializable;
@ApiModel("响应对象")
public class Result<T> implements Serializable {
private static final long serialVersionUID = -8614669828681890797L;
public static final int SUCCESS = 1;
public static final int FAIL = 0;
@ApiModelProperty(
value = "结果码",
dataType = "Integer",
required = true
)
private int status;
@ApiModelProperty(
value = "结果描述",
dataType = "String",
required = true
)
private String message;
@ApiModelProperty("响应数据对象")
private T data;
public Result() {
}
public Result(int status, String message) {
this.status = status;
this.message = message;
this.data = null;
}
public Result(T data) {
this.status = 1;
this.message = "SUCCESS";
this.data = data;
}
public Result(int status, T data, String message) {
this.status = status;
this.data = data;
this.message = message;
}
@Override
public String toString() {
Gson gson = new Gson();
return gson.toJson(this);
}
public static <T> Result<T> custom(int status, T t, String message) {
return new Result(status, t, message);
}
public static <T> Result<T> custom(int status, String message) {
return new Result(status, message);
}
public static <T> Result<T> success(T t, String message) {
return new Result(1, t, message);
}
public static <T> Result<T> success(String message) {
return new Result(1, message);
}
public static <T> Result<T> fail(T t, String message) {
return new Result(0, t, message);
}
public static <T> Result<T> fail(String message) {
return new Result(0, message);
}
public static Result<String> success() {
return new Result(1, "OK");
}
public static Result<String> fail() {
return new Result(0, "FAIL");
}
public int getStatus() {
return this.status;
}
public String getMessage() {
return this.message;
}
public T getData() {
return this.data;
}
public void setStatus(int status) {
this.status = status;
}
public void setMessage(String message) {
this.message = message;
}
public void setData(T data) {
this.data = data;
}
}
Result类 工具类2:
import com.itheima.tools.constants.ResultStatusEnum;
import java.beans.ConstructorProperties;
import java.io.Serializable;
import java.util.HashMap;
import java.util.Map;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.http.HttpStatus;
public final class Result<T> implements Serializable {
private static final Logger log = LoggerFactory.getLogger(Result.class);
private static final long serialVersionUID = 3567653491060394677L;
private T data;
private int code;
private String message;
public Result result(T data) {
this.setData(data);
return this;
}
public Result result(String key, String value) {
Map<String, Object> rst = new HashMap();
rst.put(key, value);
return builder().data(rst).build();
}
public static Result success() {
return builder().code(HttpStatus.OK.value()).message(HttpStatus.OK.getReasonPhrase()).build();
}
public static Result success(ResultStatusEnum resultStatusEnum) {
return builder().code(resultStatusEnum.getCode()).message(resultStatusEnum.getMsg()).build();
}
public static Result failure() {
return builder().code(HttpStatus.INTERNAL_SERVER_ERROR.value()).message(HttpStatus.INTERNAL_SERVER_ERROR.getReasonPhrase()).build();
}
public static Result failure(HttpStatus error) {
return builder().code(error.value()).message(error.getReasonPhrase()).build();
}
public static Result failure(String message) {
return builder().code(HttpStatus.INTERNAL_SERVER_ERROR.value()).message(message).build();
}
public static Result failure(ResultStatusEnum resultStatusEnum) {
return builder().code(resultStatusEnum.getCode()).message(resultStatusEnum.getMsg()).build();
}
public static Result failure(int code, String message) {
return builder().code(code).message(message).build();
}
@ConstructorProperties({"data", "code", "message"})
Result(T data, int code, String message) {
this.data = data;
this.code = code;
this.message = message;
}
public static <T> Result.ResultBuilder<T> builder() {
return new Result.ResultBuilder();
}
public T getData() {
return this.data;
}
public int getCode() {
return this.code;
}
public String getMessage() {
return this.message;
}
public void setData(T data) {
this.data = data;
}
public void setCode(int code) {
this.code = code;
}
public void setMessage(String message) {
this.message = message;
}
public boolean equals(Object o) {
if (o == this) {
return true;
} else if (!(o instanceof Result)) {
return false;
} else {
Result<?> other = (Result)o;
Object this$data = this.getData();
Object other$data = other.getData();
if (this$data == null) {
if (other$data != null) {
return false;
}
} else if (!this$data.equals(other$data)) {
return false;
}
if (this.getCode() != other.getCode()) {
return false;
} else {
Object this$message = this.getMessage();
Object other$message = other.getMessage();
if (this$message == null) {
if (other$message != null) {
return false;
}
} else if (!this$message.equals(other$message)) {
return false;
}
return true;
}
}
}
public int hashCode() {
int PRIME = true;
int result = 1;
Object $data = this.getData();
int result = result * 59 + ($data == null ? 43 : $data.hashCode());
result = result * 59 + this.getCode();
Object $message = this.getMessage();
result = result * 59 + ($message == null ? 43 : $message.hashCode());
return result;
}
public String toString() {
return "Result(data=" + this.getData() + ", code=" + this.getCode() + ", message=" + this.getMessage() + ")";
}
public static class ResultBuilder<T> {
private T data;
private int code;
private String message;
ResultBuilder() {
}
public Result.ResultBuilder<T> data(T data) {
this.data = data;
return this;
}
public Result.ResultBuilder<T> code(int code) {
this.code = code;
return this;
}
public Result.ResultBuilder<T> message(String message) {
this.message = message;
return this;
}
public Result<T> build() {
return new Result(this.data, this.code, this.message);
}
public String toString() {
return "Result.ResultBuilder(data=" + this.data + ", code=" + this.code + ", message=" + this.message + ")";
}
}
}