程序包 org.springframework.jdbc.core

类 RowCountCallbackHandler

  • 所有已实现的接口:
    RowCallbackHandler
    public class RowCountCallbackHandler
extends Object
implements RowCallbackHandler
    Implementation of RowCallbackHandler. An instance can only be used once.

    We can either use this on its own (for example, in a test case, to ensure that our result sets have valid dimensions), or use it as a superclass for callback handlers that actually do something, and will benefit from the dimension information it provides.

    A usage example with JdbcTemplate: 

     JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);  // reusable object

 RowCountCallbackHandler countCallback = new RowCountCallbackHandler();  // not reusable
 jdbcTemplate.query("select * from user", countCallback);
 int rowCount = countCallback.getRowCount();
    从以下版本开始:
    May 3, 2001
    作者:
    Rod Johnson

    • 方法详细资料

      • processRow

        public final void processRow​(ResultSet rs)
                      throws SQLException
        Work out column size if this is the first row, otherwise just count rows.

        Subclasses can perform custom extraction or processing by overriding the processRow(ResultSet, int) method.

        指定者:
        processRow 在接口中 RowCallbackHandler
        参数:
        rs - the ResultSet to process (pre-initialized for the current row)
        抛出:
        SQLException - if a SQLException is encountered getting column values (that is, there's no need to catch SQLException)
        另请参阅:
        processRow(java.sql.ResultSet, int)

      • processRow

        protected void processRow​(ResultSet rs,
                          int rowNum)
                   throws SQLException
        Subclasses may override this to perform custom extraction or processing. This class's implementation does nothing.
        参数:
        rs - ResultSet to extract data from. This method is invoked for each row
        rowNum - number of the current row (starting from 0)
        抛出:
        SQLException

      • getColumnTypes

        public final int[] getColumnTypes()
        Return the types of the columns as java.sql.Types constants Valid after processRow is invoked the first time.
        返回:
        the types of the columns as java.sql.Types constants. Indexed from 0 to n-1.

      • getColumnNames

        public final String[] getColumnNames()
        Return the names of the columns. Valid after processRow is invoked the first time.
        返回:
        the names of the columns. Indexed from 0 to n-1.

      • getRowCount

        public final int getRowCount()
        Return the row count of this ResultSet Only valid after processing is complete
        返回:
        the number of rows in this ResultSet

      • getColumnCount

        public final int getColumnCount()
        Return the number of columns in this result set. Valid once we've seen the first row, so subclasses can use it during processing
        返回:
        the number of columns in this result set