IncorrectResultSetColumnCountException: Incorrect column count: expected 1, actual 5

使用jdbcTemplate查询数据,刚开始如下操作

Broker broker = jdbcTemplate.queryForObject(
     "select id, uname, broker_id brokerId, create_time createTime, deleted from broker where id = 26",
     Broker.class);

我的本意是想让他自己映射成Broker对想
结果确是错误:
Exception in thread “main” org.springframework.jdbc.IncorrectResultSetColumnCountException: Incorrect column count: expected 1, actual 5

改成如下方式:

 Broker broker = jdbcTemplate.queryForObject(
     "select id, uname, broker_id brokerId, create_time createTime, deleted from broker where id = 26",
     ParameterizedBeanPropertyRowMapper.newInstance(Broker.class));
     System.out.println(broker.toString());
原文地址:https://www.cnblogs.com/paper-man/p/13284605.html