A C D G H I J M O P Q R S T U V

A

addRow(Map) - Method in class org.apache.commons.jelly.tags.sql.ResultSetTag

Adds the given row to the list of rows

addSQLParameter(Object) - Method in class org.apache.commons.jelly.tags.sql.SqlTagSupport

Called by nested parameter elements to add PreparedStatement parameter values.

C

clearParameters() - Method in class org.apache.commons.jelly.tags.sql.SqlTagSupport

D

DataSourceUtil - class org.apache.commons.jelly.tags.sql.DataSourceUtil.

A simple DataSource utility for the standard DriverManager class.

DataSourceUtil() - Constructor for class org.apache.commons.jelly.tags.sql.DataSourceUtil

DataSourceWrapper - class org.apache.commons.jelly.tags.sql.DataSourceWrapper.

A simple DataSource wrapper for the standard DriverManager class.

DataSourceWrapper() - Constructor for class org.apache.commons.jelly.tags.sql.DataSourceWrapper

DateParamTag - class org.apache.commons.jelly.tags.sql.DateParamTag.

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

DateParamTag() - Constructor for class org.apache.commons.jelly.tags.sql.DateParamTag

DriverTag - class org.apache.commons.jelly.tags.sql.DriverTag.

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

DriverTag() - Constructor for class org.apache.commons.jelly.tags.sql.DriverTag

dataSource - Variable in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

dataSourceSpecified - Variable in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

dataSourceSpecified - Variable in class org.apache.commons.jelly.tags.sql.SqlTagSupport

dataSourceSpecified - Variable in class org.apache.commons.jelly.tags.sql.TransactionTag

doFinally() - Method in class org.apache.commons.jelly.tags.sql.TransactionTag

Restores the Connection to its initial state and closes it.

doTag(XMLOutput) - Method in class org.apache.commons.jelly.tags.sql.DateParamTag

doTag(XMLOutput) - Method in class org.apache.commons.jelly.tags.sql.DriverTag

doTag(XMLOutput) - Method in class org.apache.commons.jelly.tags.sql.ParamTag

doTag(XMLOutput) - Method in class org.apache.commons.jelly.tags.sql.QueryTag

Execute the SQL statement, set either through the sql attribute or as the body, and save the result as a variable named by the var attribute in the scope specified by the scope attribute, as an object that implements the Result interface.

doTag(XMLOutput) - Method in class org.apache.commons.jelly.tags.sql.ResultSetTag

doTag(XMLOutput) - Method in class org.apache.commons.jelly.tags.sql.RowTag

doTag(XMLOutput) - Method in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

doTag(XMLOutput) - Method in class org.apache.commons.jelly.tags.sql.TransactionTag

Prepares for execution by setting the initial state, such as getting the Connection and preparing it for the transaction.

doTag(XMLOutput) - Method in class org.apache.commons.jelly.tags.sql.UpdateTag

Execute the SQL statement, set either through the sql attribute or as the body, and save the result as a variable named by the var attribute in the scope specified by the scope attribute, as an object that implements the Result interface.

driverClassName - Variable in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

G

getColumnNames() - Method in class org.apache.commons.jelly.tags.sql.ResultImpl

Returns an array of String objects.

getConnection() - Method in class org.apache.commons.jelly.tags.sql.DataSourceWrapper

Returns a Connection using the DriverManager and all set properties.

getConnection(String, String) - Method in class org.apache.commons.jelly.tags.sql.DataSourceWrapper

Always throws a SQLException.

getConnection() - Method in class org.apache.commons.jelly.tags.sql.SqlTagSupport

getInitParameter(String) - Method in class org.apache.commons.jelly.tags.sql.DriverTag

getLogWriter() - Method in class org.apache.commons.jelly.tags.sql.DataSourceWrapper

Always throws a SQLException.

getLoginTimeout() - Method in class org.apache.commons.jelly.tags.sql.DataSourceWrapper

