站内搜索: 请输入搜索关键词
当前页面: 在线文档首页 > Spring Framework 2.0.5 API 文档英文版

StatementCreatorUtils (Spring Framework API 2.0) - Spring Framework 2.0.5 API 文档英文版

The Spring Framework

org.springframework.jdbc.core
Class StatementCreatorUtils

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

public abstract class StatementCreatorUtils
extends Object

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.

Since:
1.1
Author:
Thomas Risberg, Juergen Hoeller
See Also:
PreparedStatementSetter, 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, Object inValue)
          Set the value for a parameter.
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.
 
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 param,
                                     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
param - 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,
                                     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
inValue - the value to set (plain value or a SqlTypeValue)
Throws:
SQLException - if thrown by PreparedStatement methods
See Also:
SqlTypeValue

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 (plain value or a SqlTypeValue)
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()

The Spring Framework

Copyright © 2002-2007 The Spring Framework.