Code Snippet

Spring Framework JdbcTemplate

Deon Slabbert

Deon Slabbert

— 1 min read

Please note, the content of this post has been copied from the Spring website and modified by me.

SELECT

public int test() {
    var sql = "select count(*) from product";
    return this.jdbcTemplate.queryForObject(sql, Integer.class);
}

public int test() {
    var sql = "select count(*) from product where name = ?";
    return this.jdbcTemplate.queryForObject(sql, Integer.class, "Joe");
}

public String test() {
    String sql = "select name from product where id = ?";
    return this.jdbcTemplate.queryForObject(sql, String.class, 1212L);
}

public MyProduct test() {
    var sql = "select id, name from product where id = ?";
    return jdbcTemplate.queryForObject(sql, (resultSet, rowNum) ->
            new MyProduct(
                    resultSet.getInt("id"),
                    resultSet.getString("name")
            ), 123);
}

public List<MyProduct> test() {
    var sql = "select id, name from product";
    return jdbcTemplate.query(sql, (resultSet, rowNum) -> new MyProduct(
            resultSet.getInt("id"),
            resultSet.getString("name")
    ));
}

private final RowMapper<Actor> actorRowMapper = (resultSet, rowNum) -> {
    Actor actor = new Actor();
    actor.setFirstName(resultSet.getString("first_name"));
    actor.setLastName(resultSet.getString("last_name"));
    return actor;
};

public List<Actor> findAllActors() {
    var sql = "select first_name, last_name from t_actor";
    return this.jdbcTemplate.query(sql, actorRowMapper);
}

INSERT

this.jdbcTemplate.update(
    "insert into t_actor (first_name, last_name) values (?, ?)", 
    "Leonor", "Watling");

UPDATE

this.jdbcTemplate.update(
    "update t_actor set last_name = ? where id = ?", 
    "Banjo", 5276L);

DELETE

this.jdbcTemplate.update(
    "delete from t_actor where id = ?", 
    Long.valueOf(actorId));

OTHER

var sql = "create table mytable (id integer, name varchar(100))";
this.jdbcTemplate.execute(sql);

Read more