/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
Cannot find symbol iterator in java
Java
0 vote147 views1 answer
How to make a string alphabetic
Java
0 vote217 views1 answer
Intellisense for eclipse java
Java
0 vote157 views1 answer
How to draw
Java
0 vote132 views1 answer
Spinner get items
Java
0 vote149 views1 answer
TYPE_INT_ARGB
Java
0 vote110 views1 answer
How to set a value in an int array to null in java
Java
0 vote149 views1 answer
How do you make bedrock full screen in Minecraft?
Java
0 vote138 views1 answer
Fail method java
Java
0 vote145 views1 answer
Le but de ce sujet est d´écrire un programme JAVA pour aider à la gestion de la billeterie des différentes salles d'un complexe cinématographique. Les places non numérotées sont vendues selon deux tarif
Java