Always throws a SQLException.

getRowCount() - Method in class org.apache.commons.jelly.tags.sql.ResultImpl

Returns the number of rows in the cached ResultSet

getRows() - Method in class org.apache.commons.jelly.tags.sql.ResultImpl

Returns an array of SortedMap objects.

getRowsByIndex() - Method in class org.apache.commons.jelly.tags.sql.ResultImpl

Returns an array of Object[] objects.

getSharedConnection() - Method in class org.apache.commons.jelly.tags.sql.TransactionTag

Called by nested parameter elements to get a reference to the Connection.

H

hasParameters() - Method in class org.apache.commons.jelly.tags.sql.SqlTagSupport

I

isLimitedByMaxRows() - Method in class org.apache.commons.jelly.tags.sql.ResultImpl

Returns true of the query was limited by a maximum row setting

isPartOfTransaction - Variable in class org.apache.commons.jelly.tags.sql.SqlTagSupport

J

jdbcURL - Variable in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

M

maxRows - Variable in class org.apache.commons.jelly.tags.sql.QueryTag

maxRowsSpecified - Variable in class org.apache.commons.jelly.tags.sql.QueryTag

O

org.apache.commons.jelly.tags.sql - package org.apache.commons.jelly.tags.sql

The SQL Tags from the JSTL There are some examples of these tags in action here

P

ParamTag - class org.apache.commons.jelly.tags.sql.ParamTag.

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

ParamTag() - Constructor for class org.apache.commons.jelly.tags.sql.ParamTag

password - Variable in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

Q

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

Tag handler for <Query> in JSTL.

QueryTag() - Constructor for class org.apache.commons.jelly.tags.sql.QueryTag

R

ResultImpl - class org.apache.commons.jelly.tags.sql.ResultImpl.

This class creates a cached version of a ResultSet.

ResultImpl(ResultSet, int, int) - Constructor for class org.apache.commons.jelly.tags.sql.ResultImpl

This constructor reads the ResultSet and saves a cached copy.

ResultImpl(List) - Constructor for class org.apache.commons.jelly.tags.sql.ResultImpl

This constructor is given a List of Maps where each Map represents a Row of data.

ResultSetTag - class org.apache.commons.jelly.tags.sql.ResultSetTag.

This Tag creates a result set object based on its body content via child row tags.

ResultSetTag() - Constructor for class org.apache.commons.jelly.tags.sql.ResultSetTag

RowTag - class org.apache.commons.jelly.tags.sql.RowTag.

Adds a new row to a parent <resultSet> Tag.

RowTag() - Constructor for class org.apache.commons.jelly.tags.sql.RowTag

rawDataSource - Variable in class org.apache.commons.jelly.tags.sql.SqlTagSupport

rawDataSource - Variable in class org.apache.commons.jelly.tags.sql.TransactionTag

S

SetDataSourceTag - class org.apache.commons.jelly.tags.sql.SetDataSourceTag.

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

SetDataSourceTag() - Constructor for class org.apache.commons.jelly.tags.sql.SetDataSourceTag

SqlTagLibrary - class org.apache.commons.jelly.tags.sql.SqlTagLibrary.

Describes the Taglib.

SqlTagLibrary() - Constructor for class org.apache.commons.jelly.tags.sql.SqlTagLibrary

SqlTagSupport - class org.apache.commons.jelly.tags.sql.SqlTagSupport.

Abstract base class for any SQL related tag in JSTL.

SqlTagSupport() - Constructor for class org.apache.commons.jelly.tags.sql.SqlTagSupport

scope - Variable in class org.apache.commons.jelly.tags.sql.SqlTagSupport

setDataSource(Object) - Method in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

setDataSource(Object) - Method in class org.apache.commons.jelly.tags.sql.SqlTagSupport

Sets the SQL DataSource.

setDataSource(Object) - Method in class org.apache.commons.jelly.tags.sql.TransactionTag

