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

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

  另请参阅:

  常量字段值

构造器详细资料

• StatementCreatorUtils

  public StatementCreatorUtils()

方法详细资料

• javaTypeToSqlParameterType

  public static int javaTypeToSqlParameterType​(@Nullable
                                               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,
                                       @Nullable
                                       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,
                                       @Nullable
                                       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 an SqlTypeValue)

  抛出:

  SQLException - if thrown by PreparedStatement methods

  另请参阅:

  SqlTypeValue

• setParameterValue

  public static void setParameterValue​(PreparedStatement ps,
                                       int paramIndex,
                                       int sqlType,
                                       String typeName,
                                       @Nullable
                                       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 an SqlTypeValue)

  抛出:

  SQLException - if thrown by PreparedStatement methods

  另请参阅:

  SqlTypeValue

• cleanupParameters

  public static void cleanupParameters​(@Nullable
                                       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​(@Nullable
                                       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()