Spring Boot 利用Pageable插件实现分页和查询
Spring Boot 利用Pageable插件实现分页和查询Pageable 是springData库中定义的一个接口,该接口是所有分页相关信息的一个抽象,通过该接口,我们可以得到和分页相关所有信息(例如pageNumber、pageSize等)。Pageable定义了很多方法,但其核心的信息只有两个:一是分页的信息(page、size),二是排序的信息第一步在Dao包中书写个数据库的接口@Qu
·
Spring Boot 利用Pageable插件实现分页和查询
Pageable
是spring
Data
库中定义的一个接口,该接口是所有分页相关信息的一个抽象,通过该接口,我们可以得到和分页相关所有信息(例如pageNumber
、pageSize
等)。Pageable
定义了很多方法,但其核心的信息只有两个:一是分页的信息(page
、size
),二是排序的信息
第一步
在需要分页的Dao层接口中编辑接口方法
@Query(value="select * from student inner join classes on classes.cid=student.sid",nativeQuery=true)
Page<List<Map>> findPage(Pageable pageable);
为什么书写这个page<List<?>>这个返回值呢?
- 将数据交给page类来分页处理
- 在显示页面有首页,上一页,下一页,尾页吧,这个就是原因了
第二步
在service
层中实现调用之前定义的Dao
层接口
public Page<List<Map>> findPage(Pageable pageable){
return studentDao.findPage(pageable);
}
第三步
这一步就是在控制层(controller
)中编写
// 分页
@RequestMapping("/findPage")
public String findByPage(Model model, Integer pageNum){
// 当前页面为空时,赋值为一,代表是当前为第一页
if(pageNum==null){
pageNum=1;
}
Pageable pageable=PageRequest.of(pageNum-1,5);
Page<List<Map>> page=serviceStudent.findPage(pageable);
model.addAttribute("pageInfo",page);
return "index";
}
PageRequest.of(int PageNum,int PageSize):
用来设置页数和每页中显示的数据条数。
int PageNum:
页数int PageSize:
每页显示的数据条数
PageInfo:
接收后端接口中的数据,渲染给显示界面。
第四步
现在我们在postman
当中请求,看看接口给我返回的数据我们分析下
pageSize:
每页显示的数据条数;
PageNumber:
页数
totalPages:
总页数
totalElements:
总条数
<ul>
当前第 <span th:text="${pageInfo.number}+1"></span>页 |
总 <span th:text="${pageInfo.totalPages}"></span>页 |
共 <span th:text="${pageInfo.totalElements}"></span> 条 |
<a th:href="@{/student/findPage(pageNum=1)}">首页</a> |
<a th:href="@{/student/findPage(pageNum= ${pageInfo.hasPrevious()}?${pageInfo.getNumber()}:1)}">上一页</a> |
<a th:href="@{/student/findPage(pageNum= ${pageInfo.hasNext()}?${pageInfo.getNumber()}+2:${pageInfo.totalPages})}">下一页</a> |
<a th:href="@{/student/findPage(pageNum= ${pageInfo.totalPages} )}">尾页</a>
</ul>
这个还是可以的,细心点没问题
这些个方法 比如是hasPrevious()(上一页
)、pageInfo.hasNext()(下一页)
等方法是在哪里来的?
这写个方法是来自Page
类的
page 类是继承Slice
接口,有兴趣的同学可以看一下
Slice
类
/*
* Copyright 2014-2020 the original author or authors.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* https://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.springframework.data.domain;
import java.util.List;
import java.util.function.Function;
import org.springframework.core.convert.converter.Converter;
import org.springframework.data.util.Streamable;
/**
* A slice of data that indicates whether there's a next or previous slice available. Allows to obtain a
* {@link Pageable} to request a previous or next {@link Slice}.
*
* @author Oliver Gierke
* @since 1.8
*/
public interface Slice<T> extends Streamable<T> {
/**
* Returns the number of the current {@link Slice}. Is always non-negative.
*
* @return the number of the current {@link Slice}.
*/
int getNumber();
/**
* Returns the size of the {@link Slice}.
*
* @return the size of the {@link Slice}.
*/
int getSize();
/**
* Returns the number of elements currently on this {@link Slice}.
*
* @return the number of elements currently on this {@link Slice}.
*/
int getNumberOfElements();
/**
* Returns the page content as {@link List}.
*
* @return
*/
List<T> getContent();
/**
* Returns whether the {@link Slice} has content at all.
*
* @return
*/
boolean hasContent();
/**
* Returns the sorting parameters for the {@link Slice}.
*
* @return
*/
Sort getSort();
/**
* Returns whether the current {@link Slice} is the first one.
*
* @return
*/
boolean isFirst();
/**
* Returns whether the current {@link Slice} is the last one.
*
* @return
*/
boolean isLast();
/**
* Returns if there is a next {@link Slice}.
*
* @return if there is a next {@link Slice}.
*/
boolean hasNext();
/**
* Returns if there is a previous {@link Slice}.
*
* @return if there is a previous {@link Slice}.
*/
boolean hasPrevious();
/**
* Returns the {@link Pageable} that's been used to request the current {@link Slice}.
*
* @return
* @since 2.0
*/
default Pageable getPageable() {
return PageRequest.of(getNumber(), getSize(), getSort());
}
/**
* Returns the {@link Pageable} to request the next {@link Slice}. Can be {@link Pageable#unpaged()} in case the
* current {@link Slice} is already the last one. Clients should check {@link #hasNext()} before calling this method.
*
* @return
* @see #nextOrLastPageable()
*/
Pageable nextPageable();
/**
* Returns the {@link Pageable} to request the previous {@link Slice}. Can be {@link Pageable#unpaged()} in case the
* current {@link Slice} is already the first one. Clients should check {@link #hasPrevious()} before calling this
* method.
*
* @return
* @see #previousPageable()
*/
Pageable previousPageable();
/**
* Returns a new {@link Slice} with the content of the current one mapped by the given {@link Converter}.
*
* @param converter must not be {@literal null}.
* @return a new {@link Slice} with the content of the current one mapped by the given {@link Converter}.
* @since 1.10
*/
<U> Slice<U> map(Function<? super T, ? extends U> converter);
/**
* Returns the {@link Pageable} describing the next slice or the one describing the current slice in case it's the
* last one.
*
* @return
* @since 2.2
*/
default Pageable nextOrLastPageable() {
return hasNext() ? nextPageable() : getPageable();
}
/**
* Returns the {@link Pageable} describing the previous slice or the one describing the current slice in case it's the
* first one.
*
* @return
* @since 2.2
*/
default Pageable previousOrFirstPageable() {
return hasPrevious() ? previousPageable() : getPageable();
}
}
更多推荐
所有评论(0)