/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 vote132 views1 answer
Find the length of jtextfeild in java
Java
0 vote95 views1 answer
Align button to the left in JPanel
Java
-1 vote141 views2 answers
Java 8 datediff in days
Java
6 votes134 views3 answers
Junit 5 expected exception
Java
3 votes266 views2 answers
Xml definition file for spring
Java Spring
2 votes153 views1 answer
Spring mvc get all request parameters
Java Spring
2 votes133 views2 answers
Variables inside strings kotlin
Java
0 vote140 views1 answer
How good at you are at java
Java
0 vote138 views1 answer
ArrayList<HashMap<String, String>> arrayList = new ArrayList<>()
Java
4 votes152 views1 answer
Concurrent modification exception
Java