经典JsonPath表达式

南飞的雁123

已于 2022-09-02 13:16:51 修改

阅读量496

点赞数

CC 4.0 BY-SA版权

文章标签： json JsonPath

于 2022-09-01 21:00:32 首次发布

本文链接：https://blog.youkuaiyun.com/shaokai132333/article/details/126651201

本文讲解如何使用JsonPath表达式从给定的JSON数据中过滤出22点至凌晨1点之间的书籍销售记录，包括示例和测试结果分析。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、按照时间过滤，过滤晚22点至01点之间的数据

Jayway JsonPath evaluator

测试数据：

示例1：

{
  "store": {
    "book": [
      {
        "category": "fiction",
        "time": "2022-10-01 21:10:01",
        "title": "Sword of Honour",
        "price": 12.99
      },
      {
        "category": "fiction",
        "time": "2022-10-01 22:10:01",
        "title": "Sword of Honour",
        "price": 12.99
      },
      {
        "category": "fiction",
        "time": "2022-10-01 23:10:01",
        "title": "Moby Dick",
        "isbn": "0-553-21311-3",
        "price": 8.99
      },
      {
        "category": "fiction",
        "time": "2022-10-01 00:10:01",
        "title": "The Lord of the Rings",
        "isbn": "0-395-19395-8",
        "price": 22.99
      },
      {
        "category": "fiction",
        "time": "2022-10-01 01:10:01",
        "title": "The Lord of the Rings",
        "isbn": "0-395-19395-8",
        "price": 22.99
      },
      {
        "category": "fiction",
        "time": "2022-10-01 02:10:01",
        "title": "The Lord of the Rings",
        "isbn": "0-395-19395-8",
        "price": 22.99
      },
      {
        "category": "fiction",
        "time": "2022-10-01 03:10:01",
        "title": "The Lord of the Rings",
        "isbn": "0-395-19395-8",
        "price": 22.99
      }
    ],
    "bicycle": {
      "color": "red",
      "price": 19.95
    }
  },
  "expensive": 10
}

JsonPath 表达式：

$..book[?(@.time =~ /.* 22:.*|.* 23:.*|.* 00:.*|.* 01:.*/i)]

返回结果：

实例2：

测试数据：

{
  "category": "fiction",
  "time": "2022-10-01 03:10:01",
  "title": "The Lord of the Rings",
  "isbn": "0-395-19395-8",
  "price": 22.99
}

JsonPath 表达式：

$[?( @.time=~ /.* 22:.*|.* 23:.*|.* 00:.*|.* 01:.*/i)]

测试结果：