備忘録
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();
}
}