NamedParameterJdbcTemplateをつかったselectのサンプル

備忘録

import java.util.Optional;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Component;

import com.google.common.collect.ImmutableMap;

@Component
public class SampleDao {
    
    @Autowired
    private NamedParameterJdbcTemplate jdbcTemplate;
    
    public Optional<String> find(final String id) {
        var sql = "select id, name from samples where id = :id";
        final var params = ImmutableMap.<String, Object>builder().put("id", id).build();
        return jdbcTemplate.query(sql, params, (rs, num) -> rs.getString("name")).stream().findFirst();
    }

}