public abstract class

StatementCreatorUtils

extends Object
java.lang.Object
   ↳ org.springframework.jdbc.core.StatementCreatorUtils

Class Overview

Utility methods for PreparedStatementSetter/Creator and CallableStatementCreator implementations, providing sophisticated parameter management (including support for LOB values).

Used by PreparedStatementCreatorFactory and CallableStatementCreatorFactory, but also available for direct use in custom setter/creator implementations.

Summary

Public Constructors
StatementCreatorUtils()
Public Methods
static void cleanupParameters(Object[] paramValues)
Clean up all resources held by parameter values which were passed to an execute method.
static void cleanupParameters(Collection paramValues)
Clean up all resources held by parameter values which were passed to an execute method.
static int javaTypeToSqlParameterType(Class javaType)
Derive a default SQL type from the given Java type.
static void setParameterValue(PreparedStatement ps, int paramIndex, int sqlType, String typeName, Object inValue)
Set the value for a parameter.
static void setParameterValue(PreparedStatement ps, int paramIndex, SqlParameter param, Object inValue)
Set the value for a parameter.
static void setParameterValue(PreparedStatement ps, int paramIndex, int sqlType, Object inValue)
Set the value for a parameter.
[Expand]
Inherited Methods
From class java.lang.Object

Public Constructors

public StatementCreatorUtils ()

Public Methods

public static void cleanupParameters (Object[] paramValues)

Clean up all resources held by parameter values which were passed to an execute method. This is for example important for closing LOB values.

Parameters
paramValues parameter values supplied. May be null.

public static void cleanupParameters (Collection paramValues)

Clean up all resources held by parameter values which were passed to an execute method. This is for example important for closing LOB values.

Parameters
paramValues parameter values supplied. May be null.

public static int javaTypeToSqlParameterType (Class javaType)

Derive a default SQL type from the given Java type.

Parameters
javaType the Java type to translate
Returns
  • the corresponding SQL type, or null if none found

public static void setParameterValue (PreparedStatement ps, int paramIndex, int sqlType, String typeName, Object inValue)

Set the value for a parameter. The method used is based on the SQL type of the parameter and we can handle complex types like arrays and LOBs.

Parameters
ps the prepared statement or callable statement
paramIndex index of the parameter we are setting
sqlType the SQL type of the parameter
typeName the type name of the parameter (optional, only used for SQL NULL and SqlTypeValue)
inValue the value to set (plain value or a SqlTypeValue)
Throws
SQLException if thrown by PreparedStatement methods
See Also

public static void setParameterValue (PreparedStatement ps, int paramIndex, SqlParameter param, Object inValue)

Set the value for a parameter. The method used is based on the SQL type of the parameter and we can handle complex types like arrays and LOBs.

Parameters
ps the prepared statement or callable statement
paramIndex index of the parameter we are setting
param the parameter as it is declared including type
inValue the value to set
Throws
SQLException if thrown by PreparedStatement methods

public static void setParameterValue (PreparedStatement ps, int paramIndex, int sqlType, Object inValue)

Set the value for a parameter. The method used is based on the SQL type of the parameter and we can handle complex types like arrays and LOBs.

Parameters
ps the prepared statement or callable statement
paramIndex index of the parameter we are setting
sqlType the SQL type of the parameter
inValue the value to set (plain value or a SqlTypeValue)
Throws
SQLException if thrown by PreparedStatement methods
See Also