Breaking News: Grepper is joining You.com. Read the official announcement!

spring 5 jdbctemplate query for a single value

Muddy Millipede answered on October 23, 2021 Popularity 6/10 Helpfulness 3/10

answer spring 5 jdbctemplate query for a single value

related spring 5 jdbctemplate query for a single value

spring 5 jdbctemplate query for a single value

Comment

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;
}

Popularity 6/10 Helpfulness 3/10 Language java

Source: stackoverflow.com

Tags: java jdbctemplate spring

Link to this answer
Share Copy Link

Contributed on Oct 23 2021

Muddy Millipede

0 Answers Avg Quality 2/10

Closely Related Answers

spring 5 jdbctemplate query for a single value

Comment

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

Popularity 6/10 Helpfulness 1/10 Language java

Source: stackoverflow.com

Tags: jdbctemplate java spring

Link to this answer
Share Copy Link

Contributed on Oct 23 2021

Muddy Millipede

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

spring 5 jdbctemplate query for a single value

Contents

More Related Answers

spring 5 jdbctemplate query for a single value

Closely Related Answers

spring 5 jdbctemplate query for a single value

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.