标题最近看Hutool中的TreeUtil工具包, 能比较简单的获取树状层级结构的功能, 记录一下:
获取树状结构 :
- sql脚本
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
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;
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