vue分页+spring boot +分页插件pagehelper
后端代码
pom.xml中加入分页插件依赖
<!-- 分页插件 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.3</version>
</dependency
page工具类
@Data
public class PageBean implements Serializable {
private long total;//总页数
private List<ViewMaterial> rows;//记录数
public PageBean(long total,List<ViewMaterial> rows){
this.total = total;
this.rows = rows;
}
}
其中ViewMaterial是一个实体类
Mapper接口层:MaterialMapper.java
Page<ViewMaterial> findByPage();
实现接口:MaterialMapper.xml
<select id="findByPage" resultType="com.gzdh.shangchao.model.ViewMaterial">
select * FROM ViewMaterial ORDER BY pkid
</select>
服务接口层:MaterialServer.java
PageBean findByPage(int pageCode, int pageSize);
实现服务接口层:MaterialServerImpl.java
public PageBean findByPage(int pageCode,int pageSize){
//使用Mybatis分页插件
PageHelper.