Js解析Json数据获取元素JsonPath与深度

2024-06-02 19:38
文章标签 数据 元素 深度 json js 解析 获取 jsonpath

本文主要是介绍Js解析Json数据获取元素JsonPath与深度，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

原文出处：http://www.yund.tech/zdetail.html?type=1&id=c2b21696839eccdef2e9b085b9e064f6

作者: jstarseven

JsonPath 是一种信息抽取类库，是从JSON文档中抽取指定信息的工具，提供多种语言实现版本，包括：Javascript, Python， PHP 和 Java，JsonPath 对于 JSON 来说，相当于 XPATH 对于 XML。

  • JsonPath与Xpath用法对比
  • Java使用Jsonpath解析json数据
  • Js获取Json每个节点的JsonPath
  • 将输出结果转换成树形结构

1.JsonPath与Xpath用法对比

XPathJSONPath描述
/$根节点
.@现行节点
/.or[]取子节点
…n/a取父节点，Jsonpath未支持
//…就是不管位置，选择所有符合条件的条件
**匹配所有元素节点
@n/a根据属性访问，Json不支持，因为Json是个Key-value递归结构，不需要。
[][]迭代器标示（可以在里边做简单的迭代操作，如数组下标，根据内容选值等）
|[,]支持迭代器中做多选。
[]?()支持过滤操作.
n/a()支持表达式计算
()n/a分组，JsonPath不支持

2.Java使用Jsonpath解析json数据

1）引入fastjson依赖

<dependency><groupId>com.alibaba</groupId><artifactId>fastjson</artifactId><version>1.2.6</version>
</dependency>

2）java简单的解析案例

public class JsonPath {public static void main(String[] args) {String jsonStr = "{\n" +"  \"store\": {\n" +"    \"book\": [\n" +"      {\n" +"        \"category\": \"reference\",\n" +"        \"author\": \"Nigel Rees\",\n" +"        \"title\": \"Sayings of the Century\",\n" +"        \"price\": 8.95\n" +"      },\n" +"      {\n" +"        \"category\": \"fiction\",\n" +"        \"author\": \"Evelyn Waugh\",\n" +"        \"title\": \"Sword of Honour\",\n" +"        \"price\": 12.99,\n" +"        \"isbn\": \"0-553-21311-3\"\n" +"      }\n" +"      {\n" +"        \"category\": \"fiction\",\n" +"        \"author\": \"Evelyn Waugh\",\n" +"        \"title\": \"Sword of Honour two\",\n" +"        \"price\": 12.99,\n" +"        \"isbn\": \"0-553-21311-3\"\n" +"      }\n" +"    ],\n" +"    \"bicycle\": {\n" +"      \"color\": \"red\",\n" +"      \"price\": 19.95\n" +"    }\n" +"  }\n" +"}";JSONObject jsonObject = JSON.parseObject(jsonStr);System.out.println("Book：" + JSONPath.eval(jsonObject, "$.store.book"));System.out.println("Book数目：" + JSONPath.eval(jsonObject, "$.store.book.size()"));System.out.println("第一本书title：" + JSONPath.eval(jsonObject, "$.store.book[0].title"));System.out.println("price大于10元的book：" + JSONPath.eval(jsonObject, "$.store.book[price > 10]"));System.out.println("price大于10元的title：" + JSONPath.eval(jsonObject, "$.store.book[price > 10][0].title"));System.out.println("price大于10元的title：" + JSONPath.eval(jsonObject, "$.store.book[price > 10][1].title"));System.out.println("category(类别)为fiction(小说)的book：" + JSONPath.eval(jsonObject, "$.store.book[category = 'fiction']"));System.out.println("bicycle的所有属性值" + JSONPath.eval(jsonObject, "$.store.bicycle.*"));System.out.println("bicycle的color和price属性值" + JSONPath.eval(jsonObject, "$.store.bicycle['color','price']"));}

3.Js获取Json每个节点的JsonPath

1）准备json测试数据

var root = {name: '测试节点',doms: {name: "dom测试",children: [{name: '茶馆',val: 'demo',child: [{"name": "李四", "cal": "ceshi"}, {"name": "王五", "cal": "ceshi"}]},{name: '红与黑',val: 'demo',child: [{"name": "张三", "cal": "ceshi"}, {"name": "张三", "cal": "ceshi"}]}]},children: [{name: '学习',children: []},{name: '电影',children: [{name: '喜剧电影'},{name: '动作电影'}]}]}

2）遍历Json对象获取每个节点的深度与JsonPath

