Examples of javax.servlet.jsp.jstl.sql.Result

javax.servlet.jsp.jstl.sql.Result
This interface represents the result of a <sql:query> action. It provides access to the following information in the query result:
- The result rows (getRows() and getRowsByIndex())
- The column names (getColumnNames())
- The number of rows in the result (getRowCount())
- An indication whether the rows returned represent the complete result or just a subset that is limited by a maximum row setting (isLimitedByMaxRows())
An implementation of the Result interface provides a disconnected view into the result of a query. @author Justyna Horwat

      int startRow = _startRow;


      while (startRow-- > 0 && rs.next()) {
      }


      Result result;
      result = new ResultImpl(rs, maxRows);


      rs.close();
      stmt.close();

View Full Code Here


        while (startRow-- > 0 && rs.next()) {
        }
      }


      Result result;
      if (_maxRows != null)
        result = new ResultImpl(rs, (int) _maxRows.evalLong(env));
      else
        result = new ResultImpl(rs, -1);

View Full Code Here

        if ((startRow < 0) || (maxRows < -1)) {
            throw new JspException(
                Resources.getMessage("PARAM_BAD_VALUE"));
        }


  Result result = null;
  /* 
   * Note! We must not use the setMaxRows() method on the
   * the statement to limit the number of rows, since the
   * Result factory must be able to figure out the correct
   * value for isLimitedByMaxRows(); there's no way to check

View Full Code Here

        if ((startRow < 0) || (maxRows < -1)) {
            throw new JspException(
                Resources.getMessage("PARAM_BAD_VALUE"));
        }


  Result result = null;
  /* 
   * Note! We must not use the setMaxRows() method on the
   * the statement to limit the number of rows, since the
   * Result factory must be able to figure out the correct
   * value for isLimitedByMaxRows(); there's no way to check

View Full Code Here

      (Resources.getMessage("SQL_MAXROWS_INVALID"));
                }
            }
        }
  
        Result result = null;
        String sqlStatement = null;


        logger.debug( "About to lookup connection" );


        ResultSet rs = null;

View Full Code Here

        if ((startRow < 0) || (maxRows < -1)) {
            throw new JspException(
                Resources.getMessage("PARAM_BAD_VALUE"));
        }


  Result result = null;
  /* 
   * Note! We must not use the setMaxRows() method on the
   * the statement to limit the number of rows, since the
   * Result factory must be able to figure out the correct
   * value for isLimitedByMaxRows(); there's no way to check

View Full Code Here

                    throw new JellyException(Resources.getMessage("SQL_MAXROWS_INVALID"));
                }
            }
        }


        Result result = null;
        String sqlStatement = null;


        log.debug( "About to lookup connection" );
        
        try {

View Full Code Here

        if ((startRow < 0) || (maxRows < -1)) {
            throw new JspException(
                Resources.getMessage("PARAM_BAD_VALUE"));
        }


  Result result = null;
  /* 
   * Note! We must not use the setMaxRows() method on the
   * the statement to limit the number of rows, since the
   * Result factory must be able to figure out the correct
   * value for isLimitedByMaxRows(); there's no way to check

View Full Code Here

         */
        if ((startRow < 0) || (maxRows < -1)) {
            throw new JspException(Resources.getMessage("PARAM_BAD_VALUE"));
        }


        Result result = null;
        /* 
         * Note! We must not use the setMaxRows() method on the
         * the statement to limit the number of rows, since the
         * Result factory must be able to figure out the correct
         * value for isLimitedByMaxRows(); there's no way to check

View Full Code Here


        while (startRow-- > 0 && rs.next()) {
        }
      }


      Result result;
      if (_maxRows != null)
        result = new ResultImpl(rs, (int) _maxRows.evalLong(env));
      else
        result = new ResultImpl(rs, -1);

View Full Code Here

0 1

TOP

Related Classes of javax.servlet.jsp.jstl.sql.Result

com.caucho.jstl.el.SqlQueryTag

com.caucho.jstl.rt.SqlQueryTag

de.danet.an.util.jellytags.UnivQueryTag

org.apache.commons.jelly.tags.sql.QueryTag

org.apache.taglibs.standard.tag.common.sql.QueryTagSupport

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.