SSM、java递归实现tree树形结构

红太狼 2023-05-30 03:45 1阅读 0赞

mysql数据库表

CREATE TABLE `t_s_device_data_classify` (
      `id` varchar(32) NOT NULL COMMENT 'ID',
      `classify_name` varchar(100) DEFAULT NULL COMMENT '资料名称',
      `classify_describe` varchar(200) DEFAULT NULL COMMENT '描述',
      `parent_id` varchar(50) DEFAULT NULL COMMENT '父id',
      `classify_level` varchar(50) DEFAULT NULL COMMENT '等级',
      `classify_sort` varchar(50) NOT NULL DEFAULT '' COMMENT '等级',
      `comp_id` varchar(32) DEFAULT NULL COMMENT '所属企业id',
      `create_user` varchar(32) DEFAULT NULL COMMENT '创建者',
      `create_time` datetime DEFAULT NULL COMMENT '创建时间',
      `update_user` varchar(32) DEFAULT NULL COMMENT '更新人',
      `update_time` datetime DEFAULT NULL COMMENT '更新时间',
      `delflag` int(1) DEFAULT '0' COMMENT '删除标识:0在用，1删除',
      PRIMARY KEY (`id`,`classify_sort`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='设备资料分类表';

vo对象

public class DeviceClassifyVo {
        private String id;
    
        private String classifyName;
    
        private String parentId;
    
        private String classifyLevel;
    
        private String classifySort;
        
        private String classifyDescribe;
        
        private List<DeviceClassifyVo> childrenList;
    
    	public String getId() {
    		return id;
    	}
    
    	public void setId(String id) {
    		this.id = id;
    	}
    
    	public String getClassifyName() {
    		return classifyName;
    	}
    
    	public void setClassifyName(String classifyName) {
    		this.classifyName = classifyName;
    	}
    
    	public String getParentId() {
    		return parentId;
    	}
    
    	public void setParentId(String parentId) {
    		this.parentId = parentId;
    	}
    
    	public String getClassifyLevel() {
    		return classifyLevel;
    	}
    
    	public void setClassifyLevel(String classifyLevel) {
    		this.classifyLevel = classifyLevel;
    	}
    
    	public String getClassifySort() {
    		return classifySort;
    	}
    
    	public void setClassifySort(String classifySort) {
    		this.classifySort = classifySort;
    	}
    
    	public List<DeviceClassifyVo> getChildrenList() {
    		return childrenList;
    	}
    
    	public void setChildrenList(List<DeviceClassifyVo> childrenList) {
    		this.childrenList = childrenList;
    	}
    
    	public String getClassifyDescribe() {
    		return classifyDescribe;
    	}
    
    	public void setClassifyDescribe(String classifyDescribe) {
    		this.classifyDescribe = classifyDescribe;
    	}
    }

Controller层

@ApiOperation(value="资料列表-分类数结构获取")
        @ApiResponses(value={
                @ApiResponse(code=0, message="成功"),
                @ApiResponse(code=500, message="系统异常"),
                @ApiResponse(code=999, message="未登录"),
        }
        )
        @RequestMapping(value="/getDeviceClassify", method= RequestMethod.POST)
        @ResponseBody
        public ResponseEntity<List<DeviceClassifyVo>> getDeviceClassify(){
            return MybatisUtil.tranferPage(deviceDataClassifyService.getDeviceClassify());
        }

service层

@Override
    	public List<DeviceClassifyVo> getDeviceClassify() {
    		Usertoken userToken = UsertokenUtil.getUserToken();
    		String compId = userToken.getCompId();
    		List<DeviceClassifyVo> treeList = new ArrayList<DeviceClassifyVo>();
    		List<DeviceClassifyVo> testTreeList =           
            deviceDataClassifyDao.getDeviceClassify(compId);
    		treeList = this.getTreeList(testTreeList);
    		return treeList;
    	}
    
        
        public List<DeviceClassifyVo> getTreeList(List<DeviceClassifyVo> list){
    	    List<DeviceClassifyVo> ttList = new ArrayList<DeviceClassifyVo>();
    		for (DeviceClassifyVo vo : list) {
    			if (DataValidUtil.isEmpty(vo.getParentId())) {
    				DeviceClassifyVo tv = new DeviceClassifyVo();
    				tv.setId(vo.getId());
    				tv.setClassifyName(vo.getClassifyName());
    				tv.setClassifyDescribe(vo.getClassifyDescribe());
    				tv.setClassifyLevel(vo.getClassifyLevel());
    				tv.setClassifySort(vo.getClassifySort());
    				tv.setParentId(vo.getParentId());
    				//获取子菜单
    				tv.setChildrenList(this.getTreeMol(tv.getId(), list));
    				ttList.add(tv);
    			}
    		}
    		return ttList;
    	}
    
    
    	public List<DeviceClassifyVo> getTreeMol(String parentId, 
            List<DeviceClassifyVo> list){
    		List<DeviceClassifyVo> molList = new ArrayList<DeviceClassifyVo>();
    		//获取一级子节点
    		List<DeviceClassifyVo> child = new ArrayList<DeviceClassifyVo>();
    		for (DeviceClassifyVo vo : list) {
    			if (parentId.equals(vo.getParentId())) {
    				child.add(vo);
    			}
    		}
    		//获取一级子节点所有子节点
    		for (DeviceClassifyVo tt : child) {
    			DeviceClassifyVo tv = new DeviceClassifyVo();
    			tv.setId(tt.getId());
    			tv.setClassifyName(tt.getClassifyName());
    			tv.setClassifyDescribe(tt.getClassifyDescribe());
    			tv.setClassifyLevel(tt.getClassifyLevel());
    			tv.setClassifySort(tt.getClassifySort());
    			tv.setParentId(tt.getParentId());
    			List<DeviceClassifyVo> treeMol = getTreeMol(tv.getId(), list);
    			if (!treeMol.isEmpty()) {
    				tv.setChildrenList(treeMol);
    			}
    			molList.add(tv);
    		}
    		return molList;
    	}

Dao层

/**
    	 * @author pan
    	 *@Description: 资料分类
    	 *@Create Date: 2020-07-06
    	 *@param
    	 *@return List<DeviceClassifyVo>
    	 */
    	List<DeviceClassifyVo> getDeviceClassify(@Param("compId")String compId);

Mapper

<select id="getDeviceClassify" resultType="cn.com.guanfang.courtmaintain.device.vo.DeviceClassifyVo" parameterType="java.lang.String">
    SELECT
    	dc.id,
    	dc.classify_name classifyName,
    	dc.classify_describe classifyDescribe,
    	dc.classify_level classifyLevel,
    	dc.classify_sort classifySort,
    	dc.parent_id parentId
    FROM
    	t_s_device_data_classify dc
    WHERE
    	dc.delflag = 0
    	<if test="compId != null and compId != ''">
    		AND (dc.comp_id = #{compId,jdbcType=VARCHAR} or dc.comp_id is null or dc.comp_id = '')
    	</if>
    ORDER BY dc.classify_level, cast(dc.classify_sort as UNSIGNED INTEGER)
    </select>