JdbcTemplate queryForInt() is Deprecated

Upgrading Spring version and noticed that queryForInt() is deprecated, what should be replaced by?

  private boolean isUserExists(String username) {
        String sql = "SELECT count(*) FROM USERS WHERE username = ?";
        boolean result = false;
        //The method queryForInt(String, Object...) from the type JdbcTemplate is deprecated
        int count = getJdbcTemplate().queryForInt(sql, new Object[] { username });
	if (count > 0) {
		result = true;
	return result;

Solution

Both queryForInt() and queryForLong() are deprecated since version 3.2.2 (correct me if mistake). To fix it, replace the code with queryForObject(String, Class).

  private boolean isUserExists(String username) {
        String sql = "SELECT count(*) FROM USERS WHERE username = ?";
	boolean result = false;
	int count = getJdbcTemplate().queryForObject(
                        sql, new Object[] { username }, Integer.class);
	if (count > 0) {
		result = true;
	return result;

Review the Spring source code.

package org.springframework.jdbc.core;
public class JdbcTemplate extends JdbcAccessor implements JdbcOperations {
  //...
  @Deprecated
  public long queryForLong(String sql, Object... args) throws DataAccessException {
	Number number = queryForObject(sql, args, Long.class);
	return (number != null ? number.longValue() : 0);
  @Deprecated
  public int queryForInt(String sql, Object... args) throws DataAccessException {
	Number number = queryForObject(sql, args, Integer.class);
	return (number != null ? number.intValue() : 0);

References

1. Spring JdbcTemplate JavaDoc