错误:org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 0
原因:这里涉及到返回值的为null 与 0行() 的区别
0行: select salary from user where 1 = 2
null result: select max(salary) from user where 1 = 2 返回就是null
0行一定抛出IncorrectResultSizeDataAccessException异常
原因如下:
ResultSetMetaData rsmd = rs.getMetaData();
int nrOfColumns = rsmd.getColumnCount();这里返回ResultSet的列数
if (nrOfColumns != 1) {
throw new IncorrectResultSizeDataAccessException(
"Expected single column but found " + nrOfColumns, 1, nrOfColumns);
}
0行,不等于1行,就抛异常了
解决方案:最好还是用QueryForList,返回的list的size为0,就是0行