Class SqlInOutParameter


public class SqlInOutParameter extends SqlOutParameter
Subclass of SqlOutParameter to represent an INOUT parameter. Will return true for SqlParameter's isInputValueProvided() test, in contrast to a standard SqlOutParameter.

Output parameters - like all stored procedure parameters - must have names.

Since:
2.0
Author:
Thomas Risberg, Juergen Hoeller
  • Constructor Details

    • SqlInOutParameter

      public SqlInOutParameter(String name, int sqlType)
      Create a new SqlInOutParameter.
      Parameters:
      name - the name of the parameter, as used in input and output maps
      sqlType - the parameter SQL type according to java.sql.Types
    • SqlInOutParameter

      public SqlInOutParameter(String name, int sqlType, int scale)
      Create a new SqlInOutParameter.
      Parameters:
      name - the name of the parameter, as used in input and output maps
      sqlType - the parameter SQL type according to java.sql.Types
      scale - the number of digits after the decimal point (for DECIMAL and NUMERIC types)
    • SqlInOutParameter

      public SqlInOutParameter(String name, int sqlType, String typeName)
      Create a new SqlInOutParameter.
      Parameters:
      name - the name of the parameter, as used in input and output maps
      sqlType - the parameter SQL type according to java.sql.Types
      typeName - the type name of the parameter (optional)
    • SqlInOutParameter

      public SqlInOutParameter(String name, int sqlType, String typeName, SqlReturnType sqlReturnType)
      Create a new SqlInOutParameter.
      Parameters:
      name - the name of the parameter, as used in input and output maps
      sqlType - the parameter SQL type according to java.sql.Types
      typeName - the type name of the parameter (optional)
      sqlReturnType - custom value handler for complex type (optional)
    • SqlInOutParameter

      public SqlInOutParameter(String name, int sqlType, ResultSetExtractor<?> rse)
      Create a new SqlInOutParameter.
      Parameters:
      name - the name of the parameter, as used in input and output maps
      sqlType - the parameter SQL type according to java.sql.Types
      rse - the ResultSetExtractor to use for parsing the ResultSet
    • SqlInOutParameter

      public SqlInOutParameter(String name, int sqlType, RowCallbackHandler rch)
      Create a new SqlInOutParameter.
      Parameters:
      name - the name of the parameter, as used in input and output maps
      sqlType - the parameter SQL type according to java.sql.Types
      rch - the RowCallbackHandler to use for parsing the ResultSet
    • SqlInOutParameter

      public SqlInOutParameter(String name, int sqlType, RowMapper<?> rm)
      Create a new SqlInOutParameter.
      Parameters:
      name - the name of the parameter, as used in input and output maps
      sqlType - the parameter SQL type according to java.sql.Types
      rm - the RowMapper to use for parsing the ResultSet
  • Method Details