使用Hutool实现树状层级结构

铁甲小宝磊

已于 2023-02-28 11:55:29 修改

阅读量739

点赞数

文章标签： mybatis java mysql

于 2023-02-28 11:28:55 首次发布

本文链接：https://blog.csdn.net/Tianl1997/article/details/129257967

版权

标题最近看Hutool中的TreeUtil工具包, 能比较简单的获取树状层级结构的功能, 记录一下:

获取树状结构 :

sql脚本

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dev_department
-- ----------------------------
DROP TABLE IF EXISTS `dev_department`;
CREATE TABLE `dev_department`  (
  `department_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部门编号',
  `dcode` int(11) NULL DEFAULT NULL COMMENT '部门代码',
  `department_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称',
  `parent_department_id` int(12) NULL DEFAULT 0 COMMENT '父级部门id',
  PRIMARY KEY (`department_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dev_department
-- ----------------------------
INSERT INTO `dev_department` VALUES (1, 37, '股东大会', 0);
INSERT INTO `dev_department` VALUES (2, 3701, '董事会', 1);
INSERT INTO `dev_department` VALUES (3, 370101, '秘书处', 2);
INSERT