类 PreparedStatementCreatorFactory

构造器详细资料

• PreparedStatementCreatorFactory

  public PreparedStatementCreatorFactory​(String sql)

  Create a new factory. Will need to add parameters via the addParameter(org.springframework.jdbc.core.SqlParameter) method or have no parameters.

  参数:

  sql - the SQL statement to execute

• PreparedStatementCreatorFactory

  public PreparedStatementCreatorFactory​(String sql,
                                         int... types)

  Create a new factory with the given SQL and JDBC types.

  参数:

  sql - the SQL statement to execute

  types - int array of JDBC types

• PreparedStatementCreatorFactory

  public PreparedStatementCreatorFactory​(String sql,
                                         List<SqlParameter> declaredParameters)

  Create a new factory with the given SQL and parameters.

  参数:

  sql - the SQL statement to execute

  declaredParameters - list of SqlParameter objects

方法详细资料

• getSql

  public final String getSql()

  Return the SQL statement to execute.

  从以下版本开始:

  5.1.3

• addParameter

  public void addParameter​(SqlParameter param)

  Add a new declared parameter.

  Order of parameter addition is significant.

  参数:

  param - the parameter to add to the list of declared parameters

• setResultSetType

  public void setResultSetType​(int resultSetType)

  Set whether to use prepared statements that return a specific type of ResultSet.

  参数:

  resultSetType - the ResultSet type

  另请参阅:

  ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.TYPE_SCROLL_SENSITIVE

• setUpdatableResults

  public void setUpdatableResults​(boolean updatableResults)

  Set whether to use prepared statements capable of returning updatable ResultSets.

• setReturnGeneratedKeys

  public void setReturnGeneratedKeys​(boolean returnGeneratedKeys)

  Set whether prepared statements should be capable of returning auto-generated keys.

• setGeneratedKeysColumnNames

  public void setGeneratedKeysColumnNames​(String... names)

  Set the column names of the auto-generated keys.

• newPreparedStatementSetter

  public PreparedStatementSetter newPreparedStatementSetter​(@Nullable
                                                            List<?> params)

  Return a new PreparedStatementSetter for the given parameters.

  参数:

  params - list of parameters (may be null)

• newPreparedStatementSetter

  public PreparedStatementSetter newPreparedStatementSetter​(@Nullable
                                                            Object[] params)

  Return a new PreparedStatementSetter for the given parameters.

  参数:

  params - the parameter array (may be null)

• newPreparedStatementCreator

  public PreparedStatementCreator newPreparedStatementCreator​(@Nullable
                                                              List<?> params)

  Return a new PreparedStatementCreator for the given parameters.

  参数:

  params - list of parameters (may be null)

• newPreparedStatementCreator

  public PreparedStatementCreator newPreparedStatementCreator​(@Nullable
                                                              Object[] params)

  Return a new PreparedStatementCreator for the given parameters.

  参数:

  params - the parameter array (may be null)

• newPreparedStatementCreator

  public PreparedStatementCreator newPreparedStatementCreator​(String sqlToUse,
                                                              @Nullable
                                                              Object[] params)

  Return a new PreparedStatementCreator for the given parameters.

  参数:

  sqlToUse - the actual SQL statement to use (if different from the factory's, for example because of named parameter expanding)

  params - the parameter array (may be null)