Examples of 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>();

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.

Examples of SqlPageListSourceImpl

Examples of com.scooterframework.orm.misc.SqlPageListSourceImpl