JdbcTemplate

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

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, UPDATE, and DELETE

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

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

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