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

2024-06-02 19:38

本文主要是介绍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

相关文章

Oracle数据库常见字段类型大全以及超详细解析

《Oracle数据库常见字段类型大全以及超详细解析》在Oracle数据库中查询特定表的字段个数通常需要使用SQL语句来完成,:本文主要介绍Oracle数据库常见字段类型大全以及超详细解析,文中通过... 目录前言一、字符类型(Character)1、CHAR:定长字符数据类型2、VARCHAR2:变长字符数

Python获取中国节假日数据记录入JSON文件

《Python获取中国节假日数据记录入JSON文件》项目系统内置的日历应用为了提升用户体验,特别设置了在调休日期显示“休”的UI图标功能,那么问题是这些调休数据从哪里来呢?我尝试一种更为智能的方法:P... 目录节假日数据获取存入jsON文件节假日数据读取封装完整代码项目系统内置的日历应用为了提升用户体验,

微信公众号脚本-获取热搜自动新建草稿并发布文章

《微信公众号脚本-获取热搜自动新建草稿并发布文章》本来想写一个自动化发布微信公众号的小绿书的脚本,但是微信公众号官网没有小绿书的接口,那就写一个获取热搜微信普通文章的脚本吧,:本文主要介绍微信公众... 目录介绍思路前期准备环境要求获取接口token获取热搜获取热搜数据下载热搜图片给图片加上标题文字上传图片

使用Jackson进行JSON生成与解析的新手指南

《使用Jackson进行JSON生成与解析的新手指南》这篇文章主要为大家详细介绍了如何使用Jackson进行JSON生成与解析处理,文中的示例代码讲解详细,感兴趣的小伙伴可以跟随小编一起学习一下... 目录1. 核心依赖2. 基础用法2.1 对象转 jsON(序列化)2.2 JSON 转对象(反序列化)3.

Springboot @Autowired和@Resource的区别解析

《Springboot@Autowired和@Resource的区别解析》@Resource是JDK提供的注解,只是Spring在实现上提供了这个注解的功能支持,本文给大家介绍Springboot@... 目录【一】定义【1】@Autowired【2】@Resource【二】区别【1】包含的属性不同【2】@

用js控制视频播放进度基本示例代码

《用js控制视频播放进度基本示例代码》写前端的时候,很多的时候是需要支持要网页视频播放的功能,下面这篇文章主要给大家介绍了关于用js控制视频播放进度的相关资料,文中通过代码介绍的非常详细,需要的朋友可... 目录前言html部分:JavaScript部分:注意:总结前言在javascript中控制视频播放

SpringCloud动态配置注解@RefreshScope与@Component的深度解析

《SpringCloud动态配置注解@RefreshScope与@Component的深度解析》在现代微服务架构中,动态配置管理是一个关键需求,本文将为大家介绍SpringCloud中相关的注解@Re... 目录引言1. @RefreshScope 的作用与原理1.1 什么是 @RefreshScope1.

Java并发编程必备之Synchronized关键字深入解析

《Java并发编程必备之Synchronized关键字深入解析》本文我们深入探索了Java中的Synchronized关键字,包括其互斥性和可重入性的特性,文章详细介绍了Synchronized的三种... 目录一、前言二、Synchronized关键字2.1 Synchronized的特性1. 互斥2.

JSON Web Token在登陆中的使用过程

《JSONWebToken在登陆中的使用过程》:本文主要介绍JSONWebToken在登陆中的使用过程,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录JWT 介绍微服务架构中的 JWT 使用结合微服务网关的 JWT 验证1. 用户登录,生成 JWT2. 自定义过滤

Java利用JSONPath操作JSON数据的技术指南

《Java利用JSONPath操作JSON数据的技术指南》JSONPath是一种强大的工具,用于查询和操作JSON数据,类似于SQL的语法,它为处理复杂的JSON数据结构提供了简单且高效... 目录1、简述2、什么是 jsONPath?3、Java 示例3.1 基本查询3.2 过滤查询3.3 递归搜索3.4