Examples of com.scooterframework.orm.misc.SqlPageListSourceImpl

com.scooterframework.orm.misc.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./
@author (Fei) John Chen

      try {
          if (sql != null && !"".equals(sql)) {
              if (isSelectSQL(sql) && "true".equals(p(Constants.PAGED))) {
                Map<String, String> pagingOptions = Converters.convertMapToMapSS(ACH.getAC().getParameterDataAsMap());
                pagingOptions.put("limit", limit);
                Paginator page = new Paginator(new SqlPageListSourceImpl(database, sql), pagingOptions);
                    setViewData("paged_records", page);
                    return ActionResult.forwardTo(viewPath("paged_list"));
              }
              else {
                  Map<String, Object> inputs = new HashMap<String, Object>();

View Full Code Here

TOP

Related Classes of com.scooterframework.orm.misc.SqlPageListSourceImpl

com.scooterframework.builtin.databrowser.SQLWindowController

com.scooterframework.orm.sqldataexpress.exception.BaseSQLException

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.