Incorrect column count: expected 1, actual 10 IncorrectResultSetColumnCount

最新推荐文章于 2023-07-04 21:30:11 发布

iteye_20054

最新推荐文章于 2023-07-04 21:30:11 发布

阅读量489

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 java

本文链接：https://blog.youkuaiyun.com/iteye_20054/article/details/82123360

本文详细解析了在使用Spring JDBC时遇到的IncorrectResultSetColumnCountException错误，并提供了正确的SQL语句修改方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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 10
	at 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)