类 StatementCreatorUtils

字段详细资料

• IGNORE_GETPARAMETERTYPE_PROPERTY_NAME

  public static final String IGNORE_GETPARAMETERTYPE_PROPERTY_NAME

  System property that instructs Spring to ignore ParameterMetaData.getParameterType(int) completely, i.e. to never even attempt to retrieve PreparedStatement.getParameterMetaData() for setNull(java.sql.PreparedStatement, int, int, java.lang.String) calls.

  The effective default is "false", trying getParameterType calls first and falling back to PreparedStatement.setNull(int, int) / PreparedStatement.setObject(int, java.lang.Object, int) calls based on well-known behavior of common databases. Spring records JDBC drivers with non-working getParameterType implementations and won't attempt to call that method for that driver again, always falling back.

  Consider switching this flag to "true" if you experience misbehavior at runtime, e.g. with connection pool issues in case of an exception thrown from getParameterType (as reported on JBoss AS 7) or in case of performance problems (as reported on PostgreSQL).

  Note that this flag is "true" by default on Oracle 12c since there can be leaks created by getParameterType calls in such a scenario. You need to explicitly set the flag to "false" in order to enforce the use of getParameterType against Oracle drivers.

  另请参阅:

  常量字段值

构造器详细资料

• StatementCreatorUtils

  public StatementCreatorUtils()

方法详细资料

• javaTypeToSqlParameterType

  public static int javaTypeToSqlParameterType​(Class<?> javaType)

  Derive a default SQL type from the given Java type.

  参数:

  javaType - the Java type to translate

  返回:

  the corresponding SQL type, or SqlTypeValue.TYPE_UNKNOWN if none found

• 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.

  参数:

  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

  抛出:

  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.

  参数:

  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)

  抛出:

  SQLException - if thrown by PreparedStatement methods

  另请参阅:

  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.

  参数:

  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)

  抛出:

  SQLException - if thrown by PreparedStatement methods

  另请参阅:

  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.

  参数:

  paramValues - parameter values supplied. May be null.

  另请参阅:

  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.

  参数:

  paramValues - parameter values supplied. May be null.

  另请参阅:

  DisposableSqlTypeValue.cleanup(), SqlLobValue.cleanup()