Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

NamedParameterJdbcTemplate how return only one row?

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>

like image 536
user5620472 Avatar asked Sep 03 '25 02:09

user5620472


1 Answers

I would use the queryForObject method, like:

jdbcTemplate.queryForObject("SELECT hz FROM my_tablw WHERE id=:id", insertManagerParameters, String.class);

Which should return a String with the query results.

like image 192
Thomas Risberg Avatar answered Sep 05 '25 16:09

Thomas Risberg