|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface LimitHandler
Contract defining dialect-specific LIMIT clause handling. Typically implementers might consider extending
AbstractLimitHandler
class.
Method Summary | |
---|---|
int |
bindLimitParametersAtEndOfQuery(PreparedStatement statement,
int index)
Bind parameter values needed by the LIMIT clause after original SELECT statement. |
int |
bindLimitParametersAtStartOfQuery(PreparedStatement statement,
int index)
Bind parameter values needed by the LIMIT clause before original SELECT statement. |
String |
getProcessedSql()
Return processed SQL query. |
void |
setMaxRows(PreparedStatement statement)
Use JDBC API to limit the number of rows returned by the SQL query. |
boolean |
supportsLimit()
Does this handler support some form of limiting query results via a SQL clause? |
boolean |
supportsLimitOffset()
Does this handler's LIMIT support (if any) additionally support specifying an offset? |
Method Detail |
---|
boolean supportsLimit()
boolean supportsLimitOffset()
String getProcessedSql()
int bindLimitParametersAtStartOfQuery(PreparedStatement statement, int index) throws SQLException
statement
- Statement to which to bind limit parameter values.index
- Index from which to start binding.
SQLException
- Indicates problems binding parameter values.int bindLimitParametersAtEndOfQuery(PreparedStatement statement, int index) throws SQLException
statement
- Statement to which to bind limit parameter values.index
- Index from which to start binding.
SQLException
- Indicates problems binding parameter values.void setMaxRows(PreparedStatement statement) throws SQLException
statement
- Statement which number of returned rows shall be limited.
SQLException
- Indicates problems while limiting maximum rows returned.
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |