org.springframework.jdbc.core
Class StatementCreatorUtils

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

public class StatementCreatorUtils
extends Object

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

Used by PreparedStatementCreatorFactory and CallableStatementCreatorFactory.

Since:

1.1

Author:

Thomas Risberg, Juergen Hoeller

See Also:

PreparedStatementCreator, CallableStatementCreator, PreparedStatementCreatorFactory, CallableStatementCreatorFactory, SqlParameter, SqlTypeValue, SqlLobValue

Constructor Summary

StatementCreatorUtils()

Method Summary

static void	cleanupParameters(Collection paramValues) Clean up all resources held by parameter values which were passed to an execute method.
static void	cleanupParameters(Object[] paramValues) Clean up all resources held by parameter values which were passed to an execute method.
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 declaredParam, Object inValue) Set the value for a parameter.

Methods inherited from class java.lang.Object

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

Constructor Detail

StatementCreatorUtils

public StatementCreatorUtils()

Method Detail

setParameterValue

public static void setParameterValue(PreparedStatement ps,
                                     int paramIndex,
                                     SqlParameter declaredParam,
                                     Object inValue)
                              throws SQLException

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

declaredParam - the parameter as it is declared including type

inValue - the value to set

Throws:

SQLException - if thrown by PreparedStatement methods

setParameterValue

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

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

Throws:

SQLException - if thrown by PreparedStatement methods

See Also:

SqlTypeValue

cleanupParameters

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.

See Also:

DisposableSqlTypeValue.cleanup(), SqlLobValue.cleanup()

cleanupParameters

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.

See Also:

DisposableSqlTypeValue.cleanup(), SqlLobValue.cleanup()