JSTL sql
Tag query
Executes the SQL query defined in its body or through the
sql attribute.
Tag Information
Tag Class org.apache.taglibs.standard.tag.rt.sql.QueryTag
TagExtraInfo Class None
Body Content JSP
Display Name None
Attributes
Name Required Request-time Type Description
var true false java.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").
scope false false java.lang.String
Scope of var.
sql false true java.lang.String
SQL query statement.
dataSource false true java.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.
startRow false true java.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.
maxRows false true java.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.