首页Expected one result (or null) to be returned by selectOne(), but found: 11

Expected one result (or null) to be returned by selectOne(), but found: 11

时间: 2023-09-27 09:07:30 浏览: 232

求救！！mybatis Expected one result (or null) to be returned by selectOne(), but found:18

我想使用resultMap 一对多查询可是提示 Expected one result (or null) to be returned by selectOne(), but found:18 下面展示一些 mapper.xml。 SELECT st.title as titlest ,st.info_text as info_text , sbt.title as titlesbt,sbt.icon as icon, sbx.text as text FROM `services_title` AS st

回答: "Expected one result (or null) to be returned by selectOne(), but found: 11"这句话的意思是期望返回一个结果（或者null），但是发现返回了11个结果。根据引用[1]和引用[2]的解释，这个错误通常是由于SQL语句或者mapper中的返回值设置有误导致的。解决这个问题的方法有两个：1.检查SQL语句是否正确；2.检查mapper中返回值的设置是否正确。如果在数据库中找到了多条符合条件的数据，但是只能接收一个数据，就会导致这个问题的出现。[1][2][3]

阅读全文