我想使用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
LEFT JOIN `services_box_title` AS sbt ON sbt.services_title_id = st.id
LEFT JOIN `services_box_text` AS sbx ON sbx.services_box_title_id = sbt.id
WHERE st.state = 1 and sbt.text_order != 0 and sbx.text_order != 0
下面展示一些 实体类的属性
。两个分别在不同的实体类里面
@TableField(exist = false)
private List servicesBoxTitles;
@TableField(exist = false)
private List servicesBoxTexts;
下面展示一些mapper.java
。
@Mapper
public interface ServicesTitleMapper extends BaseMapper {
/**
* 获取我们的服务所有信息
*/
ServicesTitle getServices();
}
下面是sql语句查询出来的数据