SQL Tag Library - Tag Documentation

Tag Documentation

[tag libraries] [tags]

The following document contains a summary of all theJellytag libraries.

Tag Libraries

[tag libraries] [tags]

Library

Description

jelly:sql

The SQL Tags from the JSTL

There are some examples of these tags in action here

jelly:sql

The SQL Tags from the JSTL

There are some examples of these tags in action here

Tag Name	Description
dateParam	Tag handler for <Param>in JSTL, used to setparameter values for a SQL statement.
driver	Tag handler for <Driver>in JSTL, used to createa simple DataSource for prototyping.
param	Tag handler for <Param>in JSTL, used to setparameter values for a SQL statement.
query	Tag handler for <Query>in JSTL.
resultSet	This Tag creates a result set object based on its body content via child row tags.This tag is useful for unit testing with Mock Tags to simulate the results returned by databases.
row	Adds a new row to a parent <resultSet>Tag.This tag is useful for unit testing with Mock Tags to simulate the results returned by databases.
setDataSource	Tag handler for <SetDataSource>in JSTL, used to createa simple DataSource for prototyping.
transaction	Tag handler for <Transaction>in JSTL.
update	Tag handler for <Update>in JSTL.

Tags

[tag libraries] [tags]

sql:dateParam

Tag handler for <Param>in JSTL, used to setparameter values for a SQL statement.

Attribute Name	Type	Description
escapeText	boolean
trim	boolean
type	java.lang.String
value	java.sql.Date

sql:driver

Tag handler for <Driver>in JSTL, used to createa simple DataSource for prototyping.

Attribute Name	Type	Description
driver	java.lang.String
escapeText	boolean
jdbcURL	java.lang.String
scope	java.lang.String	Sets the scope of the variable to hold theresult.
trim	boolean
userName	java.lang.String
var	java.lang.String

sql:param

Tag handler for <Param>in JSTL, used to setparameter values for a SQL statement.

Attribute Name	Type	Description
escapeText	boolean
trim	boolean
value	java.lang.Object

sql:query

Tag handler for <Query>in JSTL.

Attribute Name	Type	Description
dataSource	java.lang.Object	Sets the SQL DataSource. DataSource can bea String or a DataSource object.
escapeText	boolean
maxRows	int	Query result can be limited by specifyingthe maximum number of rows returned.
scope	java.lang.String	Sets the scope of the variable to hold theresult.
sql	java.lang.String	Sets the SQL statement to use for thequery. The statement may contain parameter markers(question marks, ?). If so, the parameter values mustbe set using nested value elements.
startRow	int	The index of the first row returned can bespecified using startRow.
trim	boolean
var	java.lang.String	Sets the name of the variable to hold theresult.

sql:resultSet

This Tag creates a result set object based on its body content via child row tags.This tag is useful for unit testing with Mock Tags to simulate the results returned by databases.

Attribute Name	Type	Description
escapeText	boolean
trim	boolean
var	java.lang.String	Sets the variable to export the result set to.

sql:row

Adds a new row to a parent <resultSet>Tag.This tag is useful for unit testing with Mock Tags to simulate the results returned by databases.

Attribute Name	Type	Description
escapeText	boolean
trim	boolean

sql:setDataSource

Tag handler for <SetDataSource>in JSTL, used to createa simple DataSource for prototyping.

Attribute Name	Type	Description
dataSource	java.lang.Object
driver	java.lang.String
escapeText	boolean
password	java.lang.String
scope	java.lang.String	Sets the scope of the variable to hold theresult.
trim	boolean
url	java.lang.String
user	java.lang.String
var	java.lang.String

sql:transaction

Tag handler for <Transaction>in JSTL.

Attribute Name	Type	Description
dataSource	java.lang.Object	Sets the SQL DataSource. DataSource can bea String or a DataSource object.
escapeText	boolean
isolation	java.lang.String	Sets the transaction isolation level.
trim	boolean

sql:update

Tag handler for <Update>in JSTL.

Attribute Name	Type	Description
dataSource	java.lang.Object	Sets the SQL DataSource. DataSource can bea String or a DataSource object.
escapeText	boolean
scope	java.lang.String	Sets the scope of the variable to hold theresult.
sql	java.lang.String	Sets the SQL statement to use for thequery. The statement may contain parameter markers(question marks, ?). If so, the parameter values mustbe set using nested value elements.
trim	boolean
var	java.lang.String	Sets the name of the variable to hold theresult.