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...就行了