在日常开发中,对数据的分页实现是在所难免的,而分页可以通过原始的方法来实现,也可以使用相应的分页插件。
Idea工程目录如下:
实体类:
数据库字段类:
package com.per.springtest.entity;
import lombok.Data;
/**
* Created with IntelliJ IDEA.
*
* @author mark
* @Date: 2020-2-28
*/
@Data
public class Sales {
private String cstName;
private String goods;
private String name;
private String status;
}
前端请求参数实体类:
package com.per.springtest.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
/**
* Created with IntelliJ IDEA.
*
* @author mark
* @Date: 2020-2-28
*/
@Data
@NoArgsConstructor
@AllArgsConstructor
public class SalesParam {
private String cstName;
private String goods;
private String name;
//起始页
private int start;
//结束页
private int end;
//请求页
private int page;
//请求数据量
private int pageSize;
}
前端请求后返回的结果类:
package com.per.springtest.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.List;
/**
* Created with IntelliJ IDEA.
*
* @author mark
* @Date: 2020-2-28
*/
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Result {
//状态码 0表示成功返回数据 1为查询到数据
private String statusCode;
List<Object> data;
}
dao层实现(数据访问):
package com.per.springtest.dao;
import com.per.springtest.entity.SalesParam;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
/**
* Created with IntelliJ IDEA.
*
* @author mark
* @Date: 2020-2-28
*/
@Repository
public interface SalesDao {
List<Object> getSaleList(SalesParam param);
}
service层代码实现:
package com.per.springtest.service;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.per.springtest.dao.SalesDao;
import com.per.springtest.entity.Res