org.opencms.db

类 CmsPagingQuery

java.lang.Object

org.opencms.db.CmsPagingQuery

所有已实现的接口:

I_CmsQueryFragment

public class CmsPagingQuery
extends java.lang.Object
implements I_CmsQueryFragment

Wrapper for CmsSelectQuery objects which adds SQL code for results paging.

The wrapper can either use the window function approach to paging or append a LIMIT/OFFSET clause.

从以下版本开始:

8.0.0

另请参阅:

"http://troels.arvin.dk/db/rdbms/#select-limit-offset"

构造器概要

构造器

构造器和说明
CmsPagingQuery(CmsSelectQuery select) Creates a new instance.

方法概要

方法

限定符和类型	方法和说明
void	setNameSubquery(boolean nameSubquery) Enables or disables the naming of subqueries.
void	setPaging(int pageSize, int page) Sets both the page size and current page to use for the query.
void	setUseWindowFunctions(boolean useWindowFunctions) Enables the use of window functions.
void	visit(CmsStatementBuilder builder) Generates the SQL and parameters and sends them to the statement builder .

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

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

构造器详细资料

CmsPagingQuery

public CmsPagingQuery(CmsSelectQuery select)

Creates a new instance.

参数:

select - the wrapped query

方法详细资料

setNameSubquery

public void setNameSubquery(boolean nameSubquery)

Enables or disables the naming of subqueries.

参数:

nameSubquery - if true, enables naming of subqueries

setPaging

public void setPaging(int pageSize,
             int page)

Sets both the page size and current page to use for the query.

参数:

pageSize - the page size

page - the current page (counting starts at 1)

setUseWindowFunctions

public void setUseWindowFunctions(boolean useWindowFunctions)

Enables the use of window functions.

参数:

useWindowFunctions - if true, enables window functions

visit

public void visit(CmsStatementBuilder builder)

从接口复制的说明: I_CmsQueryFragment

Generates the SQL and parameters and sends them to the statement builder .

指定者:

visit 在接口中 I_CmsQueryFragment

参数:

builder - the statement builder

另请参阅:

I_CmsQueryFragment.visit(org.opencms.db.CmsStatementBuilder)