【SpringBoot_MyBatis_MySQL】问题:...TooManyResultsException: Expected one result...，but found: 3

问题

org.apache.ibatis.exceptions.TooManyResultsException: Expected one
result (or null) to be returned by selectOne(), but found: 3

源头

返回值是整型数字，sql语句中写错了…

修改后

正确书写“select count(id) from dish where category_id = #{categoryId};”

总结

还是要细心，出现了错误就要找准报错提示中信息，准确迅速找到源头解决问题！