EXCEPTION:
org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
中文意思:
数据库找不到 你要查找的结果
案例:
public Manager getManager(String name) {
String sql="select * from manager where name=?";
return template.queryForObject(sql, new BeanPropertyRowMapper<Manager>(Manager.class),name);
解决方案:处理queryForObject的异常,因为它不会返回null结果
public Manager getManager(String name) {
String sql = "select * from manager where name=?";
try {
return template.queryForObject(sql, new BeanPropertyRowMapper<Manager>(Manager.class), name);
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
异常可以在控制台看得见,但程序不会出现500异常