spring JdbcTemplate NamedParameterJdbcTemplate extension of JdbcTemplate
Example
The
NamedParameterJdbcTemplateclass adds support for programming JDBC statements using named parameters, as opposed to programming JDBC statements using only classic placeholder ( '?') arguments. TheNamedParameterJdbcTemplateclass wraps aJdbcTemplate, and delegates to the wrappedJdbcTemplateto do much of its work.
DataSource dataSource = ... //
NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
String sql = "SELECT count(*) FROM customer WHERE city_name=:cityName";
Map<String, String> params = Collections.singletonMap("cityName", cityName);
int count = jdbcTemplate.queryForObject(sql, params, Integer.class);
