程序包 org.springframework.jdbc.object

类 BatchSqlUpdate

  • 所有已实现的接口:
    InitializingBean
    public class BatchSqlUpdate
extends SqlUpdate
    SqlUpdate subclass that performs batch update operations. Encapsulates queuing up records to be updated, and adds them as a single batch once flush is called or the given batch size has been met.

    Note that this class is a non-thread-safe object, in contrast to all other JDBC operations objects in this package. You need to create a new instance of it for each use, or call reset before reuse within the same thread.

    从以下版本开始:
    1.1
    作者:
    Keith Donald, Juergen Hoeller
    另请参阅:
    flush(), reset()

    • 字段详细资料

    • 构造器详细资料

      • BatchSqlUpdate

        public BatchSqlUpdate​(DataSource ds,
                      String sql)
        Construct an update object with a given DataSource and SQL.
        参数:
        ds - DataSource to use to obtain connections
        sql - SQL statement to execute

      • BatchSqlUpdate

        public BatchSqlUpdate​(DataSource ds,
                      String sql,
                      int[] types)
        Construct an update object with a given DataSource, SQL and anonymous parameters.
        参数:
        ds - DataSource to use to obtain connections
        sql - SQL statement to execute
        types - SQL types of the parameters, as defined in the java.sql.Types class
        另请参阅:
        Types

      • BatchSqlUpdate

        public BatchSqlUpdate​(DataSource ds,
                      String sql,
                      int[] types,
                      int batchSize)
        Construct an update object with a given DataSource, SQL, anonymous parameters and specifying the maximum number of rows that may be affected.
        参数:
        ds - DataSource to use to obtain connections
        sql - SQL statement to execute
        types - SQL types of the parameters, as defined in the java.sql.Types class
        batchSize - the number of statements that will trigger an automatic intermediate flush
        另请参阅:
        Types

    • 方法详细资料

      • setBatchSize

        public void setBatchSize​(int batchSize)
        Set the number of statements that will trigger an automatic intermediate flush. update calls or the given statement parameters will be queued until the batch size is met, at which point it will empty the queue and execute the batch.

        You can also flush already queued statements with an explicit flush call. Note that you need to this after queueing all parameters to guarantee that all statements have been flushed.

      • setTrackRowsAffected

        public void setTrackRowsAffected​(boolean trackRowsAffected)
        Set whether to track the rows affected by batch updates performed by this operation object.

        Default is "true". Turn this off to save the memory needed for the list of row counts.

        另请参阅:
        getRowsAffected()

      • update

        public int update​(Object... params)
           throws DataAccessException
        Overridden version of update that adds the given statement parameters to the queue rather than executing them immediately. All other update methods of the SqlUpdate base class go through this method and will thus behave similarly.

        You need to call flush to actually execute the batch. If the specified batch size is reached, an implicit flush will happen; you still need to finally call flush to flush all statements.

        覆盖:
        update 在类中 SqlUpdate
        参数:
        params - array of parameter objects
        返回:
        the number of rows affected by the update (always -1, meaning "not applicable", as the statement is not actually executed by this method)
        抛出:
        DataAccessException
        另请参阅:
        flush()

      • flush

        public int[] flush()
        Trigger any queued update operations to be added as a final batch.
        返回:
        an array of the number of rows affected by each statement

      • getQueueCount

        public int getQueueCount()
        Return the current number of statements or statement parameters in the queue.

      • getExecutionCount

        public int getExecutionCount()
        Return the number of already executed statements.

      • getRowsAffected

        public int[] getRowsAffected()
        Return the number of affected rows for all already executed statements. Accumulates all of flush's return values until reset is invoked.
        返回:
        an array of the number of rows affected by each statement
        另请参阅:
        reset()

      • reset

        public void reset()
        Reset the statement parameter queue, the rows affected cache, and the execution count.