jdbcTemplate.queryForObject使用相关问题

错误：org.springframework.jdbc.IncorrectResultSetColumnCountException

解决：

JdbcTemplate调用queryForObject方法一直报org.springframework.jdbc.IncorrectResultSetColumnCountException: Incorrect column count: expected 1, actual 10，开始以为是Object中字段不匹配，后来发现需要将对象rowmap，具体方法：

RowMapper<StationVo > rm = ParameterizedBeanPropertyRowMapper.newInstance(StationVo .class);
StationVo vo =jdbc.queryForObject(sql, rm,condStr.toArray());

spring4.x以后用BeanPropertyRowMapper，3.2用ParameterizedBeanPropertyRowMapper 类

错误：java.lang.NoSuchMethodError: org.springframework.core.convert.support.Defaul

包冲突 删除无用的包

示例：

public User getUsers(){
    RowMapper<User> rm = BeanPropertyRowMapper.newInstance(User.class);
    return jdbcTemplate.queryForObject("select * from user where age=1",rm);
}

public List<User> getUserList(){

    RowMapper<User> rm = BeanPropertyRowMapper.newInstance(User.class);

    return jdbcTemplate.query("select * from user",rm);
}