Class AbstractSqlPagingQueryProvider
java.lang.Object
org.springframework.cloud.task.repository.database.support.AbstractSqlPagingQueryProvider
- All Implemented Interfaces:
PagingQueryProvider
- Direct Known Subclasses:
Db2PagingQueryProvider
,H2PagingQueryProvider
,HsqlPagingQueryProvider
,MariaDbPagingQueryProvider
,MySqlPagingQueryProvider
,OraclePagingQueryProvider
,PostgresPagingQueryProvider
,SqlServerPagingQueryProvider
Abstract SQL Paging Query Provider to serve as a base class for all provided SQL paging
query providers.
Any implementation must provide a way to specify the select clause, from clause and
optionally a where clause. It is recommended that there should be an index for the sort
key to provide better performance.
Provides properties and preparation for the mandatory "selectClause" and "fromClause"
as well as for the optional "whereClause".
- Author:
- Glenn Renfro
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionprotected String
int
The number of parameters that are declared in the query.protected String
A Map<String, Order> of sort columns as the key andOrder
for ascending/descending.protected String
void
init
(DataSource dataSource) Initialize the query provider using the providedDataSource
if necessary.boolean
Indicate whether the generated queries use named parameter syntax.void
setFromClause
(String fromClause) void
setSelectClause
(String selectClause) void
setSortKeys
(Map<String, org.springframework.batch.item.database.Order> sortKeys) void
setWhereClause
(String whereClause) Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface org.springframework.cloud.task.repository.database.PagingQueryProvider
getPageQuery
-
Constructor Details
-
AbstractSqlPagingQueryProvider
public AbstractSqlPagingQueryProvider()
-
-
Method Details
-
getSelectClause
- Returns:
- SQL SELECT clause part of SQL query string
-
setSelectClause
- Parameters:
selectClause
- SELECT clause part of SQL query string
-
getFromClause
- Returns:
- SQL FROM clause part of SQL query string
-
setFromClause
- Parameters:
fromClause
- FROM clause part of SQL query string
-
getWhereClause
- Returns:
- SQL WHERE clause part of SQL query string
-
setWhereClause
- Parameters:
whereClause
- WHERE clause part of SQL query string
-
getSortKeys
A Map<String, Order> of sort columns as the key andOrder
for ascending/descending.- Specified by:
getSortKeys
in interfacePagingQueryProvider
- Returns:
- sortKey key to use to sort and limit page content
-
setSortKeys
- Parameters:
sortKeys
- key to use to sort and limit page content
-
getParameterCount
public int getParameterCount()Description copied from interface:PagingQueryProvider
The number of parameters that are declared in the query.- Specified by:
getParameterCount
in interfacePagingQueryProvider
- Returns:
- number of parameters
-
isUsingNamedParameters
public boolean isUsingNamedParameters()Description copied from interface:PagingQueryProvider
Indicate whether the generated queries use named parameter syntax.- Specified by:
isUsingNamedParameters
in interfacePagingQueryProvider
- Returns:
- true if named parameter syntax is used
-
init
Description copied from interface:PagingQueryProvider
Initialize the query provider using the providedDataSource
if necessary.- Specified by:
init
in interfacePagingQueryProvider
- Parameters:
dataSource
- DataSource to use for any initialization- Throws:
Exception
- throwsException
if query provider initialize fails.
-