public abstract class StatementCreatorUtils extends Object
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 and Description |
|---|
StatementCreatorUtils() |
| Modifier and Type | Method and Description |
|---|---|
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.
|
public static int javaTypeToSqlParameterType(Class javaType)
javaType - the Java type to translatenull if none foundpublic 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 setSQLException - if thrown by PreparedStatement methodspublic 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 methodsSqlTypeValuepublic 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()