递归记录（菜单目录分级）

最新推荐文章于 2024-07-16 10:16:48 发布
最新推荐文章于 2024-07-16 10:16:48 发布
阅读量368 收藏 1
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/nathanielsv/article/details/107524892
版权

Spring Boot 实体类（使用Jpa的技术，lombok）

@Data
@ToString
@Entity
@Table(name="teachplan")
@GenericGenerator(name = "jpa-uuid", strategy = "uuid")
public class Teachplan implements Serializable {
    private static final long serialVersionUID = -916357110051689485L;
    //主键
    @Id
    @GeneratedValue(generator = "jpa-uuid")
    @Column(length = 32)
    private String id;
    private String pname;
    private String parentid;
    private String grade;
    private String ptype;
    private String description;
    private String courseid;
    private String status;
    private Integer orderby;
    private Double timelength;
    private String trylearn;

}

子类继承父类，一对多

@Data
@ToString
public class TeachplanNode extends Teachplan {

    List<TeachplanNode> children;

}

service层使用递归的手法查询出所有的菜单及其子菜单

@Service
public class TeachPlanServiceImpl implements TeachPlanService {

    @Resource
    private TeachPlanDao teachPlanDao;

    /**
     * 根据课程Id查询所有的课程计划
     * @param courseId
     * @return
     */
    @Override
    public List<TeachplanNode> getAllTeachPlanByCourseId(String courseId) {
        Teachplan teachplan = new Teachplan();
        teachplan.setCourseid(courseId);
        Example<Teachplan> example = Example.of(teachplan);
        List<Teachplan> teachplanList = teachPlanDao.findAll(example);
        List<TeachplanNode> teachplanNodeList = changeTeachePlanToTeacherplanNode(teachplanList);

        List<TeachplanNode> rootTeachPlan = getRootTeachPlan(teachplanNodeList);

        return rootTeachPlan;
    }

    public List<TeachplanNode> changeTeachePlanToTeacherplanNode(List<Teachplan> list){
        List<TeachplanNode> teachplanNodeList = new ArrayList<>();
        for(Teachplan teachplan:list){
            TeachplanNode teachplanNode = new TeachplanNode();
            teachplanNode.setId(teachplan.getId());
            teachplanNode.setPname(teachplan.getPname());
            teachplanNode.setParentid(teachplan.getParentid());
            teachplanNode.setGrade(teachplan.getGrade());
            teachplanNode.setPtype(teachplan.getPtype());
            teachplanNode.setDescription(teachplan.getDescription());
            teachplanNode.setTimelength(teachplan.getTimelength());
            teachplanNode.setCourseid(teachplan.getCourseid());
            teachplanNode.setOrderby(teachplan.getOrderby());
            teachplanNode.setStatus(teachplan.getStatus());
            teachplanNodeList.add(teachplanNode);
        }
        return teachplanNodeList;
    }

    /**
     * 根据所有的List<TeachplanNode>查找出tree型结构
     * @param list
     * @return
     */
    private List<TeachplanNode> getRootTeachPlan(List<TeachplanNode> list){

        List<TeachplanNode> teachplanNodeList = new ArrayList<>();
        for(TeachplanNode teachplanNode:list){
            //根据长度判断是否为根节点，如果是根节点，设置children;
            if(teachplanNode.getParentid().equals("0")){
                System.out.println(teachplanNode.getId());
                teachplanNode.setChildren(getChildrenTeachPlanNodeList(teachplanNode.getId(),list));
                teachplanNodeList.add(teachplanNode);
            }
        }
        return teachplanNodeList;

    }

