/Java/Spring 5 jdbctemplate query for a single value

Spring 5 jdbctemplate query for a single value

String result = DataAccessUtils.singleResult(
    jdbcTemplate.queryForList(
        "SELECT street_name FROM table WHERE id = :id",
        Collections.singletonMap("id", id),
        String.class
    )
)

Source: stackoverflow.com

Spring 5 jdbctemplate query for a single value

public String getStreetNameById(int id) {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    String sql = "SELECT STREET_NAME FROM table WHERE ID=?";

    String streetName = (String) jdbcTemplate.queryForObject(
            sql, String.class, id);

    return streetName;
}

Source: stackoverflow.com

Similar codes

0 vote308 views1 answer
Java quote of the day
Java
-2 votes328 views1 answer
Java anagrams
Java
0 vote324 views1 answer
Show bottom sheet in adapter
Java
0 vote273 views1 answer
One space diagonally in java
Java
0 vote333 views1 answer
Icon share android
Java
38 votes353 views4 answers
Math.random java between 1 and 10
Java
0 vote318 views1 answer
Android studio call on a string
Java
1 vote333 views1 answer
Order agnostic binary search
Java
0 vote318 views1 answer
Java boolean zen
Java
2 votes390 views1 answer
Springboot starter jpa
Java Spring