Tags 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.StringName of the exported scoped variable for the query result. The type of the scoped variable is jakarta.servlet.jsp.jstl.sql. Result (see Chapter 16 "Java APIs").
scopefalsefalsejava.lang.StringScope of var.
sqlfalsetruejava.lang.StringSQL query statement.
dataSourcefalsetruejava.lang.StringData 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.StringThe 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.StringThe 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.


Copyright © 2018, 2022 Eclipse Foundation. All rights reserved.
Use is subject to license terms.