com.ajaxjs.sqlman.crud.page

类 PageQuery

java.lang.Object

com.ajaxjs.sqlman.crud.page.PageQuery

public class PageQuery
extends Object

Pagination utilities.

字段概要

字段

限定符和类型	字段和说明
static int	DEFAULT_PAGE_SIZE 默认分页大小
static String[]	PAGE_NO
static String[]	PAGE_SIZE
static String[]	START

构造器概要

构造器

构造器和说明
PageQuery()

方法概要

限定符和类型	方法和说明
static boolean	autoDetectPageWay(javax.servlet.http.HttpServletRequest req) Detect which type to page by request parameters.
static Integer	getParameter(javax.servlet.http.HttpServletRequest req, String[] maybe, int defaultValue) 根据 HttpServletRequest 和字符串数组返回一个整数。
static <T> PageResult<T>	page(Query query, Class<T> beanClz, Integer start, Integer limit) Do the pagination.
static int	pageNo2start(int pageNo, int limit) 将页码和每页数量转换为起始位置 pageSize 转换为 MySQL 的 start 分页
static void	setParams(PageResult<?> result, int totalCount, int start) Calculate the parameters of pagination related, like total page.

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

字段详细资料

START

public static final String[] START

PAGE_NO

public static final String[] PAGE_NO

PAGE_SIZE

public static final String[] PAGE_SIZE

DEFAULT_PAGE_SIZE

public static final int DEFAULT_PAGE_SIZE

默认分页大小

另请参阅:

常量字段值

构造器详细资料

PageQuery

public PageQuery()

方法详细资料

page

public static <T> PageResult<T> page(Query query,
                                     Class<T> beanClz,
                                     Integer start,
                                     Integer limit)

Do the pagination.

类型参数:

T - The type of result object

参数:

query - Query object

beanClz - The type of result object, null for Map

start - The start position

limit - The limit of records, equals to page size

返回:

The result object

setParams

public static void setParams(PageResult<?> result,
                             int totalCount,
                             int start)

Calculate the parameters of pagination related, like total page.

参数:

result - The result object

totalCount - The total count of records

start - The start position

pageNo2start

public static int pageNo2start(int pageNo,
                               int limit)

将页码和每页数量转换为起始位置 pageSize 转换为 MySQL 的 start 分页

参数:

pageNo - 页码

limit - 每页数量

返回:

起始位置

getParameter

public static Integer getParameter(javax.servlet.http.HttpServletRequest req,
                                   String[] maybe,
                                   int defaultValue)

根据 HttpServletRequest 和字符串数组返回一个整数。

参数:

req - 请求对象

maybe - 字符串数组，包含可能的参数名

返回:

返回一个整数，如果参数存在且为整数，则返回对应的整数值；否则返回 null

autoDetectPageWay

public static boolean autoDetectPageWay(javax.servlet.http.HttpServletRequest req)

Detect which type to page by request parameters.

参数:

req - The request object

返回:

true = using start/limit ; false = using pageNo/pageSize