|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.springframework.jdbc.core.StatementCreatorUtils
public abstract class StatementCreatorUtils
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.
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 int |
javaTypeToSqlParameterType(Class javaType)
Derive a default SQL type from the given Java type. |
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 |
|---|
public StatementCreatorUtils()
| Method Detail |
|---|
public static int javaTypeToSqlParameterType(Class javaType)
javaType - the Java type to translate
null if none found
public static void setParameterValue(PreparedStatement ps,
int paramIndex,
SqlParameter param,
Object inValue)
throws SQLException
ps - the prepared statement or callable statementparamIndex - index of the parameter we are settingparam - the parameter as it is declared including typeinValue - the value to set
SQLException - if thrown by PreparedStatement methods
public static void setParameterValue(PreparedStatement ps,
int paramIndex,
int sqlType,
Object inValue)
throws SQLException
ps - the prepared statement or callable statementparamIndex - index of the parameter we are settingsqlType - the SQL type of the parameterinValue - the value to set (plain value or a SqlTypeValue)
SQLException - if thrown by PreparedStatement methodsSqlTypeValue
public static void setParameterValue(PreparedStatement ps,
int paramIndex,
int sqlType,
String typeName,
Object inValue)
throws SQLException
ps - the prepared statement or callable statementparamIndex - index of the parameter we are settingsqlType - the SQL type of the parametertypeName - the type name of the parameter
(optional, only used for SQL NULL and SqlTypeValue)inValue - the value to set (plain value or a SqlTypeValue)
SQLException - if thrown by PreparedStatement methodsSqlTypeValuepublic static void cleanupParameters(Object[] paramValues)
paramValues - parameter values supplied. May be null.DisposableSqlTypeValue.cleanup(),
SqlLobValue.cleanup()public static void cleanupParameters(Collection paramValues)
paramValues - parameter values supplied. May be null.DisposableSqlTypeValue.cleanup(),
SqlLobValue.cleanup()
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||