java.lang.Object
- org.springframework.jdbc.object.RdbmsOperation

所有已实现的接口:
InitializingBean
直接已知子类:
SqlCall, SqlOperation
```
public abstract class RdbmsOperation
extends Object
implements InitializingBean
```
An "RDBMS operation" is a multi-threaded, reusable object representing a query, update, or stored procedure call. An RDBMS operation is not a command, as a command is not reusable. However, execute methods may take commands as arguments. Subclasses should be JavaBeans, allowing easy configuration.
This class and subclasses throw runtime exceptions, defined in the org.springframework.dao package (and as thrown by the org.springframework.jdbc.core package, which the classes in this package use under the hood to perform raw JDBC operations).
Subclasses should set SQL and add parameters before invoking the compile() method. The order in which parameters are added is significant. The appropriate execute or update method can then be invoked.
作者:
Rod Johnson, Juergen Hoeller
另请参阅:
SqlQuery, SqlUpdate, StoredProcedure, JdbcTemplate

字段概要
字段
修饰符和类型字段说明
protected Log logger
Logger available to subclasses.

构造器概要
构造器
构造器说明
RdbmsOperation()

方法概要

所有方法实例方法抽象方法具体方法
修饰符和类型	方法	说明
`void`	`afterPropertiesSet()`	Ensures compilation if used in a bean factory.
`protected boolean`	`allowsUnusedParameters()`	Return whether this operation accepts additional parameters that are given but not actually used.
`protected void`	`checkCompiled()`	Check whether this operation has been compiled already; lazily compile it if not already compiled.
`void`	`compile()`	Compile this query.
`protected abstract void`	`compileInternal()`	Subclasses must implement this template method to perform their own compilation.
`void`	`declareParameter(SqlParameter param)`	Declare a parameter for this operation.
`protected List<SqlParameter>`	`getDeclaredParameters()`	Return a list of the declared `SqlParameter` objects.
`String[]`	`getGeneratedKeysColumnNames()`	Return the column names of the auto generated keys.
`JdbcTemplate`	`getJdbcTemplate()`	Return the `JdbcTemplate` used by this operation object.
`int`	`getResultSetType()`	Return whether statements will return a specific type of ResultSet.
`String`	`getSql()`	Subclasses can override this to supply dynamic SQL if they wish, but SQL is normally set by calling the `setSql(java.lang.String)` method or in a subclass constructor.
`boolean`	`isCompiled()`	Is this operation "compiled"?
`boolean`	`isReturnGeneratedKeys()`	Return whether statements should be capable of returning auto-generated keys.
`boolean`	`isUpdatableResults()`	Return whether statements will return updatable ResultSets.
`protected String`	`resolveSql()`	Resolve the configured SQL for actual use.
`void`	`setDataSource(DataSource dataSource)`	Set the JDBC `DataSource` to obtain connections from.
`void`	`setFetchSize(int fetchSize)`	Set the fetch size for this RDBMS operation.
`void`	`setGeneratedKeysColumnNames(String... names)`	Set the column names of the auto-generated keys.
`void`	`setJdbcTemplate(JdbcTemplate jdbcTemplate)`	An alternative to the more commonly used `setDataSource(javax.sql.DataSource)` when you want to use the same `JdbcTemplate` in multiple `RdbmsOperations`.
`void`	`setMaxRows(int maxRows)`	Set the maximum number of rows for this RDBMS operation.
`void`	`setParameters(SqlParameter... parameters)`	Add one or more declared parameters.
`void`	`setQueryTimeout(int queryTimeout)`	Set the query timeout for statements that this RDBMS operation executes.
`void`	`setResultSetType(int resultSetType)`	Set whether to use statements that return a specific type of ResultSet.
`void`	`setReturnGeneratedKeys(boolean returnGeneratedKeys)`	Set whether prepared statements should be capable of returning auto-generated keys.
`void`	`setSql(String sql)`	Set the SQL executed by this operation.
`void`	`setTypes(int[] types)`	Add anonymous parameters, specifying only their SQL types as defined in the `java.sql.Types` class.
`void`	`setUpdatableResults(boolean updatableResults)`	Set whether to use statements that are capable of returning updatable ResultSets.
`protected boolean`	`supportsLobParameters()`	Return whether BLOB/CLOB parameters are supported for this kind of operation.
`protected void`	`validateNamedParameters(Map<String,?> parameters)`	Validate the named parameters passed to an execute method based on declared parameters.
`protected void`	`validateParameters(Object[] parameters)`	Validate the parameters passed to an execute method based on declared parameters.

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- 字段详细资料
  - logger
