JSTL sql
Tag query


Executes the SQL query defined in its body or through the sql attribute.


Tag Information
Tag Classorg.apache.taglibs.standard.tag.rt.sql.QueryTag
TagExtraInfo ClassNone
Body ContentJSP
Display NameNone

Attributes
NameRequiredRequest-timeTypeDescription
vartruefalsejava.lang.String Name of the exported scoped variable for the query result. The type of the scoped variable is javax.servlet.jsp.jstl.sql. Result (see Chapter 16 "Java APIs").
scopefalsefalsejava.lang.String Scope of var.
sqlfalsetruejava.lang.String SQL query statement.
dataSourcefalsetruejava.lang.String Data source associated with the database to query. A String value represents a relative path to a JNDI resource or the parameters for the DriverManager class.
startRowfalsetruejava.lang.String The returned Result object includes the rows starting at the specified index. The first row of the original query result set is at index 0. If not specified, rows are included starting from the first row at index 0.
maxRowsfalsetruejava.lang.String The maximum number of rows to be included in the query result. If not specified, or set to -1, no limit on the maximum number of rows is enforced.

Variables
No Variables Defined.


Output Generated by TLDDoc. Java, JSP, and JavaServer Pages are trademarks or registered trademarks of Sun Microsystems, Inc. in the US and other countries. Copyright 2002-3 Sun Microsystems, Inc. 4150 Network Circle Santa Clara, CA 95054, U.S.A. All Rights Reserved.