java children子節點中添加元素；
public List<StageClass1Node> stageClassList1(String RowGuid) {
List<StageClass1Node> stage = stageClasDao.findStage(RowGuid);
Integer classTotalCount = stageClassDao.findClassTotalCount(RowGuid);
Integer classStudyCount = stageClassDao.findClassStudyCount(RowGuid);
for (StageClass1Node stageClass : stage) {
// 某階段下課節數
Integer stageClassCount = stageClassDao.findStageClassCount(stageClass.getStageRowGuid());
stageClass.setStageClassCount(stageClassCount);
Integer buyCourseCount = courseAllDao.findBuyCourseCount(RowGuid);
Integer classCount = courseAllDao.findClassCount(RowGuid);
stageClass.setStudyClassCount(classStudyCount);// 當前課程下已學習課節數量
if (stageClass.getTIstest() == null) {
stageClass.setTIstest(0);
}
if (buyCourseCount == null) {
stageClass.setBuyCount(0);
} else {
stageClass.setBuyCount(buyCourseCount);
}
if (classCount == null) {
stageClass.setClassCount(0);
} else {
stageClass.setClassCount(classTotalCount);
}
if (stageClass.getBuyCount()==null) {
stageClass.setBuyCount(0);
}
for (int i=0;i<stage.size();i++) {
String classRowGuid = stage.get(i).getClassRowGuid();
List<ClassLinkVo> classLinkStatus = classLinkVoDao.findClassLinkStatus(classRowGuid);
for (ClassLinkVo classLinkVo : classLinkStatus) {
stage.get(i).setList(classLinkStatus);
stageClass.setList(classLinkStatus);
if (classLinkVo.getTLinkName().equals("作品")) {
classLinkVo.setType(3);
} else if (classLinkVo.getTLinkName().equals("預習")){
classLinkVo.setType(1);
} else if (classLinkVo.getTLinkName().equals("上課")){
classLinkVo.setType(2);
}
}
}
}
return stage;
}@Data
public class StageClass1 {
private String id;
private String StageRowGuid;
private String classRowGuid;
private String StageName;
private String ClassName;
private String tCourseName;
private String ClassUpdateDate;
private String StageUpdateDate;
private String imgUrl;
/**
* 用戶名
*/
private String tUsername;
/**
* 真實姓名
*/
private String tRealyname;
private Integer buyCount;
private Integer classCount;
private Integer tIstest;
private Integer studyClassCount;
private Integer stageClassCount;
private List list;
}
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.stylefeng.guns.dao.StageClass1Dao">
<!-- 通用查詢映射結果 -->
<resultMap id="selectListMap" type="cn.stylefeng.guns.pojos.StageClass1Node">
<id column="stage_id" property="id" />
<result column="classRowGuid" property="classRowGuid" />
<result column="t_course_name" property="tCourseName" />
<result column="stage_rowguid" property="StageRowGuid" />
<result column="StageUpdateDate" property="StageUpdateDate" />
<result column="StageName" property="StageName" />
<result column="t_username" property="tUsername" />
<result column="t_realyname" property="tRealyname" />
<collection property="children" ofType="cn.stylefeng.guns.pojos.StageClass1Node" >
<id column="classId" property="id" />
<result column="t_istest" property="tIstest" />
<result column="classRowGuid" property="classRowGuid" />
<result column="ClassName" property="ClassName" />
<result column="ClassUpdateDate" property="ClassUpdateDate" />
<result column="t_username" property="tUsername" />
<result column="t_realyname" property="tRealyname" />
<result column="t_img_url" property="imgUrl" />
</collection>
</resultMap>
<select id="findStage" resultMap="selectListMap" >
SELECT s.id stage_id,s.row_guid stage_rowguid,s.t_name StageName,c.t_img_url,
c.id classId,c.row_guid classRowGuid,c.t_name ClassName,c.t_istest,
co.t_course_name,e.t_username,e.t_realyname,c.t_update_date ClassUpdateDate,
s.t_update_date StageUpdateDate
FROM tb_course co LEFT JOIN tb_stage s ON FIND_IN_SET(s.row_guid,co.stage_id) LEFT JOIN
tb_class c ON FIND_IN_SET(c.id,s.t_class_id),tb_employee e WHERE co.row_guid=#{RowGuid}
AND s.t_update_man=e.id
</select>
</mapper>
@Data
@ToString
public class StageClass1Node extends StageClass1 {
private List<StageClass1Node> children;
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/83514.html
標籤：Java相關