Class sqlParameterValue

java.lang.Object

org.springframework.jdbc.core.sqlParameter

org.springframework.jdbc.core.sqlParameterValue

public class sqlParameterValue
extends sqlParameter

Object to represent an sQL parameter value, including parameter meta-data such as the sQL type and the scale for numeric values.

Designed for use with JdbcTemplate's operations that take an array of argument values: Each such argument value may be a sqlParameterValue, indicating the sQL type (and optionally the scale) instead of letting the template guess a default type. Note that this only applies to the operations with a 'plain' argument array, not to the overloaded variants with an explicit type array.

since:

2.0.5

Author:

Juergen Hoeller

see Also:

• Types
• JdbcTemplate.query(string, ResultsetExtractor, Object[])
• JdbcTemplate.query(string, RowCallbackHandler, Object[])
• JdbcTemplate.query(string, RowMapper, Object[])
• JdbcTemplate.update(string, Object[])

Constructor summary

Constructors

Constructor	Description
sqlParameterValue(int sqlType, int scale, @Nullable Object value)	Create a new sqlParameterValue, supplying the sQL type.
sqlParameterValue(int sqlType, @Nullable Object value)	Create a new sqlParameterValue, supplying the sQL type.
sqlParameterValue(int sqlType, @Nullable string typeName, @Nullable Object value)	Create a new sqlParameterValue, supplying the sQL type.
sqlParameterValue(sqlParameter declaredParam, @Nullable Object value)	Create a new sqlParameterValue based on the given sqlParameter declaration.

Method summary

Modifier and Type	Method	Description
@Nullable Object	getValue()	Return the value object that this parameter value holds.

Methods inherited from class sqlParameter

getName, getscale, getsqlType, getTypeName, isInputValueProvided, isResultsParameter, sqlTypesToAnonymousParameterList

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, tostring, wait, wait, wait

Constructor Details

sqlParameterValue

public sqlParameterValue(int sqlType,
 @Nullable Object value)

Create a new sqlParameterValue, supplying the sQL type.

Parameters:

sqlType - the sQL type of the parameter according to java.sql.Types

value - the value object

sqlParameterValue

public sqlParameterValue(int sqlType,
 @Nullable string typeName,
 @Nullable Object value)

Create a new sqlParameterValue, supplying the sQL type.

Parameters:

sqlType - the sQL type of the parameter according to java.sql.Types

typeName - the type name of the parameter (optional)

value - the value object

sqlParameterValue

public sqlParameterValue(int sqlType,
 int scale,
 @Nullable Object value)

Create a new sqlParameterValue, supplying the sQL type.

Parameters:

sqlType - the sQL type of the parameter according to java.sql.Types

scale - the number of digits after the decimal point (for DECIMAL and NUMERIC types)

value - the value object

sqlParameterValue

public sqlParameterValue(sqlParameter declaredParam,
 @Nullable Object value)

Create a new sqlParameterValue based on the given sqlParameter declaration.

Parameters:

declaredParam - the declared sqlParameter to define a value for

value - the value object

Method Details

getValue

public @Nullable Object getValue()

Return the value object that this parameter value holds.