Interface PageQuery

All Superinterfaces:

CountQuery, Executable, GetQuery, ListQuery

All Known Implementing Classes:

Dao

public interface PageQuery
extends CountQuery, ListQuery

分页查询

先执行 count 再执行 list,两条语句使用各自的连接,不在同一事务中: 并发写入时 total 与 data 可能不一致。需要强一致的场景由调用方自行开启事务, 或按官方建议分别调用 CountQuery 与 ListQuery。

Author:

Maning

Method Summary

Modifier and Type	Method	Description
default <T> Page<T>	page(Class<T> entityClass, Pageable pageable, Collection<? extends Condition> conditions)	分页查询
default <T> Page<T>	page(Class<T> entityClass, Pageable pageable, Consumer<Select> customizer)	分页查询
default <T> Page<T>	page(Class<T> entityClass, Pageable pageable, Condition... conditions)	分页查询
default <T> Page<T>	page(Class<T> entityClass, Pageable pageable, OrderBy orderBy, Collection<? extends Condition> conditions)	分页查询
default <T> Page<T>	page(Class<T> entityClass, Pageable pageable, OrderBy orderBy, Condition... conditions)	分页查询
default <T> Page<T>	page(Class<T> entityClass, Pageable pageable, OrderBy orderBy, Searchable search, Collection<? extends Condition> conditions)	分页查询
default <T> Page<T>	page(Class<T> entityClass, Pageable pageable, OrderBy orderBy, Searchable search, Condition... conditions)	分页查询
default <T> Page<T>	page(Class<T> entityClass, Pageable pageable, Searchable search, Collection<? extends Condition> conditions)	分页查询
default <T> Page<T>	page(Class<T> entityClass, Pageable pageable, Searchable search, Condition... conditions)	分页查询
default <E> Page<E>	pageAs(Class<?> entityClass, Class<E> elementClass, Pageable pageable, Collection<? extends Condition> conditions)	分页查询
default <E> Page<E>	pageAs(Class<?> entityClass, Class<E> elementClass, Pageable pageable, Consumer<Select> customizer)	分页查询
default <E> Page<E>	pageAs(Class<?> entityClass, Class<E> elementClass, Pageable pageable, Condition... conditions)	分页查询
default <E> Page<E>	pageAs(Class<?> entityClass, Class<E> elementClass, Pageable pageable, OrderBy orderBy, Collection<? extends Condition> conditions)	分页查询
default <E> Page<E>	pageAs(Class<?> entityClass, Class<E> elementClass, Pageable pageable, OrderBy orderBy, Condition... conditions)	分页查询
default <E> Page<E>	pageAs(Class<?> entityClass, Class<E> elementClass, Pageable pageable, OrderBy orderBy, Searchable search, Collection<? extends Condition> conditions)	分页查询
default <E> Page<E>	pageAs(Class<?> entityClass, Class<E> elementClass, Pageable pageable, OrderBy orderBy, Searchable search, Condition... conditions)	分页查询
default <E> Page<E>	pageAs(Class<?> entityClass, Class<E> elementClass, Pageable pageable, Searchable search, Collection<? extends Condition> conditions)	分页查询
default <E> Page<E>	pageAs(Class<?> entityClass, Class<E> elementClass, Pageable pageable, Searchable search, Condition... conditions)	分页查询
default <E> Page<E>	pageAs(Class<?> entityClass, TypeRef<E> elementTypeRef, Pageable pageable, Consumer<Select> customizer)	分页查询

Methods inherited from interface CountQuery

count, count, count, count, count, countColumn, countColumn, countColumn, countColumn, countColumn, countColumn, countColumn, countColumn, countColumn, countColumn, countColumn, countColumn, countColumnDistinct, countColumnDistinct, countColumnDistinct, countColumnDistinct, countColumnDistinct, countColumnDistinct, countColumnDistinct, countColumnDistinct, countColumnDistinct, countColumnDistinct, countColumnDistinct, countColumnDistinct

Methods inherited from interface Executable

executor, interceptor

Methods inherited from interface GetQuery

doGet, get, get, get, getAs, getAs, getAs, getAs, getById, getById, getByIdAs, getByIdAs

Methods inherited from interface ListQuery

doList, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, list, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listAs, listByIds, listByIds, listByIds, listByIdsAs, listByIdsAs, listByIdsAs

Method Details

page

default <T> Page<T> page(Class<T> entityClass,
 Pageable pageable,
 Consumer<Select> customizer)

分页查询

Type Parameters:

T - 实体类类型

Parameters:

entityClass - 实体类

pageable - 分页

customizer - 查询自定义

Returns:

结果

page

default <T> Page<T> page(Class<T> entityClass,
 Pageable pageable,
 Collection<? extends Condition> conditions)

分页查询

Type Parameters:

T - 实体类类型

Parameters:

entityClass - 实体类

pageable - 分页

conditions - 条件

Returns:

结果

page

default <T> Page<T> page(Class<T> entityClass,
 Pageable pageable,
 OrderBy orderBy,
 Collection<? extends Condition> conditions)

分页查询

Type Parameters:

T - 实体类类型

Parameters:

entityClass - 实体类

pageable - 分页

orderBy - 排序

conditions - 条件

Returns:

结果

page

default <T> Page<T> page(Class<T> entityClass,
 Pageable pageable,
 Searchable search,
 Collection<? extends Condition> conditions)

分页查询

Type Parameters:

T - 实体类类型

Parameters:

entityClass - 实体类

pageable - 分页

search - 对象筛选

conditions - 条件

