java.lang.Object
- org.springframework.batch.item.database.support.AbstractSqlPagingQueryProvider
- - org.springframework.batch.item.database.support.SqlWindowingPagingQueryProvider

所有已实现的接口:
PagingQueryProvider
直接已知子类:
Db2PagingQueryProvider, DerbyPagingQueryProvider, SqlServerPagingQueryProvider, SybasePagingQueryProvider
```
public class SqlWindowingPagingQueryProvider
extends AbstractSqlPagingQueryProvider
```
Generic Paging Query Provider using standard SQL:2003 windowing functions. These features are supported by DB2, Oracle, SQL Server 2005, Sybase and Apache Derby version 10.4.1.3
从以下版本开始:
2.0
作者:
Thomas Risberg, Michael Minella

构造器概要
构造器
构造器说明
SqlWindowingPagingQueryProvider()

方法概要

所有方法实例方法具体方法
修饰符和类型	方法	说明
`protected java.lang.Object`	`extractTableAlias()`
`java.lang.String`	`generateFirstPageQuery(int pageSize)`	Method generating the query string to be used for retrieving the first page.
`java.lang.String`	`generateJumpToItemQuery(int itemIndex, int pageSize)`	Method generating the query string to be used for jumping to a specific item position.
`java.lang.String`	`generateRemainingPagesQuery(int pageSize)`	Method generating the query string to be used for retrieving the pages following the first page.
`protected java.lang.String`	`getOrderedQueryAlias()`
`protected java.lang.String`	`getOverClause()`
`protected java.lang.String`	`getOverSubstituteClauseEnd()`
`protected java.lang.String`	`getOverSubstituteClauseStart()`
`protected java.lang.Object`	`getSubQueryAlias()`

从类继承的方法 org.springframework.batch.item.database.support.AbstractSqlPagingQueryProvider
getFromClause, getGroupClause, getParameterCount, getSelectClause, getSortKeyPlaceHolder, getSortKeys, getSortKeysWithoutAliases, getWhereClause, init, isUsingNamedParameters, setFromClause, setGroupClause, setSelectClause, setSortKeys, setWhereClause

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- 构造器详细资料
  - SqlWindowingPagingQueryProvider
```
public SqlWindowingPagingQueryProvider()
```
- 方法详细资料
  - generateFirstPageQuery
```
public java.lang.String generateFirstPageQuery(int pageSize)
```
    从类复制的说明: AbstractSqlPagingQueryProvider
    Method generating the query string to be used for retrieving the first page. This method must be implemented in sub classes.
    指定者:
    generateFirstPageQuery 在接口中 PagingQueryProvider
    指定者:
    generateFirstPageQuery 在类中 AbstractSqlPagingQueryProvider
    参数:
    pageSize - number of rows to read per page
    返回:
    query string
  - getOrderedQueryAlias
```
protected java.lang.String getOrderedQueryAlias()
```
  - getSubQueryAlias
```
protected java.lang.Object getSubQueryAlias()
```
  - extractTableAlias
```
protected java.lang.Object extractTableAlias()
```
  - generateRemainingPagesQuery
```
public java.lang.String generateRemainingPagesQuery(int pageSize)
```
    从类复制的说明: AbstractSqlPagingQueryProvider
    Method generating the query string to be used for retrieving the pages following the first page. This method must be implemented in sub classes.
    指定者:
    generateRemainingPagesQuery 在接口中 PagingQueryProvider
    指定者:
    generateRemainingPagesQuery 在类中 AbstractSqlPagingQueryProvider
    参数:
    pageSize - number of rows to read per page
    返回:
    query string
  - generateJumpToItemQuery
```
public java.lang.String generateJumpToItemQuery(int itemIndex,
                                                int pageSize)
```
    从类复制的说明: AbstractSqlPagingQueryProvider
    Method generating the query string to be used for jumping to a specific item position. This method must be implemented in sub classes.
    指定者:
    generateJumpToItemQuery 在接口中 PagingQueryProvider
    指定者:
    generateJumpToItemQuery 在类中 AbstractSqlPagingQueryProvider
    参数:
    itemIndex - the index of the item to jump to
    pageSize - number of rows to read per page
    返回:
    query string
  - getOverClause
```
protected java.lang.String getOverClause()
```
  - getOverSubstituteClauseStart
```
protected java.lang.String getOverSubstituteClauseStart()
```
  - getOverSubstituteClauseEnd
```
protected java.lang.String getOverSubstituteClauseEnd()
```

类 SqlWindowingPagingQueryProvider

构造器概要

方法概要

从类继承的方法 org.springframework.batch.item.database.support.AbstractSqlPagingQueryProvider

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

构造器详细资料

SqlWindowingPagingQueryProvider

方法详细资料

generateFirstPageQuery

getOrderedQueryAlias

getSubQueryAlias

extractTableAlias

generateRemainingPagesQuery

generateJumpToItemQuery

getOverClause

getOverSubstituteClauseStart

getOverSubstituteClauseEnd