public class SqlPagingQueryUtils extends Object
Constructor and Description |
---|
SqlPagingQueryUtils() |
Modifier and Type | Method and Description |
---|---|
static String |
generateLimitJumpToQuery(AbstractSqlPagingQueryProvider provider,
String limitClause)
Generate SQL query string using a LIMIT clause
|
static String |
generateLimitSqlQuery(AbstractSqlPagingQueryProvider provider,
boolean remainingPageQuery,
String limitClause)
Generate SQL query string using a LIMIT clause
|
static String |
generateRowNumSqlQuery(AbstractSqlPagingQueryProvider provider,
boolean remainingPageQuery,
String rowNumClause)
Generate SQL query string using a ROW_NUM condition
|
static String |
generateRowNumSqlQuery(AbstractSqlPagingQueryProvider provider,
String selectClause,
boolean remainingPageQuery,
String rowNumClause)
Generate SQL query string using a ROW_NUM condition
|
static String |
generateRowNumSqlQueryWithNesting(AbstractSqlPagingQueryProvider provider,
String selectClause,
boolean remainingPageQuery,
String rowNumClause) |
static String |
generateRowNumSqlQueryWithNesting(AbstractSqlPagingQueryProvider provider,
String innerSelectClause,
String outerSelectClause,
boolean remainingPageQuery,
String rowNumClause) |
static String |
generateTopJumpToQuery(AbstractSqlPagingQueryProvider provider,
String topClause)
Generate SQL query string using a TOP clause
|
static String |
generateTopSqlQuery(AbstractSqlPagingQueryProvider provider,
boolean remainingPageQuery,
String topClause)
Generate SQL query string using a TOP clause
|
public static String generateLimitSqlQuery(AbstractSqlPagingQueryProvider provider, boolean remainingPageQuery, String limitClause)
provider
- AbstractSqlPagingQueryProvider
providing the
implementation specificsremainingPageQuery
- is this query for the ramining pages (true) as
opposed to the first page (false)limitClause
- the implementation specific limit clause to be usedpublic static String generateTopSqlQuery(AbstractSqlPagingQueryProvider provider, boolean remainingPageQuery, String topClause)
provider
- AbstractSqlPagingQueryProvider
providing the
implementation specificsremainingPageQuery
- is this query for the ramining pages (true) as
opposed to the first page (false)topClause
- the implementation specific top clause to be usedpublic static String generateRowNumSqlQuery(AbstractSqlPagingQueryProvider provider, boolean remainingPageQuery, String rowNumClause)
provider
- AbstractSqlPagingQueryProvider
providing the
implementation specificsremainingPageQuery
- is this query for the remaining pages (true) as
opposed to the first page (false)rowNumClause
- the implementation specific row num clause to be usedpublic static String generateRowNumSqlQuery(AbstractSqlPagingQueryProvider provider, String selectClause, boolean remainingPageQuery, String rowNumClause)
provider
- AbstractSqlPagingQueryProvider
providing the
implementation specificsremainingPageQuery
- is this query for the remaining pages (true) as
opposed to the first page (false)rowNumClause
- the implementation specific row num clause to be usedpublic static String generateRowNumSqlQueryWithNesting(AbstractSqlPagingQueryProvider provider, String selectClause, boolean remainingPageQuery, String rowNumClause)
public static String generateRowNumSqlQueryWithNesting(AbstractSqlPagingQueryProvider provider, String innerSelectClause, String outerSelectClause, boolean remainingPageQuery, String rowNumClause)
public static String generateLimitJumpToQuery(AbstractSqlPagingQueryProvider provider, String limitClause)
provider
- AbstractSqlPagingQueryProvider
providing the
implementation specificslimitClause
- the implementation specific top clause to be usedpublic static String generateTopJumpToQuery(AbstractSqlPagingQueryProvider provider, String topClause)
provider
- AbstractSqlPagingQueryProvider
providing the
implementation specificstopClause
- the implementation specific top clause to be usedCopyright © 2013 SpringSource. All rights reserved.