    /**
     * 为teachplanNode设置children
     * @param pid 初始参数父id==0的id，和List<TeachplanNode>
     * @param list
     * @return
     */
    private List<TeachplanNode> getChildrenTeachPlanNodeList(String pid,List<TeachplanNode> list){
        List<TeachplanNode> list1 = new ArrayList<>();
        //遍历传来的List<TeachplanNode>
        for(TeachplanNode teachplanNode:list){
           //如果teachplanNode的parentId ==父亲的id
            if(teachplanNode.getParentid().equals(pid)){
                //将这个teachplanNode加入到集合中
                list1.add(teachplanNode);
                //递归调用这个方法使用这个teachplanNode作为根节点，查询它的子节点
                teachplanNode.setChildren(getChildrenTeachPlanNodeList(teachplanNode.getId(),list));
            }
        }
        if(list1.size()==0){
            list1=null;
        }
        return list1;
    }

/*
 Navicat Premium Data Transfer

 Source Server         : crm
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost:3306
 Source Schema         : zx_course

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : 65001

 Date: 22/07/2020 22:26:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for teachplan
-- ----------------------------
DROP TABLE IF EXISTS `teachplan`;
CREATE TABLE `teachplan`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pname` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `parentid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `grade` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '层级，分为1、2、3级',
  `ptype` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程类型:1视频、2文档',
  `description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '章节及课程时介绍',
  `timelength` double(5, 2) NULL DEFAULT NULL COMMENT '时长，单位分钟',
  `courseid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程id',
  `orderby` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序字段',
  `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态：未发布、已发布',
  `trylearn` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否试学',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of teachplan
-- ----------------------------
INSERT INTO `teachplan` VALUES ('1', 'Bootstrap开发框架', '0', '1', '0', NULL, NULL, '4028e581617f945f01617f9dabc40000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('2', '计算机原理', '1', '2', '0', '介绍计算机工作原理', NULL, '4028e581617f945f01617f9dabc40000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('22', 'spring cloud与spring boot实战', '0', '1', NULL, NULL, NULL, '4028e58161bcf7f40161bcf8b77c0000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('297e02f7639af61a01639afd3a7b0000', '第一节', '402885816243d2dd016243f24c040003', '2', '1', NULL, NULL, '402885816243d2dd016243f24c030002', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('3', '计算机硬件', '2', '3', '1', NULL, 10.00, '4028e581617f945f01617f9dabc40000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4', '计算机软件', '2', '3', '1', NULL, 12.00, '4028e581617f945f01617f9dabc40000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('402881e66417407b01641744afc30000', '基础知识', '4028858162e5d6e00162e5e0227b0000', '2', NULL, NULL, NULL, '297e7c7c62b888f00162b8a965510001', NULL, '0', NULL);
INSERT INTO `teachplan` VALUES ('402881e66417407b01641744fc650001', '入门程序', '402881e66417407b01641744afc30000', '3', '1', '入门程序', 11.00, '297e7c7c62b888f00162b8a965510001', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('402881e764034e430164035091a00002', '面向对象', '4028858162bec7f30162becad8590000', '2', NULL, '面向对象', NULL, '297e7c7c62b888f00162b8a7dec20000', '3', '0', NULL);
INSERT INTO `teachplan` VALUES ('402881e764034e4301640351f3d70003', '一切皆为对象', '402881e764034e430164035091a00002', '3', '1', '一切皆为对象', 10.00, '297e7c7c62b888f00162b8a7dec20000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('402885816240d276016240f7e5010003', 'test', '0', '1', NULL, NULL, NULL, '402885816240d276016240f7e5000002', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('402885816240d276016241019be70005', 'ddd', '0', '1', NULL, NULL, NULL, '402885816240d276016241019be70004', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('402885816240d2760162410bac010007', 'ffff', '0', '1', NULL, NULL, NULL, '402885816240d2760162410bac010006', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('402885816240d2760162414086a0000b', '课程介绍', '402885816240d276016240f7e5010003', '2', '1', NULL, NULL, '402885816240d276016240f7e5000002', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('402885816240d2760162414102fd000c', '如何学习一个项目', '402885816240d2760162414086a0000b', '3', '1', NULL, NULL, '402885816240d276016240f7e5000002', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('402885816240d2760162416df996000d', '我是一个新课时，请点击修改填写正确信息', '402885816240d2760162414086a0000b', '3', NULL, NULL, NULL, '402885816240d276016240f7e5000002', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('402885816243d2dd016243f24c040003', '第一章', '0', '1', NULL, NULL, NULL, '402885816243d2dd016243f24c030002', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('40288581625c7e7301625c8ed6be0001', 'test001', '0', '1', NULL, NULL, NULL, '40288581625c7e7301625c8ed6af0000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028858162bec7f30162becad8590000', 'test_java基础33', '0', '1', NULL, NULL, NULL, '297e7c7c62b888f00162b8a7dec20000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028858162bec7f30162bed26cd70001', 'java基础3', '0', '1', NULL, NULL, NULL, '297e7c7c62b8aa9d0162b8ab56ba0001', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028858162bee2020162bee3c9c60000', '我是一个新章节，请点击修改填写正确信息', '4028858162bec7f30162bed26cd70001', '2', NULL, NULL, NULL, '297e7c7c62b8aa9d0162b8ab56ba0001', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028858162bee9e90162beea3f480000', 'java基础3', '0', '1', NULL, NULL, NULL, '297e7c7c62b8aa9d0162b8ab70e90002', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028858162bee9e90162beea81690001', '我是一个新章节，请点击修改填写正确信息', '4028858162bee9e90162beea3f480000', '2', '1', 'fdsfds', 2.00, '297e7c7c62b8aa9d0162b8ab70e90002', '1', '1', NULL);
INSERT INTO `teachplan` VALUES ('4028858162e0bc0a0162e0bfdf2b0001', '人工智能+python', '0', '1', NULL, NULL, NULL, '4028858162e0bc0a0162e0bfdf1a0000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028858162e5d6e00162e5e0227b0000', 'test_java基础2', '0', '1', NULL, NULL, NULL, '297e7c7c62b888f00162b8a965510001', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028858162e5d6e00162e5e0727d0001', 'java基础语法', '4028858162e5d6e00162e5e0227b0000', '2', '1', NULL, NULL, '297e7c7c62b888f00162b8a965510001', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028858163012bbf01630136a5140000', 'java基础3', '0', '1', NULL, NULL, NULL, '297e7c7c62b8aa9d0162b8ab13910000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('40288581632b593e01632bd4ec360000', '程序入门', '4028858162bec7f30162becad8590000', '2', '1', NULL, NULL, '297e7c7c62b888f00162b8a7dec20000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('40288581632b593e01632bd53ff10001', 'Hello World', '0', '2', '1', NULL, NULL, '297e7c7c62b888f00162b8a7dec20000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('40288581632b593e01632bd597810002', '编程基础', '4028858162bec7f30162becad8590000', '2', '1', NULL, NULL, '297e7c7c62b888f00162b8a7dec20000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('40288581632b593e01632bd5d31f0003', '表达式', '40288581632b593e01632bd597810002', '3', '1', NULL, NULL, '297e7c7c62b888f00162b8a7dec20000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('40288581632b593e01632bd606480004', '逻辑运算', '40288581632b593e01632bd597810002', '3', '1', NULL, NULL, '297e7c7c62b888f00162b8a7dec20000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('402885816347f814016348d68bad0000', '数据库基础知识', '4028e581617ce7b601617ce801790000', '3', '1', NULL, NULL, '4028e581617f945f01617f9dabc40000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('402885816347f814016348d6c5920001', 'SQL查询', '4028e581617ce7b601617ce801790000', '3', '1', NULL, NULL, '4028e581617f945f01617f9dabc40000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('402885816347f814016348d7153c0002', 'SQL优化', '4028e581617ce7b601617ce801790000', '3', '1', NULL, NULL, '4028e581617f945f01617f9dabc40000', '3', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028a55673764e1d0173765ad3450000', 'qqq', '4028a5bb73760e2f01737644eb220001', '3', '1', '12', 100.00, '297e7c7c62b888f00162b8a7dec20000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028a55673764e1d0173767cc5740001', 'q', '4028a55673764e1d0173765ad3450000', '3', '1', '1', 1.00, '297e7c7c62b888f00162b8a7dec20000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028a5bb73760e2f01737644eb220001', '123', '402881e764034e430164035091a00002', '3', '1', '3', 3.00, '297e7c7c62b888f00162b8a7dec20000', '3', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028a5bb73767313017376754dda0001', '1', '0', '2', '1', '12', 1.00, '402885816243d2dd016243f24c030002', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028a5bb73767313017376779e060002', '1', '0', '2', '1', '1', 1.00, '402885816243d2dd016243f24c030002', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028a5bb7376731301737678698f0003', '2', '297e02f7639af61a01639afd3a7b0000', '2', '2', '2', 2.00, '402885816243d2dd016243f24c030002', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e581617ce7b601617ce801790000', '数据库编程', '1', '2', '1', '数据库编程数据库编程', 11.00, '4028e581617f945f01617f9dabc40000', '4', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e581617d02e101617d070ed90000', '操作系统类型介绍', '8', '3', '1', '操作系统类型介绍操作系统类型介绍', 11.00, '4028e581617f945f01617f9dabc40000', '6', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bbcd350161bbcefe3d0001', '操作系统原理', '8', '3', '1', '操作系统原理操作系统原理操作系统原理操作系统原理', 22.00, '4028e581617f945f01617f9dabc40000', '6', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd14c20161bd14f1520000', '微服务架构入门', '22', '2', NULL, '微服务架构入门', NULL, '4028e58161bcf7f40161bcf8b77c0000', '1-1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd18ea0161bd1b00ab0000', '为什么要使用微服务:单体架构的特点', '4028e58161bd14c20161bd14f1520000', '3', '1', '为什么要使用微服务:单体架构的特点', 44.00, '4028e58161bcf7f40161bcf8b77c0000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd18ea0161bd1bd2d10001', '为什么要使用微服务:微服务的优缺点', '4028e58161bd14c20161bd14f1520000', '3', '1', '为什么要使用微服务:微服务的优缺点', 55.00, '4028e58161bcf7f40161bcf8b77c0000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd18ea0161bd1c83590002', 'spring cloud 基础入门', '22', '2', NULL, 'spring cloud 基础入门', NULL, '4028e58161bcf7f40161bcf8b77c0000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd18ea0161bd1cc4850003', '实战-Spring Boot', '22', '2', NULL, '实战-Spring Boot', NULL, '4028e58161bcf7f40161bcf8b77c0000', '3', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd18ea0161bd1cf3e10004', '注册中心Eureka', '22', '2', NULL, '注册中心Eureka', 55.00, '4028e58161bcf7f40161bcf8b77c0000', '4', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd18ea0161bd1d2f3f0005', '为什么要选择spring cloud?', '4028e58161bd18ea0161bd1c83590002', '3', '1', '为什么要选择spring cloud?', 12.00, '4028e58161bcf7f40161bcf8b77c0000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd18ea0161bd1d8f1b0006', '为什么springcloud要设计一套新的版本升级规则？', '4028e58161bd18ea0161bd1c83590002', '3', '1', '为什么springcloud要设计一套新的版本升级规则？', 33.00, '4028e58161bcf7f40161bcf8b77c0000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd18ea0161bd1df0ad0007', '为什么越来越多的开发者选择使用spring boot？它解决了什么问题？', '4028e58161bd18ea0161bd1cc4850003', '3', '1', '为什么越来越多的开发者选择使用spring boot？它解决了什么问题？', 10.00, '4028e58161bcf7f40161bcf8b77c0000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd18ea0161bd1f73190008', 'spring boot的入门例子', '4028e58161bd18ea0161bd1cc4850003', '3', '1', 'spring boot的入门例子', 44.00, '4028e58161bcf7f40161bcf8b77c0000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd18ea0161bd1fd31c0009', '微服务架构为什么需要注册中心，它解决了什么问题？', '4028e58161bd18ea0161bd1cf3e10004', '3', '1', '微服务架构为什么需要注册中心，它解决了什么问题？', 33.00, '4028e58161bcf7f40161bcf8b77c0000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd18ea0161bd202c45000a', ' 一个Eureka注册中心的入门例子', '4028e58161bd18ea0161bd1cf3e10004', '3', '1', ' 一个Eureka注册中心的入门例子', 22.00, '4028e58161bcf7f40161bcf8b77c0000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd22e60161bd2366fb0000', 'Javascript之VueJS', '0', '1', NULL, NULL, NULL, '4028e58161bd22e60161bd23672a0001', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd269f0161bd270a340000', 'Vuejs 第一讲', '4028e58161bd22e60161bd2366fb0000', '2', NULL, 'Vuejs 第一讲', NULL, '4028e58161bd22e60161bd23672a0001', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd269f0161bd2778750001', '第一节 vue基础、常用指令、bootstrap+vue的简易留言', '4028e58161bd269f0161bd270a340000', '3', '1', '第一节 vue基础、常用指令、bootstrap+vue的简易留言', 22.00, '4028e58161bd22e60161bd23672a0001', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd269f0161bd27d7c50002', '第二节 属性和事件、模板、交互、案例', '4028e58161bd269f0161bd270a340000', '3', '1', '第二节 属性和事件、模板、交互、案例', 33.00, '4028e58161bd22e60161bd23672a0001', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd269f0161bd281bde0003', 'Vuejs 第二讲', '4028e58161bd22e60161bd2366fb0000', '2', NULL, NULL, NULL, '4028e58161bd22e60161bd23672a0001', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd269f0161bd284bad0004', 'Vuejs 第三讲', '4028e58161bd22e60161bd2366fb0000', '2', NULL, NULL, NULL, '4028e58161bd22e60161bd23672a0001', '3', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd269f0161bd2877740005', '第一节 计算属性的使用、vue实例的简单方法、提高循环的性能，让重复数据显示出来', '4028e58161bd269f0161bd281bde0003', '3', NULL, NULL, NULL, '4028e58161bd22e60161bd23672a0001', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd269f0161bd293df90006', '第二节 自定义过滤器、自定义指令 、自定义键盘事件、数据的监听', '4028e58161bd269f0161bd281bde0003', '3', '1', NULL, NULL, '4028e58161bd22e60161bd23672a0001', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd3b380161bd3bcd400001', 'Redis从入门到项目实战', '0', '1', NULL, NULL, NULL, '4028e58161bd3b380161bd3bcd2f0000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd3b380161bd3e47da0003', '第一章：redis简介', '4028e58161bd3b380161bd3bcd400001', '2', NULL, NULL, NULL, '4028e58161bd3b380161bd3bcd2f0000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd3b380161bd3f484c0004', '第二章：redis的安装与配置', '4028e58161bd3b380161bd3bcd400001', '2', NULL, NULL, NULL, '4028e58161bd3b380161bd3bcd2f0000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd3b380161bd3f6f440005', '第三章：Redis数据操作', '4028e58161bd3b380161bd3bcd400001', '2', NULL, NULL, NULL, '4028e58161bd3b380161bd3bcd2f0000', '3', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd3b380161bd3fb0050006', '第四章：Redis进阶操作', '4028e58161bd3b380161bd3bcd400001', '2', NULL, NULL, NULL, '4028e58161bd3b380161bd3bcd2f0000', '4', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd3b380161bd3fd3420007', '第五章：Redis主从配置', '4028e58161bd3b380161bd3bcd400001', '2', NULL, NULL, NULL, '4028e58161bd3b380161bd3bcd2f0000', '5', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd3b380161bd3fe9220008', '第一节 NoSQL简介', '4028e58161bd3b380161bd3e47da0003', '3', '1', NULL, NULL, '4028e58161bd3b380161bd3bcd2f0000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('4028e58161bd3b380161bd40cf340009', '第二节 认识Redis', '4028e58161bd3b380161bd3e47da0003', '3', '1', NULL, NULL, '4028e58161bd3b380161bd3bcd2f0000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('5', '计算机编程入门', '1', '2', '0', NULL, NULL, '4028e581617f945f01617f9dabc40000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('6', 'java语法介绍', '5', '3', '1', NULL, NULL, '4028e581617f945f01617f9dabc40000', '1', '0', NULL);
INSERT INTO `teachplan` VALUES ('7', 'Hello World', '5', '3', '1', NULL, NULL, '4028e581617f945f01617f9dabc40000', '2', '0', NULL);
INSERT INTO `teachplan` VALUES ('8', '操作系统原理', '1', '2', NULL, NULL, NULL, '4028e581617f945f01617f9dabc40000', '6', '0', NULL);

SET FOREIGN_KEY_CHECKS = 1;
Java未出道
关注
java 3级分类递归
征途人生&梦
04-16 1264
数据库结构 CREATE TABLE `category` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', `parent_id` int(11) DEFAULT '0', `level` in...
多级菜单（C++）
徐小mu的博客
10-04 5898
这个我没去尝试它的功能，所以不是很清楚具体情况，代码我放到这里，感兴趣的就看看，同样需要建一个项目，因为要用到一些学生的信息，需要外界导入。 #include<iostream> #include<string.h> #include<stdlib.h> #include<conio.h> using namespace std; void C...
递归将菜单按照层级排序
鱼儿沟
04-03 872
/** * 递归将菜单按照层级排序 */ public static void sortList(List<ClaimingExpenses> list,List<ClaimingExpenses> list_sort, Integer parentid,String index){ int num = 1; for (int i=0; i<lis...
Java中实现多级菜单的列表（递归排序）
JavaWebEngineer的博客
05-26 4813
一、项目背景 由于最近项目中需要实现展示菜单功能，菜单是需要多级，并且级数不固定。像这种需求，一般就是用递归实现了，可以从第一级一直往下查，一直查询到为空为止。 二、数据库实体类字段 两个实体类，一个是对应数据库的实体类，VO是返回给前端的实体类 public class RcMenu { private Integer menuId; //菜单ID private String menuName;//菜单名称 private Boolean status; //菜单状态 pri
golang无限层级菜单，子菜单Children 数据递归处理和gorm数据获取示例
最新发布
07-16 475
/ model.SysMenu 菜单表gorm实体模型定义 示例comment:父菜单ID" json:"pid"` // 父菜单IDnot null;comment:菜单名称" json:"name"` // 菜单名称// 这个是我们返回前端的带层级的菜单对象model.SysMenu // 继承model.SysMenu实体模型。
递归--目录操作及无限级分类之子孙树应用
pkgray的专栏
08-18 637
不用递归做递归的效果 菜单排序
xi5566的专栏
04-28 398
废话不多说 直接看service [code="java"] package com.hcwy.jsp.product.service; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.Vector...
【Java】使用递归的方法获取层级关系数据demo
like_start的博客
12-16 893
【代码】【Java】使用递归的方法获取层级关系数据demo。
php菜单/评论数据递归分级算法的实现方法
10-16
本篇文章将详细介绍如何在PHP中使用递归实现菜单和评论数据的分级。 首先，我们需要理解数据结构。在例子中，我们有一个二维数组`$menuList`，它包含多条记录，每条记录有三个字段：`id`（唯一标识）、`parent_id`...
swift-多级分类菜单多级列表仿口碑分类菜单电商筛选菜单
08-15
根据菜单的层级结构，我们需要递归地填充`UITableView`。当用户点击一个类别时，通过更新`UITableView`的数据源并调用`reloadData()`来展示或隐藏对应的子类别。 ```swift func tableView(_ tableView: UITableView...
jpa单表递归树形结构实现
07-23
springJpa单标递归树形结构
菜单（三）二级菜单和标题栏菜单
跨境电商
02-22 2454
package com.example.menu2; import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.view.Menu; import android.view.MenuItem; import android.widget.Toast;
递归 删除层级记录
andycode的专栏
06-22 916
PrimaryKey    UpLevelCompCode   UpLevelCompName   CurrentLevelCompCode    CurrentLevelCompName    CurrentLevel1                           0                             0                            
关于递归的记录
黑糖玉米的博客
11-15 206
由于项目的原因接触了三种数据库，分别是Oracle、MySQl、PostgreSQL，在此记录一下三种数据库递归查询的用法(以查询某节点下所有子节点为例)！ 1、Oracle——有自带的递归函数，一般最上级我都不用递归，直接查全部 select t.* from sys_postorg t start with id = '11010101' connect by prior parent_...
java 文章目录递归（一级标题，二级标题）
strom_xu
05-15 1734
java 文章目录递归（一级标题，二级标题） 1、表现样式 2、废话不多说，直接上代码 Dept{ private int id; private String name; private int pid; private int orderId; } DeptLevelVo{ private int id; private String...
Java文件目录层级递归
小张的博客
05-07 1507
多级菜单实现等级自动划分
Shawn_YuL的博客
02-21 1416
经常会遇到多级菜单、多级分类问题，但是某个数据处于第几级，应该是程序自己判断得出，新增一条数据时，父级以上的需要升级，删除一条数据时，父级以上的需要降级。下面总结了自己用到的一个公用方法去处理等级问题： /** * 递归更新父级以及以上分类的等级(升级+1、降级-1) * @param tbInformation 当前实体对象 * @param num 父级分类的等级，将要
Java递归查询文件夹目录层级
凌岩歌贰拾肆的专栏
12-06 2407
/** * * 递归查找父级，一直查找到root为止，最终返回包含所有Folder的List，因为是递归，所以不能在方法里new 容器List，那样每次递归都会new一个List * 所以容器List必须从外部传入, 终止条件(基础情况)parentId == -1 */ private List&lt;FolderDto&gt; get...
C#递归实现文件目录树结构
"使用递归生成文件目录树 .txt" 在计算机编程中，尤其是在处理文件系统操作时，经常需要以图形化方式展示文件目录结构。本文将深入探讨如何使用递归算法在C#环境中生成一个文件目录树。递归是一种强大的编程技术，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值