spring 的JDBCTemplate的 queryForInt用法

• queryForInt

  @Deprecatedpublic int queryForInt(String sql,                                   Object[] args,                                   int[] argTypes)                            throws DataAccessException

  Deprecated. 
  Description copied from interface: JdbcOperations
  Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, resulting in an int value.

  The query is expected to be a single row/single column query that results in an int value.

  Specified by:

  queryForInt in interface JdbcOperations

  Parameters:

  sql - SQL query to execute

  args - arguments to bind to the query

  argTypes - SQL types of the arguments (constants from java.sql.Types)

  Returns:

  the int value, or 0 in case of SQL NULL

  Throws:

  IncorrectResultSizeDataAccessException - if the query does not return exactly one row, or does not return exactly one column in that row

  DataAccessException - if the query fails

  See Also:

  JdbcOperations.queryForInt(String), Types