Mybatis中使用一对多查询实体list重复实体多条显示的方案
本文原创,转载请标明原著地址,尊重原著,谢谢!
一、mybatis实现一对多关联查询返回实体list:
1、首先定义包含连表查询list的相关实体:
public class PlaylistInfoExtendBO extends PlaylistInfoDO{
private List<MaterialLibraryExtendDO> materialLibraryDOList;
public List<MaterialLibraryExtendDO> getMaterialLibraryDOList() {
return materialLibraryDOList;
}
public void setMaterialLibraryDOList(List<MaterialLibraryExtendDO> materialLibraryDOList) {
this.materialLibraryDOList = materialLibraryDOList;
}
@Override
public String toString() {
return "PlaylistInfoExtendBO{" +
"materialLibraryDOList=" + materialLibraryDOList +
'}'+"PlaylistInfoDO{" +
"id=" + super.toString();
}
}
2、接下来通过mybatis中的collection进行连表查询出多个实体:
<resultMap id="RpcResult" type="com.startdt.admserver.model.dos.PlaylistInfoExtendBO">
<id column="ID"