|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.scooterframework.orm.misc.PageListSource
com.scooterframework.orm.misc.SqlPageListSourceImpl
public class SqlPageListSourceImpl
SqlPageListSourceImpl class retrieves paged record list by using a predefined finder SQL query.
Finder SQL query example:
SELECT * FROM employees
This class is responsible for adding page limit constraint in the query.
The caller of this class is responsible for setting proper values for limit, offset, recount, and inputs map. Default values will be used when they are not set. The default value for limit is defined in DataProcessor.DEFAULT_PAGINATION_LIMIT. The default value for offset is zero. The default value for recount is true./
Field Summary | |
---|---|
protected java.lang.String |
connName
|
protected java.lang.String |
finderSql
|
Fields inherited from class com.scooterframework.orm.misc.PageListSource |
---|
inputOptions, limit, log, offset, recordList, recount, totalCount |
Constructor Summary | |
---|---|
SqlPageListSourceImpl(java.lang.String connName,
java.lang.String finderSql)
Constructs a PageListSource object. |
|
SqlPageListSourceImpl(java.lang.String connName,
java.lang.String finderSql,
java.util.Map<java.lang.String,java.lang.String> inputOptions)
Constructs a PageListSource object. |
|
SqlPageListSourceImpl(java.lang.String connName,
java.lang.String finderSql,
java.util.Map<java.lang.String,java.lang.String> inputOptions,
boolean recount)
Constructs a PageListSource object. |
Method Summary | |
---|---|
protected int |
countTotalRecords()
Counts total number of records. |
protected java.util.List<RowData> |
retrieveList()
Retrieves list of records. |
Methods inherited from class com.scooterframework.orm.misc.PageListSource |
---|
checkOffset, execute, getLimitX, getOffset, getRecordList, getTotalCount, setInputs, setLimit, setOffset, setRecount |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
protected java.lang.String connName
protected java.lang.String finderSql
Constructor Detail |
---|
public SqlPageListSourceImpl(java.lang.String connName, java.lang.String finderSql)
connName
- database connection name.finderSql
- the sql query for finding records.public SqlPageListSourceImpl(java.lang.String connName, java.lang.String finderSql, java.util.Map<java.lang.String,java.lang.String> inputOptions)
connName
- database connection name.finderSql
- the SQL query for finding records.inputOptions
- Map of control information.public SqlPageListSourceImpl(java.lang.String connName, java.lang.String finderSql, java.util.Map<java.lang.String,java.lang.String> inputOptions, boolean recount)
connName
- database connection name.finderSql
- the SQL query for finding records.inputOptions
- Map of control information.recount
- true if recount of total records is allowed;
false otherwise.Method Detail |
---|
protected int countTotalRecords()
PageListSource
countTotalRecords
in class PageListSource
protected java.util.List<RowData> retrieveList()
PageListSource
retrieveList
in class PageListSource
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |