67,549
社区成员




public List<WorksDetailDto> findCustomList() {
List<Map> maps = tsArtWorksMapper.findCustomList();
List<WorksDetailDto> dtos = new ArrayList<>();
for (Map m:maps) {
WorksDetailDto dto = new WorksDetailDto();
MemberDto member = new MemberDto();
member.setUid((String)m.get("member_uid"));
member.setName((String)m.get("member_name"));
dto.setMember(member);
dto.setUid((String)m.get("works_uid"));
dto.setName((String)m.get("works_name"));
dto.setDesc((String)m.get("wordk_desc"));
dto.setCreateTime((Long)m.get("works_create_time"));
String imageJson = (String) m.get("image_json");
List<ImageDto> images = JSONObject.parseArray(imageJson, ImageDto.class);
dto.setImages(images);
dtos.add(dto);
}
return dtos;
}
public class WorksDetailDto {
private MemberDto member;
private List<ImageDto> images;
private String uid;
private String name;
private String desc;
private Long createTime;
。。。。get set省略
这其中member是一个对象。有它自己的属性,images是一个数组,并且其中每个元素都是一个ImageDto对象,这种复杂的对象除非在 ResultMap中详细配置说明,否则无法直接返回的
sql语句如下:
SELECT
m.uid member_uid,
m.`name` member_name,
aw.uid works_uid,
aw.title works_name,
aw.content works_desc,
aw.create_time works_create_time,
aw.image_json
FROM
works aw
INNER JOIN pic ap ON aw.id = ap.node_id
INNER JOIN member m ON aw.member_id = m.id
WHERE
m.id = 21