MyBatis 利用SQL 的UUID 实现多表关联的树结构

最新推荐文章于 2022-09-22 18:02:13 发布
最新推荐文章于 2022-09-22 18:02:13 发布
阅读量331 收藏
点赞数
分类专栏： Spring boot 文章标签： mybatis springBoot
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44690195/article/details/115764548
版权

需求

在VUE +Element 实现树结构时遇到一个问题，要求子节点有一个唯一标识 （据我所知LayUI 不存在这个问题）

很显然不能用各外键的ID作为唯一标识（当时想了一个办法就是把各节点的ID * 几个不同的值，但仍然有可能重复，所以现在看很可笑）；

解决文案

使用MySQL 的UUID（） 方法实现

SQL

<sql id="TestSQL">
        UUID() as UUID,
        s_type.id,
        s_type.name,
        s_type.type_code,
        s_type.type_name,
        "project" as type,
        UUID() as proUUID,
        npi_project_class.id as cid,
        npi_project_class.stage,

        npi_project_class_task.id as tid,
        npi_project_class_task.logic_relation as logicRelation,
        "logic" as logicType,
        UUID() as logicUUID,

        npi_project_class_task.npi_task_warehouse_id as npiTaskWarehouseId,
        npi_project_class_task.pid as pid,
        "stage" as stageType,
        npi_task_warehouse.id as wid,
        "task" as taskType,
        UUID() as taskUUID,
        npi_task_warehouse.code as wcode,
        npi_task_warehouse.name as wname,
        npi_task_warehouse.file_input as fileInput,
        npi_task_warehouse.category,
        npi_task_warehouse.responsible_role_id as responsibleRoleId,
        npi_task_warehouse.responsible_dept_id as responsibleDeptId,
        npi_task_warehouse.task_description
    </sql>

具体mapper

<resultMap type="com.npi.model.tempo.StypeList" id="ProjectClass">
        <id property="id" column="id"/>
        <result property="UUID" column="UUID"/>
        <result property="shortCode" column="shortCode"/>
        <result property="code" column="code"/>
        <result property="name" column="name"/>
        <result property="remark" column="remark"/>
        <result property="typeCode" column="typeCode"/>
        <result property="typeName" column="typeName"/>
        <result property="isDeleted" column="isDeleted"/>
        <result property="type" column="type"/>
        <collection property="children" javaType="ArrayList" ofType="com.npi.model.tempo.NpiProjectClassStage">
            <id property="id" column="cid"/>
            <result property="UUID" column="proUUID"/>
            <result property="stage" column="stage"/>
            <result property="type" column="stageType"/>
            <collection property="children" javaType="ArrayList" ofType="com.npi.model.tempo.NpiProjectClassLogic">
                <id property="id" column="pid"/>
                <result property="UUID" column="logicUUID"/>
                <result property="logicRelation" column="logicRelation"/>
                <result property="type" column="logicType"/>
                <collection property="children" javaType="ArrayList" ofType="com.npi.model.tempo.NpiTaskWarehouseDtm">
                    <id property="id" column="wid"/>
                    <result property="UUID" column="taskUUID"/>
                    <result property="type" column="taskType"/>
                    <result property="code" column="wcode"/>
                    <result property="name" column="wname"/>
                    <result property="fileInput" column="fileInput"/>
                    <result property="category" column="category"/>
                    <result property="responsibleRoleId" column="responsibleRoleId"/>
                    <result property="responsibleDeptId" column="responsibleDeptId"/>
                </collection>
            </collection>
        </collection>
    </resultMap>

建对应的临时类并声明UUID成员

private String UUID;

效果

