javax.servlet.jsp.jstl.sql

## Interface 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

- - ### Method Summary

    Methods
    Modifier and Type | Method and Description
    --- | ---
    `void` | `addSQLParameter(Object value)` Adds a PreparedStatement parameter value.

- - ### Method Detail

    - #### addSQLParameter

          void addSQLParameter(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.
      Parameters:
        `value` - the `PreparedStatement` parameter value

Copyright © 1996-2013, Oracle and/or its affiliates. All Rights Reserved. Use is subject to license terms.