```
protected final Log logger
```
    Logger available to subclasses.
- 构造器详细资料
  - RdbmsOperation
```
public RdbmsOperation()
```
- 方法详细资料
  - setJdbcTemplate
```
public void setJdbcTemplate(JdbcTemplate jdbcTemplate)
```
    An alternative to the more commonly used setDataSource(javax.sql.DataSource) when you want to use the same JdbcTemplate in multiple RdbmsOperations. This is appropriate if the JdbcTemplate has special configuration such as a SQLExceptionTranslator to be reused.
  - getJdbcTemplate
```
public JdbcTemplate getJdbcTemplate()
```
    Return the JdbcTemplate used by this operation object.
  - setDataSource
```
public void setDataSource(DataSource dataSource)
```
    Set the JDBC DataSource to obtain connections from.
    另请参阅:
    JdbcAccessor.setDataSource(javax.sql.DataSource)
  - setFetchSize
```
public void setFetchSize(int fetchSize)
```
    Set the fetch size for this RDBMS operation. This is important for processing large result sets: Setting this higher than the default value will increase processing speed at the cost of memory consumption; setting this lower can avoid transferring row data that will never be read by the application.
    Default is -1, indicating to use the driver's default.
    另请参阅:
    JdbcTemplate.setFetchSize(int)
  - setMaxRows
```
public void setMaxRows(int maxRows)
```
    Set the maximum number of rows for this RDBMS operation. This is important for processing subsets of large result sets, avoiding to read and hold the entire result set in the database or in the JDBC driver.
    Default is -1, indicating to use the driver's default.
    另请参阅:
    JdbcTemplate.setMaxRows(int)
  - setQueryTimeout
```
public void setQueryTimeout(int queryTimeout)
```
    Set the query timeout for statements that this RDBMS operation executes.
    Default is -1, indicating to use the JDBC driver's default.
    Note: Any timeout specified here will be overridden by the remaining transaction timeout when executing within a transaction that has a timeout specified at the transaction level.
  - setResultSetType
```
public void setResultSetType(int resultSetType)
```
    Set whether to use statements that return a specific type of ResultSet.
    参数:
    resultSetType - the ResultSet type
    另请参阅:
    ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.TYPE_SCROLL_SENSITIVE, Connection.prepareStatement(String, int, int)
  - getResultSetType
```
public int getResultSetType()
```
    Return whether statements will return a specific type of ResultSet.
  - setUpdatableResults
```
public void setUpdatableResults(boolean updatableResults)
```
    Set whether to use statements that are capable of returning updatable ResultSets.
    另请参阅:
    Connection.prepareStatement(String, int, int)
  - isUpdatableResults
```
public boolean isUpdatableResults()
```
    Return whether statements will return updatable ResultSets.
  - setReturnGeneratedKeys
```
public void setReturnGeneratedKeys(boolean returnGeneratedKeys)
```
    Set whether prepared statements should be capable of returning auto-generated keys.
    另请参阅:
    Connection.prepareStatement(String, int)
  - isReturnGeneratedKeys
```
public boolean isReturnGeneratedKeys()
```
    Return whether statements should be capable of returning auto-generated keys.
  - setGeneratedKeysColumnNames
```
public void setGeneratedKeysColumnNames(@Nullable
                                        String... names)
```
    Set the column names of the auto-generated keys.
    另请参阅:
    Connection.prepareStatement(String, String[])
  - getGeneratedKeysColumnNames
```
@Nullable
public String[] getGeneratedKeysColumnNames()
```
    Return the column names of the auto generated keys.
  - setSql
```
public void setSql(@Nullable
                   String sql)
```
    Set the SQL executed by this operation.
  - getSql
```
@Nullable
public String getSql()
```
    Subclasses can override this to supply dynamic SQL if they wish, but SQL is normally set by calling the setSql(java.lang.String) method or in a subclass constructor.
  - resolveSql
```
protected String resolveSql()
```
    Resolve the configured SQL for actual use.
    返回:
    the SQL (never null)
    从以下版本开始:
    5.0
  - setTypes
```
public void setTypes(@Nullable
                     int[] types)
              throws InvalidDataAccessApiUsageException
```
    Add anonymous parameters, specifying only their SQL types as defined in the java.sql.Types class.
    Parameter ordering is significant. This method is an alternative to the declareParameter(org.springframework.jdbc.core.SqlParameter) method, which should normally be preferred.
    参数:
    types - array of SQL types as defined in the java.sql.Types class
    抛出:
    InvalidDataAccessApiUsageException - if the operation is already compiled
  - declareParameter
