JdbcTemplate queryForInt（）已弃用

升级Spring版本，并注意到不赞成使用queryForInt() ，应将其替换为什么？

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;
  }

解

从3.2.2版开始， queryForInt()和queryForLong()均已弃用（如果出错，请更正）。 要解决此问题，请将代码替换为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;
  }

查看Spring源代码。

JdbcTemplate.java

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);
  }

参考文献

1. Spring JdbcTemplate JavaDoc

标签： Spring JDBC

翻译自: https://mkyong.com/spring/jdbctemplate-queryforint-is-deprecated/