JdbcTemplate和NamedParameterJdbcTemplate的区别

@Resource
protected NamedParameterJdbcTemplate npJdbcTemplate;

String sql = baseSql +" and exam_id in (:asgmtIds) and exam_sponsor = :teacherId";
MapSqlParameterSource parameters = new MapSqlParameterSource();
List<Integer> collect =Arrays.stream(asgmtIds).map(Integer::valueOf)
.collect(Collectors.toList());
parameters.addValue("asgmtIds", collect);
parameters.addValue("teacherId", teacherId);
npJdbcTemplate.query(sql, parameters, new BeanPropertyRowMapper<(AsgmtsDO.class));

@Resource
protected JdbcTemplate jdbcTemplate;

String sql = baseSql + "paper_id=?";
Object obj = new Object[]{asgmtId};
jdbcTemplate.query(sql,obj,new BeanPropertyRowMapper<>(PaperDO.class));