1.效果图:
2.postman查询出来的数据
3.mapper
<resultMap id="BaseResultMap" type="cn.jeefast.modules.platform.entity.PfClass">
<id column="cid" property="cid" />
<result column="cname" property="cname" />
<collection property="pfStudents" ofType="PfStudent">
<id property="sid" column="sid"></id>
<result property="sname" column="sname"></result>
</collection>
</resultMap>
<select id="queryPageList" resultMap="BaseResultMap">
select * from pf_class pc left join pf_student ps on pc.`cid`=ps.`sclass`
</select>
js端需要循环读取
{ label: '班级编号', name: 'cid', index: "cid", width: 15, key: true },
{ label: '班级名称', name: 'cname', width: 75 },
{ label: '包含人员', name: 'pfStudents', width: 53 ,formatter:function (value,options,row) {
var len = value.length;
var list = "";
for(var i = 0;i<len;i++){
list +=value[i].sname;
list +=",";
}
return list;
}},
],
5.其余的和之前一样,controller的都一样