首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 开发语言 > 编程 >

Incorrect column count: expected 一, actual 10 IncorrectResultSetColumnCount

2012-11-18 
Incorrect column count: expected 1, actual 10 IncorrectResultSetColumnCountorg.springframework.jdbc

Incorrect column count: expected 1, actual 10 IncorrectResultSetColumnCount
org.springframework.jdbc.IncorrectResultSetColumnCountException


public String getRightAnswer(int question_id) {String sql = "select * from  question where question_id = "+question_id+"";return this.baseDaoSupport.queryForString(sql);}应该是 JdbcTemple.queryForObject 返回都是单行单列一个数据,也就是只能返回一个字段的不能用select * from ....所以 改正之后public String getRightAnswer(int question_id) {String sql = "select  answer from  question where question_id = "+question_id+"";return this.baseDaoSupport.queryForString(sql);}


org.springframework.jdbc.IncorrectResultSetColumnCountException: Incorrect column count: expected 1, actual 10at org.springframework.jdbc.core.SingleColumnRowMapper.mapRow(SingleColumnRowMapper.java:86)at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:448)at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:474)at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:479)at com.enation.framework.database.impl.JdbcDaoSupport.queryForString(JdbcDaoSupport.java:118)at com.enation.eop.sdk.database.BaseJdbcDaoSupport.queryForString(BaseJdbcDaoSupport.java:128)
1 楼 lsp1988 2011-10-24   改成select count(*) from...就行了

热点排行