     function traverseTree(node, flat) {var stack = [], res = [];if (!node) return;stack.push({"dom": node, "dep": 0, "path": "$", "name": "根节点"});var tmpNode;while (stack.length > 0) {tmpNode = stack.pop();res.push({"name": tmpNode.name,"pid": tmpNode.pid,"path": tmpNode.path,"dep": tmpNode.dep});traverseNode2(tmpNode, tmpNode.dep);}// 遍历单个节点function traverseNode2(node, dep) {var doc = node.dom;if (Object.prototype.toString.call(doc) === '[object Object]') {for (var val in doc) {var cpath = (node.path + "." + val);stack.push({"dom": doc[val],"dep": (dep + 1),"path": cpath,"pid": node.path,"name": val});}}if (Object.prototype.toString.call(doc) === '[object Array]') {for (let i = 0; i < doc.length; i++) {stack.push({"dom": doc[i],"dep": (dep + 1),"path": (node.path + "[" + i + "]"),"pid": node.path,"name": node.name + "[" + i + "]"});}}}// 树形结构转换function flat2tree(jsonData) {var result = [], temp = {}, i = 0, j = 0, len = jsonData.length;for (; i < len; i++)temp[jsonData[i]['path']] = jsonData[i]for (; j < len; j++) {var cel = jsonData[j]var tcel = temp[cel['pid']]if (tcel) {if (!tcel['children']) {tcel['children'] = [];}tcel['children'].push(cel)} else {result.push(cel);}}return result;}return flat ? flat2tree(res) : res;}

3）测试输出

console.log("res-tree:\n" + JSON.stringify(traverseTree(root, false)));
res-tree:
[{"name":"根节点","path":"$","dep":0},{"name":"children","pid":"$","path":"$.children","dep":1},{"name":"children[1]","pid":"$.children","path":"$.children[1]","dep":2},{"name":"children","pid":"$.children[1]","path":"$.children[1].children","dep":3},{"name":"children[1]","pid":"$.children[1].children","path":"$.children[1].children[1]","dep":4},{"name":"name","pid":"$.children[1].children[1]","path":"$.children[1].children[1].name","dep":5},{"name":"children[0]","pid":"$.children[1].children","path":"$.children[1].children[0]","dep":4},{"name":"name","pid":"$.children[1].children[0]","path":"$.children[1].children[0].name","dep":5},{"name":"name","pid":"$.children[1]","path":"$.children[1].name","dep":3},{"name":"children[0]","pid":"$.children","path":"$.children[0]","dep":2},{"name":"children","pid":"$.children[0]","path":"$.children[0].children","dep":3},{"name":"name","pid":"$.children[0]","path":"$.children[0].name","dep":3},{"name":"doms","pid":"$","path":"$.doms","dep":1},{"name":"children","pid":"$.doms","path":"$.doms.children","dep":2},{"name":"children[1]","pid":"$.doms.children","path":"$.doms.children[1]","dep":3},{"name":"child","pid":"$.doms.children[1]","path":"$.doms.children[1].child","dep":4},{"name":"child[1]","pid":"$.doms.children[1].child","path":"$.doms.children[1].child[1]","dep":5},{"name":"cal","pid":"$.doms.children[1].child[1]","path":"$.doms.children[1].child[1].cal","dep":6},{"name":"name","pid":"$.doms.children[1].child[1]","path":"$.doms.children[1].child[1].name","dep":6},{"name":"child[0]","pid":"$.doms.children[1].child","path":"$.doms.children[1].child[0]","dep":5},{"name":"cal","pid":"$.doms.children[1].child[0]","path":"$.doms.children[1].child[0].cal","dep":6},{"name":"name","pid":"$.doms.children[1].child[0]","path":"$.doms.children[1].child[0].name","dep":6},{"name":"val","pid":"$.doms.children[1]","path":"$.doms.children[1].val","dep":4},{"name":"name","pid":"$.doms.children[1]","path":"$.doms.children[1].name","dep":4},{"name":"children[0]","pid":"$.doms.children","path":"$.doms.children[0]","dep":3},{"name":"child","pid":"$.doms.children[0]","path":"$.doms.children[0].child","dep":4},{"name":"child[1]","pid":"$.doms.children[0].child","path":"$.doms.children[0].child[1]","dep":5},{"name":"cal","pid":"$.doms.children[0].child[1]","path":"$.doms.children[0].child[1].cal","dep":6},{"name":"name","pid":"$.doms.children[0].child[1]","path":"$.doms.children[0].child[1].name","dep":6},{"name":"child[0]","pid":"$.doms.children[0].child","path":"$.doms.children[0].child[0]","dep":5},{"name":"cal","pid":"$.doms.children[0].child[0]","path":"$.doms.children[0].child[0].cal","dep":6},{"name":"name","pid":"$.doms.children[0].child[0]","path":"$.doms.children[0].child[0].name","dep":6},{"name":"val","pid":"$.doms.children[0]","path":"$.doms.children[0].val","dep":4},{"name":"name","pid":"$.doms.children[0]","path":"$.doms.children[0].name","dep":4},{"name":"name","pid":"$.doms","path":"$.doms.name","dep":2},{"name":"name","pid":"$","path":"$.name","dep":1}
]

4.将输出结果转换成树形结构

console.log("res-tree:\n" + JSON.stringify(traverseTree(root, true)));
res-tree:
[{"name":"根节点","path":"$","dep":0,"children":[{"name":"children","pid":"$","path":"$.children","dep":1,"children":[{"name":"children[1]","pid":"$.children","path":"$.children[1]","dep":2,"children":[{"name":"children","pid":"$.children[1]","path":"$.children[1].children","dep":3,"children":[{"name":"children[1]","pid":"$.children[1].children","path":"$.children[1].children[1]","dep":4,"children":[{"name":"name","pid":"$.children[1].children[1]","path":"$.children[1].children[1].name","dep":5}]},{"name":"children[0]","pid":"$.children[1].children","path":"$.children[1].children[0]","dep":4,"children":[{"name":"name","pid":"$.children[1].children[0]","path":"$.children[1].children[0].name","dep":5}]}]},{"name":"name","pid":"$.children[1]","path":"$.children[1].name","dep":3}]},{"name":"children[0]","pid":"$.children","path":"$.children[0]","dep":2,"children":[{"name":"children","pid":"$.children[0]","path":"$.children[0].children","dep":3},{"name":"name","pid":"$.children[0]","path":"$.children[0].name","dep":3}]}]},{"name":"doms","pid":"$","path":"$.doms","dep":1,"children":[{"name":"children","pid":"$.doms","path":"$.doms.children","dep":2,"children":[{"name":"children[1]","pid":"$.doms.children","path":"$.doms.children[1]","dep":3,"children":[{"name":"child","pid":"$.doms.children[1]","path":"$.doms.children[1].child","dep":4,"children":[{"name":"child[1]","pid":"$.doms.children[1].child","path":"$.doms.children[1].child[1]","dep":5,"children":[{"name":"cal","pid":"$.doms.children[1].child[1]","path":"$.doms.children[1].child[1].cal","dep":6},{"name":"name","pid":"$.doms.children[1].child[1]","path":"$.doms.children[1].child[1].name","dep":6}]},{"name":"child[0]","pid":"$.doms.children[1].child","path":"$.doms.children[1].child[0]","dep":5,"children":[{"name":"cal","pid":"$.doms.children[1].child[0]","path":"$.doms.children[1].child[0].cal","dep":6},{"name":"name","pid":"$.doms.children[1].child[0]","path":"$.doms.children[1].child[0].name","dep":6}]}]},{"name":"val","pid":"$.doms.children[1]","path":"$.doms.children[1].val","dep":4},{"name":"name","pid":"$.doms.children[1]","path":"$.doms.children[1].name","dep":4}]},{"name":"children[0]","pid":"$.doms.children","path":"$.doms.children[0]","dep":3,"children":[{"name":"child","pid":"$.doms.children[0]","path":"$.doms.children[0].child","dep":4,"children":[{"name":"child[1]","pid":"$.doms.children[0].child","path":"$.doms.children[0].child[1]","dep":5,"children":[{"name":"cal","pid":"$.doms.children[0].child[1]","path":"$.doms.children[0].child[1].cal","dep":6},{"name":"name","pid":"$.doms.children[0].child[1]","path":"$.doms.children[0].child[1].name","dep":6}]},{"name":"child[0]","pid":"$.doms.children[0].child","path":"$.doms.children[0].child[0]","dep":5,"children":[{"name":"cal","pid":"$.doms.children[0].child[0]","path":"$.doms.children[0].child[0].cal","dep":6},{"name":"name","pid":"$.doms.children[0].child[0]","path":"$.doms.children[0].child[0].name","dep":6}]}]},{"name":"val","pid":"$.doms.children[0]","path":"$.doms.children[0].val","dep":4},{"name":"name","pid":"$.doms.children[0]","path":"$.doms.children[0].name","dep":4}]}]},{"name":"name","pid":"$.doms","path":"$.doms.name","dep":2}]},{"name":"name","pid":"$","path":"$.name","dep":1}]}
]

file

本文由博客群发一文多发等运营工具平台 OpenWrite 发布

这篇关于Js解析Json数据获取元素JsonPath与深度的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！


http://www.chinasem.cn/article/1024902。

相关文章

nginx -t、nginx -s stop 和 nginx -s reload 命令的详细解析(结合应用场景)

nginx -t、nginx -s stop 和 nginx -s reload 命令的详细解析(结合应用场景)

《nginx-t、nginx-sstop和nginx-sreload命令的详细解析(结合应用场景)》本文解析Nginx的-t、-sstop、-sreload命令,分别用于配置语法检... 以下是关于 nginx -t、nginx -s stop 和 nginx -s reload 命令的详细解析，结合实际应
阅读更多...
MyBatis中$与#的区别解析

MyBatis中$与#的区别解析

《MyBatis中$与#的区别解析》文章浏览阅读314次，点赞4次，收藏6次。MyBatis使用#{}作为参数占位符时，会创建预处理语句（PreparedStatement），并将参数值作为预处理语句... 目录一、介绍二、sql注入风险实例一、介绍#（井号）：MyBATis使用#{}作为参数占位符时，会
阅读更多...
SQL中如何添加数据(常见方法及示例)

SQL中如何添加数据(常见方法及示例)

《SQL中如何添加数据(常见方法及示例)》SQL全称为StructuredQueryLanguage,是一种用于管理关系数据库的标准编程语言,下面给大家介绍SQL中如何添加数据,感兴趣的朋友一起看看吧... 目录在mysql中，有多种方法可以添加数据。以下是一些常见的方法及其示例。1. 使用INSERT I
阅读更多...
Python使用vllm处理多模态数据的预处理技巧

Python使用vllm处理多模态数据的预处理技巧

《Python使用vllm处理多模态数据的预处理技巧》本文深入探讨了在Python环境下使用vLLM处理多模态数据的预处理技巧,我们将从基础概念出发,详细讲解文本、图像、音频等多模态数据的预处理方法,... 目录1. 背景介绍1.1 目的和范围1.2 预期读者1.3 文档结构概述1.4 术语表1.4.1 核
阅读更多...
Python使用OpenCV实现获取视频时长的小工具

Python使用OpenCV实现获取视频时长的小工具

《Python使用OpenCV实现获取视频时长的小工具》在处理视频数据时,获取视频的时长是一项常见且基础的需求,本文将详细介绍如何使用Python和OpenCV获取视频时长,并对每一行代码进行深入解析... 目录一、代码实现二、代码解析1. 导入 OpenCV 库2. 定义获取视频时长的函数3. 打开视频文
阅读更多...
PostgreSQL的扩展dict_int应用案例解析

PostgreSQL的扩展dict_int应用案例解析

《PostgreSQL的扩展dict_int应用案例解析》dict_int扩展为PostgreSQL提供了专业的整数文本处理能力,特别适合需要精确处理数字内容的搜索场景,本文给大家介绍PostgreS... 目录PostgreSQL的扩展dict_int一、扩展概述二、核心功能三、安装与启用四、字典配置方法
阅读更多...
MySQL 删除数据详解(最新整理)

MySQL 删除数据详解(最新整理)

《MySQL删除数据详解(最新整理)》：本文主要介绍MySQL删除数据的相关知识,本文通过实例代码给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友参考下吧... 目录一、前言二、mysql 中的三种删除方式1.DELETE语句✅ 基本语法： 示例：2.TRUNCATE语句✅ 基本语
阅读更多...
C# 比较两个list 之间元素差异的常用方法

C# 比较两个list 之间元素差异的常用方法

《C#比较两个list之间元素差异的常用方法》：本文主要介绍C#比较两个list之间元素差异,本文通过实例代码给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友参考下吧... 目录1. 使用Except方法2. 使用Except的逆操作3. 使用LINQ的Join,GroupJoin
阅读更多...
MySQL查询JSON数组字段包含特定字符串的方法

MySQL查询JSON数组字段包含特定字符串的方法

《MySQL查询JSON数组字段包含特定字符串的方法》在MySQL数据库中,当某个字段存储的是JSON数组,需要查询数组中包含特定字符串的记录时传统的LIKE语句无法直接使用,下面小编就为大家介绍两种... 目录问题背景解决方案对比1. 精确匹配方案（推荐）2. 模糊匹配方案参数化查询示例使用场景建议性能优
阅读更多...
深度解析Java DTO(最新推荐)

深度解析Java DTO(最新推荐)

《深度解析JavaDTO(最新推荐)》DTO（DataTransferObject）是一种用于在不同层（如Controller层、Service层）之间传输数据的对象设计模式,其核心目的是封装数据,... 目录一、什么是DTO？DTO的核心特点：二、为什么需要DTO？（对比Entity）三、实际应用场景解析
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2