Sets the SQL DataSource.

setDriver(String) - Method in class org.apache.commons.jelly.tags.sql.DriverTag

setDriver(String) - Method in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

setDriverClassName(String) - Method in class org.apache.commons.jelly.tags.sql.DataSourceWrapper

setIsolation(String) - Method in class org.apache.commons.jelly.tags.sql.TransactionTag

Sets the transaction isolation level.

setJdbcURL(String) - Method in class org.apache.commons.jelly.tags.sql.DataSourceWrapper

setJdbcURL(String) - Method in class org.apache.commons.jelly.tags.sql.DriverTag

setLogWriter(PrintWriter) - Method in class org.apache.commons.jelly.tags.sql.DataSourceWrapper

Always throws a SQLException.

setLoginTimeout(int) - Method in class org.apache.commons.jelly.tags.sql.DataSourceWrapper

Always throws a SQLException.

setMaxRows(int) - Method in class org.apache.commons.jelly.tags.sql.QueryTag

Query result can be limited by specifying the maximum number of rows returned.

setParameters(PreparedStatement) - Method in class org.apache.commons.jelly.tags.sql.SqlTagSupport

setPassword(String) - Method in class org.apache.commons.jelly.tags.sql.DataSourceWrapper

setPassword(String) - Method in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

setScope(String) - Method in class org.apache.commons.jelly.tags.sql.DriverTag

Sets the scope of the variable to hold the result.

setScope(String) - Method in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

Sets the scope of the variable to hold the result.

setScope(String) - Method in class org.apache.commons.jelly.tags.sql.SqlTagSupport

Sets the scope of the variable to hold the result.

setSql(String) - Method in class org.apache.commons.jelly.tags.sql.SqlTagSupport

Sets the SQL statement to use for the query.

setStartRow(int) - Method in class org.apache.commons.jelly.tags.sql.QueryTag

The index of the first row returned can be specified using startRow.

setType(String) - Method in class org.apache.commons.jelly.tags.sql.DateParamTag

setUrl(String) - Method in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

setUser(String) - Method in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

setUserName(String) - Method in class org.apache.commons.jelly.tags.sql.DataSourceWrapper

setUserName(String) - Method in class org.apache.commons.jelly.tags.sql.DriverTag

setValue(Date) - Method in class org.apache.commons.jelly.tags.sql.DateParamTag

setValue(Object) - Method in class org.apache.commons.jelly.tags.sql.ParamTag

setVar(String) - Method in class org.apache.commons.jelly.tags.sql.DriverTag

setVar(String) - Method in class org.apache.commons.jelly.tags.sql.ResultSetTag

Sets the variable to export the result set to.

setVar(String) - Method in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

setVar(String) - Method in class org.apache.commons.jelly.tags.sql.SqlTagSupport

Sets the name of the variable to hold the result.

sql - Variable in class org.apache.commons.jelly.tags.sql.SqlTagSupport

startRow - Variable in class org.apache.commons.jelly.tags.sql.QueryTag

T

TransactionTag - class org.apache.commons.jelly.tags.sql.TransactionTag.

Tag handler for <Transaction> in JSTL.

TransactionTag() - Constructor for class org.apache.commons.jelly.tags.sql.TransactionTag

type - Variable in class org.apache.commons.jelly.tags.sql.DateParamTag

U

UpdateTag - class org.apache.commons.jelly.tags.sql.UpdateTag.

Tag handler for <Update> in JSTL.

UpdateTag() - Constructor for class org.apache.commons.jelly.tags.sql.UpdateTag

userName - Variable in class org.apache.commons.jelly.tags.sql.SetDataSourceTag

V

value - Variable in class org.apache.commons.jelly.tags.sql.DateParamTag

value - Variable in class org.apache.commons.jelly.tags.sql.ParamTag

var - Variable in class org.apache.commons.jelly.tags.sql.SqlTagSupport

A C D G H I J M O P Q R S T U V