FileDocCategorySizeDatePackage
SQLExecutionTag.javaAPI DocGlassfish v2 API3893Sat May 05 19:17:14 BST 2007javax.servlet.jsp.jstl.sql

SQLExecutionTag

public interface SQLExecutionTag

This interface allows tag handlers implementing it to receive values for parameter markers in their SQL statements.

This interface is implemented by both <sql:query> and <sql:update>. Its addSQLParameter() method is called by nested parameter actions (such as <sql:param>) to substitute PreparedStatement parameter values for "?" parameter markers in the SQL statement of the enclosing SQLExecutionTag action.

The given parameter values are converted to their corresponding SQL type (following the rules in the JDBC specification) before they are sent to the database.

Keeping track of the index of the parameter values being added is the responsibility of the tag handler implementing this interface

The SQLExcecutionTag interface is exposed in order to support custom parameter actions which may retrieve their parameters from any source and process them before substituting them for a parameter marker in the SQL statement of the enclosing SQLExecutionTag action

author
Justyna Horwat

Fields Summary
Constructors Summary
Methods Summary
public voidaddSQLParameter(java.lang.Object value)
Adds a PreparedStatement parameter value. Must behave as if it calls PreparedStatement.setObject(int, Object). For each tag invocation, the integral index passed logically to setObject() must begin with 1 and must be incremented by 1 for each subsequent invocation of addSQLParameter(). The Object logically passed to setObject() must be the unmodified object received in the value argument.

param
value the PreparedStatement parameter value