NamedParameterJdbcTemplate:-
The NamedParameterJdbcTemplate class adds support for programming JDBC
statements using named parameters, as opposed to programming JDBC statements
using only classic placeholder ( '?') arguments. The
NamedParameterJdbcTemplate class wraps a JdbcTemplate, and delegates to
the wrapped JdbcTemplate to do much of its work. This section describes only
those areas of the NamedParameterJdbcTemplate class that differ from the
JdbcTemplate itself; namely, programming JDBC statements using named parameters.
private NamedParameterJdbcTemplate namedParameterJdbcTemplate;
public void setDataSource(DataSource dataSource) {
this.namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(dataSource);}
public int countOfActorsByFirstName(String firstName) {
String sql = "select count(*) from T_ACTOR where first_name = :first_name";
SqlParameterSource namedParameters = new MapSqlParameterSource("first_name", firstName);
return this.namedParameterJdbcTemplate.queryForObject(sql, namedParameters, Integer.class);
}
The named parameter notation in the value assigned to the sql variable, and the corresponding value that is plugged into the namedParameters variable .