湖北省建设厅官方网站电话网站推广方法

数据库关系有父子id的, 作为菜单栏展示时需要用前端需要用到懒加载, 所谓懒加载就是接口有一个标志位isLeaf, 前端请求后通过该字段判断该节点是否还有子节点数据

创建数据库表 t_company_info结构有id和parentId标识, 用来表示父子关系

/*Navicat Premium Data TransferSource Server         : mysql8.0Source Server Type    : MySQLSource Server Version : 80029 (8.0.29)Source Host           : localhost:3307Source Schema         : springboot_mybatisTarget Server Type    : MySQLTarget Server Version : 80029 (8.0.29)File Encoding         : 65001*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for t_company_info
-- ----------------------------
DROP TABLE IF EXISTS `t_company_info`;
CREATE TABLE `t_company_info`  (`id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'id',`company_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司名',`parent_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '父节点id',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of t_company_info
-- ----------------------------
INSERT INTO `t_company_info` VALUES ('1', '旺旺集团', '0');
INSERT INTO `t_company_info` VALUES ('2', '广州分部', '1');
INSERT INTO `t_company_info` VALUES ('3', '深圳分部', '1');
INSERT INTO `t_company_info` VALUES ('4', '福田区分公司', '3');
INSERT INTO `t_company_info` VALUES ('5', '南山区分公司', '3');SET FOREIGN_KEY_CHECKS = 1;

有需要的配置文件 application.yml 可参考

spring:datasource:username: #填写账号password: #填写密码url: jdbc:mysql://localhost:3307/springboot_mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8&allowPublicKeyRetrieval=true#&allowPublicKeyRetrieval=true这一部分设置是mysql8里面的, 不设置验证会报错driver-class-name: com.mysql.cj.jdbc.Drivertype: com.alibaba.druid.pool.DruidDataSourcedruid:stat-view-servlet:enabled: truelogin-username: login-password: web-stat-filter:enabled: true#  sql:
#    init:
#      schema-locations: classpath:sql/schema.sql
#      mode: always
server:port: 8089logging:level:root: info  #日志等级com.example.mybatis_plus: info
mybatis-plus:configuration:map-underscore-to-camel-case: true  #下划线转驼峰global-config:db-config:logic-not-delete-value: 0  #逻辑删除logic-delete-field: 1
#  type-enums-package: com.example.mybatis_plus.enums.statusEnum

1.创建实体类

package com.example.mybatis_plus.entity;import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;import java.io.Serializable;/*** <p>* * </p>** @author * @since 2023-04-01*/
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("t_company_info")
@ApiModel(value="CompanyInfo对象", description="")
public class CompanyInfo implements Serializable {private static final long serialVersionUID = 1L;@ApiModelProperty(value = "id")@TableId(value = "id", type = IdType.ASSIGN_UUID)private String id;@ApiModelProperty(value = "公司名")private String companyName;@ApiModelProperty(value = "父节点id")private String parentId;}

2.创建service接口

package com.example.mybatis_plus.service;import com.baomidou.mybatisplus.extension.service.IService;
import com.example.mybatis_plus.entity.CompanyInfo;import java.util.List;/*** <p>*  服务类* </p>** @author * @since 2023-04-01*/
public interface CompanyInfoService extends IService<CompanyInfo> {/*** 获得指定父节点的子节点列表* @param parentId 父节点ID* @return 子节点列表*/List<CompanyInfo> getChildNodes(String parentId);
}

3.完成其实现类

package com.example.mybatis_plus.service.impl;import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.mybatis_plus.entity.CompanyInfo;
import com.example.mybatis_plus.mapper.CompanyInfoMapper;
import com.example.mybatis_plus.service.CompanyInfoService;
import org.springframework.stereotype.Service;import java.util.List;/*** <p>*  服务实现类* </p>** @author * @since 2023-04-01*/
@Service
public class CompanyInfoServiceImpl extends ServiceImpl<CompanyInfoMapper, CompanyInfo> implements CompanyInfoService {@Overridepublic List<CompanyInfo> getChildNodes(String parentId) {List<CompanyInfo> list=list(new QueryWrapper<CompanyInfo>().eq("parent_id",parentId));return list;}
}

4.mapper接口

package com.example.mybatis_plus.mapper;import com.example.mybatis_plus.entity.CompanyInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;/*** <p>*  Mapper 接口* </p>** @author * @since 2023-04-01*/
public interface CompanyInfoMapper extends BaseMapper<CompanyInfo> {}

5.mapper文件

<?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="com.example.mybatis_plus.mapper.CompanyInfoMapper"><!-- 通用查询映射结果 --><resultMap id="BaseResultMap" type="com.example.mybatis_plus.entity.CompanyInfo"><id column="id" property="id" /><result column="company_name" property="companyName" /><result column="parent_id" property="parentId" /></resultMap><!-- 通用查询结果列 --><sql id="Base_Column_List">id, company_name, parent_id</sql></mapper>

