public abstract class AbstractSqlPagingQueryProvider extends Object implements PagingQueryProvider
Constructor and Description |
---|
AbstractSqlPagingQueryProvider() |
Modifier and Type | Method and Description |
---|---|
abstract String |
generateFirstPageQuery(int pageSize)
Method generating the query string to be used for retrieving the first
page.
|
abstract String |
generateJumpToItemQuery(int itemIndex,
int pageSize)
Method generating the query string to be used for jumping to a specific
item position.
|
abstract String |
generateRemainingPagesQuery(int pageSize)
Method generating the query string to be used for retrieving the pages
following the first page.
|
protected String |
getFromClause() |
String |
getGroupClause()
The getter for the group by clause
|
int |
getParameterCount()
The number of parameters that are declared in the query
|
protected String |
getSelectClause() |
String |
getSortKeyPlaceHolder(String keyName)
The sort key placeholder will vary depending on whether named parameters
or traditional placeholders are used in query strings.
|
Map<String,Order> |
getSortKeys()
A Map
|
protected String |
getWhereClause() |
void |
init(DataSource dataSource)
Check mandatory properties.
|
boolean |
isUsingNamedParameters()
Indicate whether the generated queries use named parameter syntax.
|
void |
setFromClause(String fromClause) |
void |
setGroupClause(String groupClause)
The setter for the group by clause
|
void |
setSelectClause(String selectClause) |
void |
setSortKeys(Map<String,Order> sortKeys) |
void |
setWhereClause(String whereClause) |
public void setGroupClause(String groupClause)
groupClause
- SQL GROUP BY clause part of the SQL query stringpublic String getGroupClause()
public void setSelectClause(String selectClause)
selectClause
- SELECT clause part of SQL query stringprotected String getSelectClause()
public void setFromClause(String fromClause)
fromClause
- FROM clause part of SQL query stringprotected String getFromClause()
public void setWhereClause(String whereClause)
whereClause
- WHERE clause part of SQL query stringprotected String getWhereClause()
public void setSortKeys(Map<String,Order> sortKeys)
sortKeys
- key to use to sort and limit page contentpublic Map<String,Order> getSortKeys()
getSortKeys
in interface PagingQueryProvider
public int getParameterCount()
PagingQueryProvider
getParameterCount
in interface PagingQueryProvider
public boolean isUsingNamedParameters()
PagingQueryProvider
isUsingNamedParameters
in interface PagingQueryProvider
public String getSortKeyPlaceHolder(String keyName)
getSortKeyPlaceHolder
in interface PagingQueryProvider
keyName
- The sort key namepublic void init(DataSource dataSource) throws Exception
init
in interface PagingQueryProvider
dataSource
- DataSource to use for any initializationException
InitializingBean.afterPropertiesSet()
public abstract String generateFirstPageQuery(int pageSize)
generateFirstPageQuery
in interface PagingQueryProvider
pageSize
- number of rows to read per pagepublic abstract String generateRemainingPagesQuery(int pageSize)
generateRemainingPagesQuery
in interface PagingQueryProvider
pageSize
- number of rows to read per pagepublic abstract String generateJumpToItemQuery(int itemIndex, int pageSize)
generateJumpToItemQuery
in interface PagingQueryProvider
itemIndex
- the index of the item to jump topageSize
- number of rows to read per pageCopyright © 2014 Pivotal. All rights reserved.