NamedParameterJdbcTemplate的查找list方法

• bean实例

@Data
public class User{
	int id;
	String name;
	int age;
}

• 查询单个属性值

final String sql = "select name from User where age=:age ";
Map<String, String> params = new HashMap<>(1);
params.put("age", age);
List<String> names = namedParameterJdbcTemplate.queryForList(sql , params, String.class);

• 查询bean集合（无需实现RowMappe接口）

String sql = "select * from User where age=:age";
Map<String, String> params = new HashMap<>(1);
params.put("age", age);
List<User> users= namedParameterJdbcTemplate.query(sql, params, new BeanPropertyRowMapper(User.class));