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