{
  "code": 200,
  "data": [
    {
      "children": [
        {
          "children": [
            {
              "children": [
                {
                  "category": 0,
                  "code": "G1.1",
                  "fileInput": "2D/3D",
                  "id": 1,
                  "isDeleted": 0,
                  "name": "客户图纸接收",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d906e-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G1.2",
                  "fileInput": "模具规格说明书 ",
                  "id": 2,
                  "isDeleted": 0,
                  "name": "模具规格沟通",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9237-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G1.3",
                  "fileInput": "产品需求说明",
                  "id": 3,
                  "isDeleted": 0,
                  "name": "产品需求沟通",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9295-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G1.4",
                  "fileInput": "VOC",
                  "id": 5,
                  "isDeleted": 0,
                  "name": "量产预测/样品预测/时间沟通",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d92e7-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 1,
              "logicRelation": 1,
              "type": "logic",
              "uUID": "3e7d906b-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G1.5",
                  "fileInput": "BFMEA",
                  "id": 6,
                  "isDeleted": 0,
                  "name": "商务失效模式和风险评估",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9338-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G1.6",
                  "fileInput": "项目简介",
                  "id": 7,
                  "isDeleted": 0,
                  "name": "项目简介",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9385-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 2,
              "logicRelation": 2,
              "type": "logic",
              "uUID": "3e7d9335-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G1.7",
                  "fileInput": "转阶段评审表签核",
                  "id": 8,
                  "isDeleted": 0,
                  "name": "阶段评审",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d93cc-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 3,
              "logicRelation": 3,
              "type": "logic",
              "uUID": "3e7d93c9-9e66-11eb-9d28-005056a43b52"
            }
          ],
          "id": 24,
          "stage": 1,
          "type": "stage",
          "uUID": "3e7d9067-9e66-11eb-9d28-005056a43b52"
        },
        {
          "children": [
            {
              "children": [
                {
                  "category": 0,
                  "code": "G2.1",
                  "fileInput": "项目组员清单",
                  "id": 9,
                  "isDeleted": 0,
                  "name": "项目组成立",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9427-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G2.2",
                  "fileInput": "项目时间计划",
                  "id": 10,
                  "isDeleted": 0,
                  "name": "项目启动会议",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d946c-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G2.3",
                  "fileInput": "工艺流程图",
                  "id": 11,
                  "isDeleted": 0,
                  "name": "初版工艺流程",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d94b6-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G2.4",
                  "fileInput": "特殊特性清单",
                  "id": 12,
                  "isDeleted": 0,
                  "name": "初版特殊特性清单",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质责任人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d950d-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 4,
              "logicRelation": 1,
              "type": "logic",
              "uUID": "3e7d9424-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G2.5",
                  "fileInput": "可行性报告",
                  "id": 13,
                  "isDeleted": 0,
                  "name": "可行性评估",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9553-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 5,
              "logicRelation": 2,
              "type": "logic",
              "uUID": "3e7d9550-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G2.6",
                  "fileInput": "模具CBD",
                  "id": 14,
                  "isDeleted": 0,
                  "name": "模具成本核算",
                  "responsibleDeptId": "模具部",
                  "responsibleRoleId": "模具负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9598-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G2.7",
                  "fileInput": "注塑CBD",
                  "id": 15,
                  "isDeleted": 0,
                  "name": "注塑成本核算",
                  "responsibleDeptId": "注塑部",
                  "responsibleRoleId": "注塑负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d95e1-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G2.8",
                  "fileInput": "自动化CBD",
                  "id": 16,
                  "isDeleted": 0,
                  "name": "自动化成本核算",
                  "responsibleDeptId": "自动化",
                  "responsibleRoleId": "自动化负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d974a-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G2.9",
                  "fileInput": "检治具CBD",
                  "id": 17,
                  "isDeleted": 0,
                  "name": "检治具成本核算",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质责任人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d97a0-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 6,
              "logicRelation": 3,
              "type": "logic",
              "uUID": "3e7d9595-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G2.10",
                  "fileInput": "项目预算",
                  "id": 18,
                  "isDeleted": 0,
                  "name": "项目预算",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d97ec-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 7,
              "logicRelation": 4,
              "type": "logic",
              "uUID": "3e7d97e9-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G2.11",
                  "fileInput": "报价单",
                  "id": 19,
                  "isDeleted": 0,
                  "name": "报价",
                  "responsibleDeptId": "市场部",
                  "responsibleRoleId": "市场负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9836-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 8,
              "logicRelation": 5,
              "type": "logic",
              "uUID": "3e7d9833-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G2.12",
                  "fileInput": "客户定点函",
                  "id": 20,
                  "isDeleted": 0,
                  "name": "客户定点",
                  "responsibleDeptId": "市场部",
                  "responsibleRoleId": "市场负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d987c-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 9,
              "logicRelation": 6,
              "type": "logic",
              "uUID": "3e7d9879-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G2.13",
                  "fileInput": "转阶段评审表签核",
                  "id": 21,
                  "isDeleted": 0,
                  "name": "阶段评审",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d98c2-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 10,
              "logicRelation": 7,
              "type": "logic",
              "uUID": "3e7d98bf-9e66-11eb-9d28-005056a43b52"
            }
          ],
          "id": 25,
          "stage": 2,
          "type": "stage",
          "uUID": "3e7d9421-9e66-11eb-9d28-005056a43b52"
        },
        {
          "children": [
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.1",
                  "fileInput": "模流分析",
                  "id": 22,
                  "isDeleted": 0,
                  "name": "模流分析",
                  "responsibleDeptId": "模具部",
                  "responsibleRoleId": "模具负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9924-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 1,
                  "code": "G3.5",
                  "fileInput": "检治具计划",
                  "id": 26,
                  "isDeleted": 0,
                  "name": "检治具设计",
                  "responsibleDeptId": "资材部",
                  "responsibleRoleId": "采购负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9969-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G3.9",
                  "fileInput": "自动化设备计划",
                  "id": 30,
                  "isDeleted": 0,
                  "name": "自动化设备设计",
                  "responsibleDeptId": "资材部",
                  "responsibleRoleId": "采购负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d99af-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G3.11",
                  "fileInput": "包装方案",
                  "id": 32,
                  "isDeleted": 0,
                  "name": "包装细部设计",
                  "responsibleDeptId": "注塑部",
                  "responsibleRoleId": "注塑负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d99f9-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 1,
                  "code": "G3.13",
                  "fileInput": "科学试模报告（T0）成型条件表\r\nTIL",
                  "id": 34,
                  "isDeleted": 0,
                  "name": "试模（T0/1/X）",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9a41-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G3.16",
                  "fileInput": "PFMEA",
                  "id": 37,
                  "isDeleted": 0,
                  "name": "初版PFMEA",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9a88-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 11,
              "logicRelation": 1,
              "type": "logic",
              "uUID": "3e7d9921-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.2",
                  "fileInput": "DFM",
                  "id": 23,
                  "isDeleted": 0,
                  "name": "DFM",
                  "responsibleDeptId": "模具部",
                  "responsibleRoleId": "模具负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9ace-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 12,
              "logicRelation": 2,
              "type": "logic",
              "uUID": "3e7d9acb-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 1,
                  "code": "G3.3",
                  "fileInput": "模具设计评审表",
                  "id": 24,
                  "isDeleted": 0,
                  "name": "模具细部设计",
                  "responsibleDeptId": "模具部",
                  "responsibleRoleId": "模具负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9b12-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 13,
              "logicRelation": 3,
              "type": "logic",
              "uUID": "3e7d9b10-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 1,
                  "code": "G3.4",
                  "fileInput": "Tooling Schedule",
                  "id": 25,
                  "isDeleted": 0,
                  "name": "模具制作",
                  "responsibleDeptId": "模具部",
                  "responsibleRoleId": "模具负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9b58-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 14,
              "logicRelation": 4,
              "type": "logic",
              "uUID": "3e7d9b55-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.6",
                  "fileInput": "检治具验收报告",
                  "id": 27,
                  "isDeleted": 0,
                  "name": "检治具制作",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9ba5-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G3.7",
                  "fileInput": "MSOP",
                  "id": 28,
                  "isDeleted": 0,
                  "name": "测量作业指导书编制",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9bea-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 15,
              "logicRelation": 5,
              "type": "logic",
              "uUID": "3e7d9ba3-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.8",
                  "fileInput": "MSA",
                  "id": 29,
                  "isDeleted": 0,
                  "name": "MSA",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9c2e-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 16,
              "logicRelation": 6,
              "type": "logic",
              "uUID": "3e7d9c2b-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.10",
                  "fileInput": "自动化设备验收报告",
                  "id": 31,
                  "isDeleted": 0,
                  "name": "自动化设备制作",
                  "responsibleDeptId": "自动化",
                  "responsibleRoleId": "自动化负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9c74-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 17,
              "logicRelation": 7,
              "type": "logic",
              "uUID": "3e7d9c72-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.12",
                  "fileInput": "E-BOM",
                  "id": 33,
                  "isDeleted": 0,
                  "name": "初始BOM",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9cbb-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 18,
              "logicRelation": 8,
              "type": "logic",
              "uUID": "3e7d9cb8-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 1,
                  "code": "G3.14",
                  "fileInput": "科学试模报告（T0）成型条件表\r\nTIL",
                  "id": 35,
                  "isDeleted": 0,
                  "name": "试模（T0/1/X）",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9d00-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 19,
              "logicRelation": 9,
              "type": "logic",
              "uUID": "3e7d9cfd-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.15",
                  "fileInput": "试模样品",
                  "id": 36,
                  "isDeleted": 0,
                  "name": "试模样品递交客户",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9d46-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 20,
              "logicRelation": 10,
              "type": "logic",
              "uUID": "3e7d9d44-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.17",
                  "fileInput": "CP",
                  "id": 38,
                  "isDeleted": 0,
                  "name": "初版CP",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9d94-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 21,
              "logicRelation": 11,
              "type": "logic",
              "uUID": "3e7d9d92-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.18",
                  "fileInput": "SIP",
                  "id": 39,
                  "isDeleted": 0,
                  "name": "初版SIP",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9dda-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 22,
              "logicRelation": 12,
              "type": "logic",
              "uUID": "3e7d9dd8-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.19",
                  "fileInput": "SOP",
                  "id": 40,
                  "isDeleted": 0,
                  "name": "初版SOP",
                  "responsibleDeptId": "注塑部",
                  "responsibleRoleId": "注塑负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9e1e-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 23,
              "logicRelation": 13,
              "type": "logic",
              "uUID": "3e7d9e1b-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.20",
                  "fileInput": "Tooling issue list close",
                  "id": 41,
                  "isDeleted": 0,
                  "name": "试模问题解决",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9e64-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 24,
              "logicRelation": 14,
              "type": "logic",
              "uUID": "3e7d9e62-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.21",
                  "fileInput": "FAI Report",
                  "id": 42,
                  "isDeleted": 0,
                  "name": "FAI Pass",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9eab-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 25,
              "logicRelation": 15,
              "type": "logic",
              "uUID": "3e7d9ea9-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G3.22",
                  "fileInput": "转阶段评审表签核",
                  "id": 43,
                  "isDeleted": 0,
                  "name": "阶段评审",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9ef3-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 26,
              "logicRelation": 16,
              "type": "logic",
              "uUID": "3e7d9ef0-9e66-11eb-9d28-005056a43b52"
            }
          ],
          "id": 26,
          "stage": 3,
          "type": "stage",
          "uUID": "3e7d991e-9e66-11eb-9d28-005056a43b52"
        },
        {
          "children": [
            {
              "children": [
                {
                  "category": 0,
                  "code": "G4.1",
                  "fileInput": "PFMEA（冻结）",
                  "id": 4,
                  "isDeleted": 0,
                  "name": "PFMEA（冻结）",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9f41-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G4.2",
                  "fileInput": "CP（冻结）",
                  "id": 44,
                  "isDeleted": 0,
                  "name": "CP（冻结）",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9f99-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G4.3",
                  "fileInput": "SIP（冻结）",
                  "id": 45,
                  "isDeleted": 0,
                  "name": "SIP（冻结）",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7d9fde-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G4.4",
                  "fileInput": "SOP（冻结）",
                  "id": 46,
                  "isDeleted": 0,
                  "name": "SOP（冻结）",
                  "responsibleDeptId": "注塑部",
                  "responsibleRoleId": "注塑负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da027-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G4.12",
                  "fileInput": "客户订单",
                  "id": 54,
                  "isDeleted": 0,
                  "name": "客户订单预测确认",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da06c-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 27,
              "logicRelation": 1,
              "type": "logic",
              "uUID": "3e7d9f3e-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G4.5",
                  "fileInput": "节拍生产报告",
                  "id": 47,
                  "isDeleted": 0,
                  "name": "节拍生产",
                  "responsibleDeptId": "注塑部",
                  "responsibleRoleId": "注塑负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da0b1-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 28,
              "logicRelation": 2,
              "type": "logic",
              "uUID": "3e7da0ae-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G4.6",
                  "fileInput": "CPK",
                  "id": 48,
                  "isDeleted": 0,
                  "name": "CPK",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da0f5-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G4.7",
                  "fileInput": "样品递送清单",
                  "id": 49,
                  "isDeleted": 0,
                  "name": "工程样品提交客户",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da13d-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 29,
              "logicRelation": 3,
              "type": "logic",
              "uUID": "3e7da0f2-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G4.8",
                  "fileInput": "限度样品清单",
                  "id": 50,
                  "isDeleted": 0,
                  "name": "限度样品",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da181-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 30,
              "logicRelation": 3,
              "type": "logic",
              "uUID": "3e7da17f-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G4.9",
                  "fileInput": "外观批准报告",
                  "id": 51,
                  "isDeleted": 0,
                  "name": "外观批准",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da1c6-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 31,
              "logicRelation": 4,
              "type": "logic",
              "uUID": "3e7da1c3-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G4.10",
                  "fileInput": "PPAP样品、PPAP",
                  "id": 52,
                  "isDeleted": 0,
                  "name": "PPAP",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da20a-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 32,
              "logicRelation": 5,
              "type": "logic",
              "uUID": "3e7da208-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G4.11",
                  "fileInput": "客户签核PSW",
                  "id": 53,
                  "isDeleted": 0,
                  "name": "PSW签核",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da250-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 33,
              "logicRelation": 6,
              "type": "logic",
              "uUID": "3e7da24d-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G4.13",
                  "fileInput": "物料采购单",
                  "id": 55,
                  "isDeleted": 0,
                  "name": "量产物料准备",
                  "responsibleDeptId": "1",
                  "responsibleRoleId": "采购负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da296-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 34,
              "logicRelation": 7,
              "type": "logic",
              "uUID": "3e7da293-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G4.14",
                  "fileInput": "LRC report",
                  "id": 56,
                  "isDeleted": 0,
                  "name": "量产准备评估",
                  "responsibleDeptId": "品质部",
                  "responsibleRoleId": "品质负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da2dc-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 35,
              "logicRelation": 8,
              "type": "logic",
              "uUID": "3e7da2d9-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G4.15",
                  "fileInput": "Safe launch报告",
                  "id": 57,
                  "isDeleted": 0,
                  "name": "Safe launch",
                  "responsibleDeptId": "注塑部",
                  "responsibleRoleId": "注塑负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da321-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 36,
              "logicRelation": 9,
              "type": "logic",
              "uUID": "3e7da31e-9e66-11eb-9d28-005056a43b52"
            },
            {
              "children": [
                {
                  "category": 0,
                  "code": "G4.16",
                  "fileInput": "转阶段评审表签核",
                  "id": 58,
                  "isDeleted": 0,
                  "name": "阶段评审",
                  "responsibleDeptId": "NPI",
                  "responsibleRoleId": "NPI负责人",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da369-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 37,
              "logicRelation": 10,
              "type": "logic",
              "uUID": "3e7da366-9e66-11eb-9d28-005056a43b52"
            }
          ],
          "id": 27,
          "stage": 4,
          "type": "stage",
          "uUID": "3e7d9f3b-9e66-11eb-9d28-005056a43b52"
        },
        {
          "children": [
            {
              "children": [
                {
                  "category": 0,
                  "code": "G5.1",
                  "fileInput": "项目总结报告",
                  "id": 59,
                  "isDeleted": 0,
                  "name": "项目总结",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da3b2-9e66-11eb-9d28-005056a43b52"
                },
                {
                  "category": 0,
                  "code": "G5.2",
                  "fileInput": "顾客满意度调查表",
                  "id": 60,
                  "isDeleted": 0,
                  "name": "顾客满意度调查",
                  "responsibleDeptId": "项目部",
                  "responsibleRoleId": "项目主管",
                  "sortNum": 0,
                  "type": "task",
                  "uUID": "3e7da3f5-9e66-11eb-9d28-005056a43b52"
                }
              ],
              "id": 38,
              "logicRelation": 1,
              "type": "logic",
              "uUID": "3e7da3af-9e66-11eb-9d28-005056a43b52"
            }
          ],
          "id": 28,
          "stage": 5,
          "type": "stage",
          "uUID": "3e7da3ac-9e66-11eb-9d28-005056a43b52"
        }
      ],
      "id": 61,
      "isDeleted": 0,
      "name": "汽车件",
      "type": "project",
      "uUID": "3e7d9058-9e66-11eb-9d28-005056a43b52"
    }
  ],
  "msg": "操作成功"
}

总结

其实网上也有人说这样不合理，会使用SQL性能降低；但对于一般需求能满足就可以了；个人理解 先满足需求，再去做优化；这好比骑驴找马。

众纳
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
mysql多表树形结构递归实现_在ORACLE、MSSQL、MYSQL中树结构表递归查询的实现方法...
weixin_42119989的博客
02-08 226
表recursion数据如下:id name parentid1 食品分类 -12 肉类 13 蔬菜类 14 产品分类 -15 保健品 46 医药 47 建筑 4...
Mybatis(plus)多对多联表查询返回树形数据(json格式)
KaridaRaiser的博客
05-27 905
Mybatis(plus) package com.xxh.mybatisplustest.pojo; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import lombok.EqualsAndHashCode; import java.io.Serializable; import java.util.Date; import java.util.List; /** * <p> *
MyBatis多表关联查询
ronybo的博客
04-11 289
根据<font colr="red">用户id</font>获取用户拥有的所有角色，，返回的结果为角色集合，结果只有角色的信息，不包含额外的其他字段信息。
mysql多表树形结构递归实现_Mysql 树形结构表递归父级节点函数方法
weixin_42502040的博客
01-19 260
地区表通过当前节点编号查询父级所有编号集合，通过逗号进行分隔(倒序，包含自身编号)-- 通过当前节点编号查询父级所有编号集合，通过逗号进行分隔(倒序，包含自身编号)-- DROP FUNCTION `getDistrictParentIds`;CREATE FUNCTION `getDistrictParentIds`(nodeId varchar(100))RETURNS varchar(100...
SQL-将具有上下级关系的表，转换成树形图，并标识各节点的类型(根节点、分支节点、叶子节点)
熊博主
04-04 895
需求：将具有上下级关系的表，转换为树形图，并标识各节点的类型（根节点、分支节点、叶子节点） 分析与解答： 根据伪列level和connect_by_isleaf的值进行判断即可 select level, (lpad(' ',(level-1)*2,' ')||empno) 树形图, --根据层级左填充空格，以展示树形 empno, ename, connect_by_isleaf 是否有,...
spring boot整合mybatis利用Mysql实现主键UUID的方法
08-27
主要给大家介绍了关于spring boot整合mybatis利用Mysql实现主键UUID的相关资料，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧。
Spring boot2基于Mybatis实现多表关联查询
08-19
主要介绍了Spring boot2基于Mybatis实现多表关联查询,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
Mybatis多表关联查询的实现(DEMO)
08-31
本节要实现的是多表关联查询的简单demo。场景是根据id查询某商品分类信息，并展示该分类下的商品列表,需要的朋友可以参考下
使用MyBatis实现表的多对多关联映射查询
12-05
使用MyBatis实现多对多关联映射查询的web，在eclipse上写的，使用的Mysql进行数据连接，内含数据库脚本，直接导入数据库即可建数据库和建表，不用再编写，非常方便，适合初学者了解和学习
Mybatis基于注解实现多表查询功能
08-25
主要介绍了Mybatis基于注解实现多表查询功能，非常不错，具有一定的参考借鉴价值,需要的朋友可以参考下
SQL级联表树形（三）
Q_MingTao
05-05 459
作者：邱名涛 撰写时间：2020 年05 月05日 需求： 1，树形选择，改为多选状态，查询表格 2，树形父节点要计算有几个楼层子节点，子节点里面对应宿舍，宿舍对应着床位。（X层-y间-z床 – 已入 a 人） 使用的是layui前端框架：https://www.layui.com/demo/laydate.html 树形zTree_v3使用文档： http://www.treejs.cn/v...
关联表联合成适合tree树形数据表
sjyzch的博客
08-11 266
多张关联表，均以id为关联，要返回前台能 处理的tree数据，看了网上的，很多是采用一对多查询方式，比较麻烦，后台返给前台一般是id name pid 格式，突然想到，是不是可以将关联表进行联合就行了，实验了下，确实，如此。有多少张表都可以，无非就是传参而已。...
mybatis自关联查询树
gaston的博客
06-28 1259
mapper.java：public List&lt;DepartmentDTO&gt; getTreeForm();mapper.xml：/*step1*/ /*step4*/...&lt;select id="getTreeForm" resultType="brilliance.znjt.business.postman.entity.DepartmentDTO"              ...
使用Mybatis实现简单树形结构数据接口渲染
qq_48157004的博客
09-22 2103
1.执行SQL select id, pid, cityname, type, content from tb_test where pid = #{pid}3. collection 又执行selectTbTestList。4.又进入了此查询下面的市进行了递归。2. resultMap进行了封装。默认查询pid为0的中国数据。
MyBatis树形结构查询
热门推荐
风树种子的专栏
11-24 2万+
前言　　对于树形结构的数据库设计通常是基于继承关系设计的，也就是通过父ID关联来实现的，还有就是基于左右值编码设计。本文以继承关系设计的树形结构来讨论下MyBatis树形结构查询。以深度为二的树为例，要将这种结构的数据查询出来，通常的做法是先查询一级数据，再查询二级数据，然后在程序里组装起来，想了下，其实还可以更简单，不用分开两次，就能将不同级别数据一次性查询映射出来。 　　 1.数据准备以区域表
Mybatis通过colliection属性递归获取菜单树
u010074988的博客
12-04 190
1、现有商品分类数据表category结构如下，三个字段都为varchar类型 2、创建商品分类对应的数据Bean /** * */ package com.xdw.dao; import java.util.List; import com.xdw.model.Category; /** * @author xiadewang *2018年4月16日 */ public interface CategoryDao { List<Category> ge
mybatis分级点击展示树结构
如漩涡的博客
04-02 991
    在WEB项目中，一二三级树形数据是很常见的事情，各种PID关系多个表等等，可以在每个XML中写个SQL，根据PID查询出数据，在Java代码中循环构造树，可以参考我之前的文章，但那都是数据量小的情况，表中加个索引，就非常快了。    那一旦数据量大起来怎么办？比如十万表数据，用循环构造树的话，那得循环多少遍，产生多少内存多少对象，访问多少次数据库，而且前端展示效果极差，数据太大循环多次查询...
SQL语句 - 嵌套查询
ajwqb06628的专栏
06-03 2883
SQL语句 - 嵌套查询 　　 嵌套查询的意思是，一个查询语句(select-from-where)查询语句块可以嵌套在另外一个查询块的where子句中，称为嵌套查询。其中外层查询也称为父查询，主查询。内层查询也称子查询，从查询。 　　嵌套查询的工作方式是：先处...
多表一个XML即可构建树
如漩涡的博客
01-31 328
上一回写过一次构建树的方法，我提到过代码复用性太高了，因为六张表，差不多的SQL语句，重复调用，代码也不好看，而且new了很多个TreeNode对象，臃肿，后来想到了在Mybatis XML映射中做修改，将表名和字段名都让自己来赋值，试了试，没想到这样的操作还真的有。 XML： id="findTree" resultType="com.uhope.uip.item.core.TreeNo
mybatis多表关联查询sql
最新发布
08-25
总的来说，Mybatis提供了多种方法来实现多表关联查询的需求。<span class="em">1</span><span class="em">2</span><span class="em">3 #### 引用[.reference_title] - *1* *2* *3* [Mybatis多表联查的几种办法]...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值