public abstract class StatementCreatorUtils
extends java.lang.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(java.util.Collection paramValues)
Clean up all resources held by parameter values which were passed to an
execute method.
|
static void |
cleanupParameters(java.lang.Object[] paramValues)
Clean up all resources held by parameter values which were passed to an
execute method.
|
static int |
javaTypeToSqlParameterType(java.lang.Class javaType)
Derive a default SQL type from the given Java type.
|
static void |
setParameterValue(java.sql.PreparedStatement ps,
int paramIndex,
int sqlType,
java.lang.Object inValue)
Set the value for a parameter.
|
static void |
setParameterValue(java.sql.PreparedStatement ps,
int paramIndex,
int sqlType,
java.lang.String typeName,
java.lang.Object inValue)
Set the value for a parameter.
|
static void |
setParameterValue(java.sql.PreparedStatement ps,
int paramIndex,
SqlParameter param,
java.lang.Object inValue)
Set the value for a parameter.
|
public static int javaTypeToSqlParameterType(java.lang.Class javaType)
javaType - the Java type to translatenull if none foundpublic static void setParameterValue(java.sql.PreparedStatement ps,
int paramIndex,
SqlParameter param,
java.lang.Object inValue)
throws java.sql.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 setjava.sql.SQLException - if thrown by PreparedStatement methodspublic static void setParameterValue(java.sql.PreparedStatement ps,
int paramIndex,
int sqlType,
java.lang.Object inValue)
throws java.sql.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)java.sql.SQLException - if thrown by PreparedStatement methodsSqlTypeValuepublic static void setParameterValue(java.sql.PreparedStatement ps,
int paramIndex,
int sqlType,
java.lang.String typeName,
java.lang.Object inValue)
throws java.sql.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)java.sql.SQLException - if thrown by PreparedStatement methodsSqlTypeValuepublic static void cleanupParameters(java.lang.Object[] paramValues)
paramValues - parameter values supplied. May be null.DisposableSqlTypeValue.cleanup(),
SqlLobValue.cleanup()public static void cleanupParameters(java.util.Collection paramValues)
paramValues - parameter values supplied. May be null.DisposableSqlTypeValue.cleanup(),
SqlLobValue.cleanup()