Returns:

结果

page

default <T> Page<T> page(Class<T> entityClass,
 Pageable pageable,
 OrderBy orderBy,
 Searchable search,
 Collection<? extends Condition> conditions)

分页查询

Type Parameters:

T - 实体类类型

Parameters:

entityClass - 实体类

pageable - 分页

orderBy - 排序

search - 对象筛选

conditions - 条件

Returns:

结果

page

default <T> Page<T> page(Class<T> entityClass,
 Pageable pageable,
 Condition... conditions)

分页查询

Type Parameters:

T - 实体类类型

Parameters:

entityClass - 实体类

pageable - 分页

conditions - 条件

Returns:

结果

page

default <T> Page<T> page(Class<T> entityClass,
 Pageable pageable,
 OrderBy orderBy,
 Condition... conditions)

分页查询

Type Parameters:

T - 实体类类型

Parameters:

entityClass - 实体类

pageable - 分页

orderBy - 排序

conditions - 条件

Returns:

结果

page

default <T> Page<T> page(Class<T> entityClass,
 Pageable pageable,
 Searchable search,
 Condition... conditions)

分页查询

Type Parameters:

T - 实体类类型

Parameters:

entityClass - 实体类

pageable - 分页

search - 对象筛选

conditions - 条件

Returns:

结果

page

default <T> Page<T> page(Class<T> entityClass,
 Pageable pageable,
 OrderBy orderBy,
 Searchable search,
 Condition... conditions)

分页查询

Type Parameters:

T - 实体类类型

Parameters:

entityClass - 实体类

pageable - 分页

orderBy - 排序

search - 对象筛选

conditions - 条件

Returns:

结果

pageAs

default <E> Page<E> pageAs(Class<?> entityClass,
 TypeRef<E> elementTypeRef,
 Pageable pageable,
 Consumer<Select> customizer)

分页查询

Type Parameters:

E - 元素类型

Parameters:

entityClass - 实体类

elementTypeRef - 元素类型引用

pageable - 分页

customizer - 查询自定义

Returns:

结果

pageAs

default <E> Page<E> pageAs(Class<?> entityClass,
 Class<E> elementClass,
 Pageable pageable,
 Consumer<Select> customizer)

分页查询

Type Parameters:

E - 元素类型

Parameters:

entityClass - 实体类

elementClass - 元素类型

pageable - 分页

customizer - 查询自定义

Returns:

结果

pageAs

default <E> Page<E> pageAs(Class<?> entityClass,
 Class<E> elementClass,
 Pageable pageable,
 Collection<? extends Condition> conditions)

分页查询

Type Parameters:

E - 元素类型

Parameters:

entityClass - 实体类

elementClass - 元素类型

pageable - 分页

conditions - 条件

Returns:

结果

pageAs

default <E> Page<E> pageAs(Class<?> entityClass,
 Class<E> elementClass,
 Pageable pageable,
 OrderBy orderBy,
 Collection<? extends Condition> conditions)

分页查询

Type Parameters:

E - 元素类型

Parameters:

entityClass - 实体类

elementClass - 元素类型

pageable - 分页

orderBy - 排序

conditions - 条件

Returns:

结果

pageAs

default <E> Page<E> pageAs(Class<?> entityClass,
 Class<E> elementClass,
 Pageable pageable,
 Searchable search,
 Collection<? extends Condition> conditions)

分页查询

Type Parameters:

E - 元素类型

Parameters:

entityClass - 实体类

elementClass - 元素类型

pageable - 分页

search - 对象筛选

conditions - 条件

Returns:

结果

pageAs

default <E> Page<E> pageAs(Class<?> entityClass,
 Class<E> elementClass,
 Pageable pageable,
 OrderBy orderBy,
 Searchable search,
 Collection<? extends Condition> conditions)

分页查询

Type Parameters:

E - 元素类型

Parameters:

entityClass - 实体类

elementClass - 元素类型

pageable - 分页

orderBy - 排序

search - 对象筛选

conditions - 条件

Returns:

结果

pageAs

default <E> Page<E> pageAs(Class<?> entityClass,
 Class<E> elementClass,
 Pageable pageable,
 Condition... conditions)

分页查询

Type Parameters:

E - 元素类型

Parameters:

entityClass - 实体类

elementClass - 元素类型

pageable - 分页

conditions - 条件

Returns:

结果

pageAs

default <E> Page<E> pageAs(Class<?> entityClass,
 Class<E> elementClass,
 Pageable pageable,
 OrderBy orderBy,
 Condition... conditions)

分页查询

Type Parameters:

E - 元素类型

Parameters:

entityClass - 实体类

elementClass - 元素类型

pageable - 分页

orderBy - 排序

conditions - 条件

Returns:

结果

pageAs

default <E> Page<E> pageAs(Class<?> entityClass,
 Class<E> elementClass,
 Pageable pageable,
 Searchable search,
 Condition... conditions)

分页查询

Type Parameters:

E - 元素类型

Parameters:

entityClass - 实体类

elementClass - 元素类型

pageable - 分页

search - 对象筛选

conditions - 条件

Returns:

结果

pageAs

default <E> Page<E> pageAs(Class<?> entityClass,
 Class<E> elementClass,
 Pageable pageable,
 OrderBy orderBy,
 Searchable search,
 Condition... conditions)

分页查询

Type Parameters:

E - 元素类型

Parameters:

entityClass - 实体类

elementClass - 元素类型

pageable - 分页

orderBy - 排序

search - 对象筛选

conditions - 条件

Returns:

结果