```
public void declareParameter(SqlParameter param)
                      throws InvalidDataAccessApiUsageException
```
    Declare a parameter for this operation.
    The order in which this method is called is significant when using positional parameters. It is not significant when using named parameters with named SqlParameter objects here; it remains significant when using named parameters in combination with unnamed SqlParameter objects here.
    参数:
    param - the SqlParameter to add. This will specify SQL type and (optionally) the parameter's name. Note that you typically use the SqlParameter class itself here, not any of its subclasses.
    抛出:
    InvalidDataAccessApiUsageException - if the operation is already compiled, and hence cannot be configured further
  - setParameters
```
public void setParameters(SqlParameter... parameters)
```
    Add one or more declared parameters. Used for configuring this operation when used in a bean factory. Each parameter will specify SQL type and (optionally) the parameter's name.
    参数:
    parameters - an array containing the declared SqlParameter objects
    另请参阅:
    declaredParameters
  - getDeclaredParameters
```
protected List<SqlParameter> getDeclaredParameters()
```
    Return a list of the declared SqlParameter objects.
  - afterPropertiesSet
```
public void afterPropertiesSet()
```
    Ensures compilation if used in a bean factory.
    指定者:
    afterPropertiesSet 在接口中 InitializingBean
  - compile
```
public final void compile()
                   throws InvalidDataAccessApiUsageException
```
    Compile this query. Ignores subsequent attempts to compile.
    抛出:
    InvalidDataAccessApiUsageException - if the object hasn't been correctly initialized, for example if no DataSource has been provided
  - isCompiled
```
public boolean isCompiled()
```
    Is this operation "compiled"? Compilation, as in JDO, means that the operation is fully configured, and ready to use. The exact meaning of compilation will vary between subclasses.
    返回:
    whether this operation is compiled and ready to use
  - checkCompiled
```
protected void checkCompiled()
```
    Check whether this operation has been compiled already; lazily compile it if not already compiled.
    Automatically called by validateParameters.
    另请参阅:
    validateParameters(java.lang.Object[])
  - validateParameters
```
protected void validateParameters(@Nullable
                                  Object[] parameters)
                           throws InvalidDataAccessApiUsageException
```
    Validate the parameters passed to an execute method based on declared parameters. Subclasses should invoke this method before every executeQuery() or update() method.
    参数:
    parameters - the parameters supplied (may be null)
    抛出:
    InvalidDataAccessApiUsageException - if the parameters are invalid
  - validateNamedParameters
```
protected void validateNamedParameters(@Nullable
                                       Map<String,?> parameters)
                                throws InvalidDataAccessApiUsageException
```
    Validate the named parameters passed to an execute method based on declared parameters. Subclasses should invoke this method before every executeQuery() or update() method.
    参数:
    parameters - parameter Map supplied (may be null)
    抛出:
    InvalidDataAccessApiUsageException - if the parameters are invalid
  - compileInternal
```
protected abstract void compileInternal()
                                 throws InvalidDataAccessApiUsageException
```
    Subclasses must implement this template method to perform their own compilation. Invoked after this base class's compilation is complete.
    Subclasses can assume that SQL and a DataSource have been supplied.
    抛出:
    InvalidDataAccessApiUsageException - if the subclass hasn't been properly configured
  - supportsLobParameters
```
protected boolean supportsLobParameters()
```
    Return whether BLOB/CLOB parameters are supported for this kind of operation.
    The default is true.
  - allowsUnusedParameters
```
protected boolean allowsUnusedParameters()
```
    Return whether this operation accepts additional parameters that are given but not actually used. Applies in particular to parameter Maps.
    The default is false.
    另请参阅:
    StoredProcedure

类 RdbmsOperation

字段概要

构造器概要

方法概要

从类继承的方法 java.lang.Object

字段详细资料

logger

构造器详细资料

RdbmsOperation

方法详细资料

setJdbcTemplate

getJdbcTemplate

setDataSource

setFetchSize

setMaxRows

setQueryTimeout

setResultSetType

getResultSetType

setUpdatableResults

isUpdatableResults

setReturnGeneratedKeys

isReturnGeneratedKeys

setGeneratedKeysColumnNames

getGeneratedKeysColumnNames

setSql

getSql

resolveSql

setTypes

declareParameter

setParameters

getDeclaredParameters

afterPropertiesSet

compile

isCompiled

checkCompiled

validateParameters

validateNamedParameters

compileInternal

supportsLobParameters

allowsUnusedParameters