NamedParameterJdbcTemplate how return only one row?

user_5620472 0
Viewed 6654

I have select:

SELECT hz FROM my_tablw WHERE id=1

It return me 1 row and 1 column:

hz
some data

I have 

 @Autowired
    private NamedParameterJdbcTemplate jdbcTemplate;

And I need make query and return 1 row - String some data. I create 

jdbcTemplate.query("SELECT hz FROM my_tablw WHERE id=:id", insertManagerParameters, (rs, rowNum) -> {
            if (rs.next()) {
                return rs.getString(1);
            }
            return "";
        });

but this method return List<String>

spring-jdbc jdbctemplate
2 Answers
MapSqlParameterSource paramSource = new MapSqlParameterSource();
paramSource.addValue("id", id);
return this.customNamedParameterJdbcTemplate.getNamedParameterJdbcTemplate().queryForObject(sqlConsultarPorId, paramSource,new MapeoReserva());
user_127069490
Related