6.result统一结果封装类

@Data
public class Result implements Serializable {private int code;private String msg;private Object data;public static Result success(Object data) {return success(200, "操作成功", data);}public static Result success() {return success(200, "操作成功", null);}public static Result success(int code, String msg, Object data) {Result r = new Result();r.setCode(code);r.setMsg(msg);r.setData(data);return r;}public static Result fail(String msg) {return fail(400, msg, null);}public static Result fail(int code, String msg, Object data) {Result r = new Result();r.setCode(code);r.setMsg(msg);r.setData(data);return r;}}

6.创建树形结构实体类TreeNode

package com.example.mybatis_plus.entity;import lombok.Data;/*** @author * @description TODO* @date 2023-04-01*/
@Data
public class TreeNode {private String id;private String companyName;private String parentId;private Boolean isLeaf;public TreeNode(String id, String companyName, String parentId, Boolean isLeaf) {this.id = id;this.companyName = companyName;this.parentId = parentId;this.isLeaf = isLeaf;}
}

7.CompanyInfoController控制层

package com.example.mybatis_plus.controller;import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.mybatis_plus.common.Result;
import com.example.mybatis_plus.entity.CompanyInfo;
import com.example.mybatis_plus.entity.TreeNode;
import com.example.mybatis_plus.service.CompanyInfoService;
import com.example.mybatis_plus.utils.ParamUtils;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;import javax.servlet.http.HttpServletRequest;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;/*** <p>* * </p>** @author * @since 2023-04-01*/
@Api(value = "", tags = "")
@RestController
@RequestMapping("/companyInfo")
//@Slf4j
public class CompanyInfoController {@Autowiredprivate CompanyInfoService companyInfoService;@ApiOperation(value = "查询分页数据")@PostMapping(value = "/list")public Result list(@RequestBody(required = false) Map<String, Object> object) {Page<CompanyInfo> page = ParamUtils.toPage(CompanyInfo.class, object);CompanyInfo entity = ParamUtils.toEntity(CompanyInfo.class, object);QueryWrapper<CompanyInfo> qw = new QueryWrapper<>();if (null != entity) {qw.setEntity(entity);}// qw.orderByAsc("");page = companyInfoService.page(page, qw);return Result.success(page);}@ApiOperation(value = "根据id查询数据")@GetMapping(value = "/get")public Result get(String id) {if (null == id || id.equals("")) {return Result.fail("ID不能为空！");}CompanyInfo entity = companyInfoService.getById(id);return Result.success(entity);}/*** 输入 parentId** @param map* @return*/@ApiOperation(value = "获得指定父节点的子节点列表")@PostMapping(value = "/getChildNodes")public Result getChildNodes(@RequestBody Map<String, Object> map) {if (map.isEmpty()) {return Result.fail("输入格式错误");}String parentId = ParamUtils.toString(map, "parentId");
//        List<CompanyInfo> ngPowerTransformerInfoList = CompanyInfoService.getChildNodes(parentId);List<CompanyInfo> ngPowerTransformerInfoList = companyInfoService.getChildNodes(parentId);ArrayList<TreeNode> treeNodes = new ArrayList<>();for (CompanyInfo CompanyInfo : ngPowerTransformerInfoList) {String CompanyId = CompanyInfo.getId();String CompanyParentId = CompanyInfo.getParentId();String companyName = CompanyInfo.getCompanyName();boolean isLeaf = true;List<CompanyInfo> childNodes = companyInfoService.getChildNodes(CompanyId);if (childNodes.size() > 0) {isLeaf = false;}TreeNode treeNode = new TreeNode(CompanyId, companyName, CompanyParentId, isLeaf);treeNodes.add(treeNode);}return Result.success(treeNodes);}@ApiOperation(value = "新增/修改数据")@PostMapping(value = "/save")public Result save(HttpServletRequest request, @RequestBody CompanyInfo entity) {if (null == entity) {return Result.fail("对象不能为空！");}companyInfoService.saveOrUpdate(entity);return Result.success(entity);}@ApiOperation(value = "批量删除数据")@PostMapping(value = "/delete")public Result delete(HttpServletRequest request, @RequestBody List<String> idList) {if (null == idList || idList.isEmpty()) {return Result.fail("对象不能为空！");}companyInfoService.removeByIds(idList);return Result.success();}}

ps

String parentId = ParamUtils.toString(map, "parentId");
ParamUtils工具类有点多, 就不做展示了
就是将map里面的parentId取出来

8.结果演示

8.1请求父节点为0的数据, 只有集团总部, 并且还有子节点所以isLeaf为false

8.2请求父id为1的数据,广州分部没有子节点, isLeaf为true,深圳有子节点,isLeaf为false

8.3请求父id为3的数据, 同理