美文网首页
获取Json的值通过正则或Json解析器哪个快？

获取Json的值通过正则或Json解析器哪个快？

作者: 阿丘山 | 来源:发表于2019-02-28 14:44 被阅读0次

假设，我们从一个json中拿一个key的值，这个key唯一或者拿第一个出现的，我们用哪个更快一些？

Json字符串为请求接口返回的，多填充了一些字符

String jsonstr="{\"errCode\":\"0000\",\"retStatus\":\"1\",\"errMsg\":\"查询成功\",\"result\":{\"RecordCount\":9,\"Datas\":[{\"SFRemark\":\"-\",\"Col_003\":\"12346100108\",\"Col_007\":\"隔日达\",\"Col_043\":\"深圳腾讯\",\"Col_051\":\"杭州阿里\",\"Col_050\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_061\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"IsOvertime\":1,\"Col_044\":\"广东省深圳市字符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_052\":\"天津天津市南开区符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_004\":1,\"Col_098\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_056\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_014\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_006\":1.0,\"Col_054\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_046\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_053\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_092\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_117\":\"深圳腾讯\",\"Col_031\":\"寄方付\",\"Col_064\":\"无\",\"Col_315\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_316\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_317\":0,\"Col_291\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_318\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_076\":\"2019-02-21 17:26:00\",\"Col_109\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_062\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_063\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_106\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_281\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_282\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_107\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_108\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_113\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_328\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_329\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_263\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_423\":null,\"Col_422\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"COMPANYNO\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Scry\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"ScTel\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"SCAssistantN\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"SCAssistantT\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"DD_117\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"DD_118\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"sys_guid\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_360\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"MO_012\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_209\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"FlightNo\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"FlightTime\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_262\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\",\"Col_415\":\"符填充字符填充字符填充字符填充字符填充字符填充字符填充\"},{\"SFRemark\":\"-\",\"Col_003\":\"12346000196\",\"Col_007\":\"隔日达\",\"Col_043\":\"深圳飞月\",\"Col_051\":\"天津谛诺\",\"Col_050\":\"\",\"Col_061\":\"\",\"IsOvertime\":1,\"Col_044\":\"广东省深圳市宝安区福海街道和平社区桥和路38号\",\"Col_052\":\"天津天津市南开区万兴街道三潭西里社区天津市南开区中关村e谷08室\",\"Col_004\":1,\"Col_098\":\"\",\"Col_056\":\"\",\"Col_014\":\"\",\"Col_006\":1.0,\"Col_054\":\"\",\"Col_046\":\"\",\"Col_053\":\"\",\"Col_092\":\"\",\"Col_117\":\"深圳飞月\",\"Col_031\":\"寄方付\",\"Col_064\":\"无\",\"Col_315\":\"\",\"Col_316\":\"\",\"Col_317\":0,\"Col_291\":\"\",\"Col_318\":\"\",\"Col_076\":\"2019-02-21 15:37:00\",\"Col_109\":\"\",\"Col_062\":\"\",\"Col_063\":\"\",\"Col_106\":\"\",\"Col_281\":\"\",\"Col_282\":\"\",\"Col_107\":\"\",\"Col_108\":\"\",\"Col_113\":\"\",\"Col_328\":\"\",\"Col_329\":\"\",\"Col_263\":\"\",\"Col_423\":null,\"Col_422\":\"\",\"COMPANYNO\":\"\",\"Scry\":\"\",\"ScTel\":\"\",\"SCAssistantN\":\"\",\"SCAssistantT\":\"\",\"DD_117\":\"\",\"DD_118\":\"\",\"sys_guid\":\"\",\"Col_360\":\"\",\"MO_012\":\"\",\"Col_209\":\"\",\"FlightNo\":\"\",\"FlightTime\":\"\",\"Col_262\":\"\",\"Col_415\":\"\"},{\"SFRemark\":\"-\",\"Col_003\":\"12346000190\",\"Col_007\":\"隔日达\",\"Col_043\":\"深圳飞月\",\"Col_051\":\"上海达九\",\"Col_050\":\"\",\"Col_061\":\"\",\"IsOvertime\":1,\"Col_044\":\"广东省深圳市宝安区福海街道和平社区桥和路38号\",\"Col_052\":\"上海上海市闵行区浦锦街道李巷村联航路1818弄14号3楼\",\"Col_004\":1,\"Col_098\":\"\",\"Col_056\":\"\",\"Col_014\":\"\",\"Col_006\":1.0,\"Col_054\":\"\",\"Col_046\":\"\",\"Col_053\":\"\",\"Col_092\":\"\",\"Col_117\":\"深圳飞月\",\"Col_031\":\"寄方付\",\"Col_064\":\"无\",\"Col_315\":\"\",\"Col_316\":\"\",\"Col_317\":0,\"Col_291\":\"\",\"Col_318\":\"\",\"Col_076\":\"2019-02-21 14:19:00\",\"Col_109\":\"\",\"Col_062\":\"\",\"Col_063\":\"\",\"Col_106\":\"\",\"Col_281\":\"\",\"Col_282\":\"\",\"Col_107\":\"\",\"Col_108\":\"\",\"Col_113\":\"\",\"Col_328\":\"\",\"Col_329\":\"\",\"Col_263\":\"\",\"Col_423\":null,\"Col_422\":\"\",\"COMPANYNO\":\"\",\"Scry\":\"\",\"ScTel\":\"\",\"SCAssistantN\":\"\",\"SCAssistantT\":\"\",\"DD_117\":\"\",\"DD_118\":\"\",\"sys_guid\":\"\",\"Col_360\":\"\",\"MO_012\":\"\",\"Col_209\":\"\",\"FlightNo\":\"\",\"FlightTime\":\"\",\"Col_262\":\"\",\"Col_415\":\"\"},{\"SFRemark\":\"-\",\"Col_003\":\"12346000194\",\"Col_007\":\"隔日达\",\"Col_043\":\"深圳飞月\",\"Col_051\":\"天津谛诺\",\"Col_050\":\"\",\"Col_061\":\"\",\"IsOvertime\":1,\"Col_044\":\"广东省深圳市宝安区福海街道和平社区桥和路38号\",\"Col_052\":\"天津天津市南开区万兴街道三潭西里社区天津市南开区中关村e谷08室\",\"Col_004\":1,\"Col_098\":\"\",\"Col_056\":\"\",\"Col_014\":\"\",\"Col_006\":1.0,\"Col_054\":\"\",\"Col_046\":\"\",\"Col_053\":\"\",\"Col_092\":\"\",\"Col_117\":\"深圳飞月\",\"Col_031\":\"寄方付\",\"Col_064\":\"无\",\"Col_315\":\"\",\"Col_316\":\"\",\"Col_317\":0,\"Col_291\":\"\",\"Col_318\":\"\",\"Col_076\":\"2019-02-21 14:53:00\",\"Col_109\":\"\",\"Col_062\":\"\",\"Col_063\":\"\",\"Col_106\":\"\",\"Col_281\":\"\",\"Col_282\":\"\",\"Col_107\":\"\",\"Col_108\":\"\",\"Col_113\":\"\",\"Col_328\":\"\",\"Col_329\":\"\",\"Col_263\":\"\",\"Col_423\":null,\"Col_422\":\"\",\"COMPANYNO\":\"\",\"Scry\":\"\",\"ScTel\":\"\",\"SCAssistantN\":\"\",\"SCAssistantT\":\"\",\"DD_117\":\"\",\"DD_118\":\"\",\"sys_guid\":\"\",\"Col_360\":\"\",\"MO_012\":\"\",\"Col_209\":\"\",\"FlightNo\":\"\",\"FlightTime\":\"\",\"Col_262\":\"\",\"Col_415\":\"\"},{\"SFRemark\":\"-\",\"Col_003\":\"12346000191\",\"Col_007\":\"隔日达\",\"Col_043\":\"深圳飞月\",\"Col_051\":\"天津谛诺\",\"Col_050\":\"\",\"Col_061\":\"\",\"IsOvertime\":1,\"Col_044\":\"广东省深圳市宝安区福海街道和平社区桥和路38号\",\"Col_052\":\"天津天津市南开区万兴街道三潭西里社区天津市南开区中关村e谷08室\",\"Col_004\":1,\"Col_098\":\"\",\"Col_056\":\"\",\"Col_014\":\"\",\"Col_006\":1.0,\"Col_054\":\"\",\"Col_046\":\"\",\"Col_053\":\"\",\"Col_092\":\"\",\"Col_117\":\"深圳飞月\",\"Col_031\":\"寄方付\",\"Col_064\":\"无\",\"Col_315\":\"\",\"Col_316\":\"\",\"Col_317\":0,\"Col_291\":\"\",\"Col_318\":\"\",\"Col_076\":\"2019-02-21 14:32:00\",\"Col_109\":\"\",\"Col_062\":\"\",\"Col_063\":\"\",\"Col_106\":\"\",\"Col_281\":\"\",\"Col_282\":\"\",\"Col_107\":\"\",\"Col_108\":\"\",\"Col_113\":\"\",\"Col_328\":\"\",\"Col_329\":\"\",\"Col_263\":\"\",\"Col_423\":null,\"Col_422\":\"\",\"COMPANYNO\":\"\",\"Scry\":\"\",\"ScTel\":\"\",\"SCAssistantN\":\"\",\"SCAssistantT\":\"\",\"DD_117\":\"\",\"DD_118\":\"\",\"sys_guid\":\"\",\"Col_360\":\"\",\"MO_012\":\"\",\"Col_209\":\"\",\"FlightNo\":\"\",\"FlightTime\":\"\",\"Col_262\":\"\",\"Col_415\":\"\"},{\"SFRemark\":\"-\",\"Col_003\":\"12346000197\",\"Col_007\":\"隔日达\",\"Col_043\":\"深圳飞月\",\"Col_051\":\"天津谛诺\",\"Col_050\":\"\",\"Col_061\":\"\",\"IsOvertime\":1,\"Col_044\":\"广东省深圳市宝安区福海街道和平社区桥和路38号\",\"Col_052\":\"天津天津市南开区万兴街道三潭西里社区天津市南开区中关村e谷08室\",\"Col_004\":1,\"Col_098\":\"\",\"Col_056\":\"\",\"Col_014\":\"\",\"Col_006\":1.0,\"Col_054\":\"\",\"Col_046\":\"\",\"Col_053\":\"\",\"Col_092\":\"\",\"Col_117\":\"深圳飞月\",\"Col_031\":\"寄方付\",\"Col_064\":\"无\",\"Col_315\":\"\",\"Col_316\":\"\",\"Col_317\":0,\"Col_291\":\"\",\"Col_318\":\"\",\"Col_076\":\"2019-02-21 17:18:00\",\"Col_109\":\"\",\"Col_062\":\"\",\"Col_063\":\"\",\"Col_106\":\"\",\"Col_281\":\"\",\"Col_282\":\"\",\"Col_107\":\"\",\"Col_108\":\"\",\"Col_113\":\"\",\"Col_328\":\"\",\"Col_329\":\"\",\"Col_263\":\"\",\"Col_423\":null,\"Col_422\":\"\",\"COMPANYNO\":\"\",\"Scry\":\"\",\"ScTel\":\"\",\"SCAssistantN\":\"\",\"SCAssistantT\":\"\",\"DD_117\":\"\",\"DD_118\":\"\",\"sys_guid\":\"\",\"Col_360\":\"\",\"MO_012\":\"\",\"Col_209\":\"\",\"FlightNo\":\"\",\"FlightTime\":\"\",\"Col_262\":\"\",\"Col_415\":\"\"},{\"SFRemark\":\"-\",\"Col_003\":\"12346000193\",\"Col_007\":\"隔日达\",\"Col_043\":\"深圳飞月\",\"Col_051\":\"天津谛诺\",\"Col_050\":\"\",\"Col_061\":\"\",\"IsOvertime\":1,\"Col_044\":\"广东省深圳市宝安区福海街道和平社区桥和路38号\",\"Col_052\":\"天津天津市南开区万兴街道三潭西里社区天津市南开区中关村e谷08室\",\"Col_004\":1,\"Col_098\":\"\",\"Col_056\":\"\",\"Col_014\":\"\",\"Col_006\":1.0,\"Col_054\":\"\",\"Col_046\":\"\",\"Col_053\":\"\",\"Col_092\":\"\",\"Col_117\":\"深圳飞月\",\"Col_031\":\"寄方付\",\"Col_064\":\"无\",\"Col_315\":\"\",\"Col_316\":\"\",\"Col_317\":0,\"Col_291\":\"\",\"Col_318\":\"\",\"Col_076\":\"2019-02-21 14:44:00\",\"Col_109\":\"\",\"Col_062\":\"\",\"Col_063\":\"\",\"Col_106\":\"\",\"Col_281\":\"\",\"Col_282\":\"\",\"Col_107\":\"\",\"Col_108\":\"\",\"Col_113\":\"\",\"Col_328\":\"\",\"Col_329\":\"\",\"Col_263\":\"\",\"Col_423\":null,\"Col_422\":\"\",\"COMPANYNO\":\"\",\"Scry\":\"\",\"ScTel\":\"\",\"SCAssistantN\":\"\",\"SCAssistantT\":\"\",\"DD_117\":\"\",\"DD_118\":\"\",\"sys_guid\":\"\",\"Col_360\":\"\",\"MO_012\":\"\",\"Col_209\":\"\",\"FlightNo\":\"\",\"FlightTime\":\"\",\"Col_262\":\"\",\"Col_415\":\"\"},{\"SFRemark\":\"-\",\"Col_003\":\"12346000195\",\"Col_007\":\"隔日达\",\"Col_043\":\"深圳飞月\",\"Col_051\":\"天津谛诺\",\"Col_050\":\"\",\"Col_061\":\"\",\"IsOvertime\":1,\"Col_044\":\"广东省深圳市宝安区福海街道和平社区桥和路38号\",\"Col_052\":\"天津天津市南开区万兴街道三潭西里社区天津市南开区中关村e谷08室\",\"Col_004\":1,\"Col_098\":\"\",\"Col_056\":\"\",\"Col_014\":\"\",\"Col_006\":1.0,\"Col_054\":\"\",\"Col_046\":\"\",\"Col_053\":\"\",\"Col_092\":\"\",\"Col_117\":\"深圳飞月\",\"Col_031\":\"寄方付\",\"Col_064\":\"无\",\"Col_315\":\"\",\"Col_316\":\"\",\"Col_317\":0,\"Col_291\":\"\",\"Col_318\":\"\",\"Col_076\":\"2019-02-21 15:04:00\",\"Col_109\":\"\",\"Col_062\":\"\",\"Col_063\":\"\",\"Col_106\":\"\",\"Col_281\":\"\",\"Col_282\":\"\",\"Col_107\":\"\",\"Col_108\":\"\",\"Col_113\":\"\",\"Col_328\":\"\",\"Col_329\":\"\",\"Col_263\":\"\",\"Col_423\":null,\"Col_422\":\"\",\"COMPANYNO\":\"\",\"Scry\":\"\",\"ScTel\":\"\",\"SCAssistantN\":\"\",\"SCAssistantT\":\"\",\"DD_117\":\"\",\"DD_118\":\"\",\"sys_guid\":\"\",\"Col_360\":\"\",\"MO_012\":\"\",\"Col_209\":\"\",\"FlightNo\":\"\",\"FlightTime\":\"\",\"Col_262\":\"\",\"Col_415\":\"\"},{\"SFRemark\":\"-\",\"Col_003\":\"12346000192\",\"Col_007\":\"陆运件\",\"Col_043\":\"深圳飞月\",\"Col_051\":\"天津谛诺\",\"Col_050\":\"\",\"Col_061\":\"\",\"IsOvertime\":1,\"Col_044\":\"广东省深圳市宝安区福海街道和平社区桥和路38号\",\"Col_052\":\"天津天津市南开区万兴街道三潭西里社区天津市南开区中关村e谷08室\",\"Col_004\":1,\"Col_098\":\"\",\"Col_056\":\"\",\"Col_014\":\"\",\"Col_006\":100.0,\"Col_054\":\"\",\"Col_046\":\"\",\"Col_053\":\"\",\"Col_092\":\"\",\"Col_117\":\"深圳飞月\",\"Col_031\":\"寄方付\",\"Col_064\":\"无\",\"Col_315\":\"\",\"Col_316\":\"\",\"Col_317\":0,\"Col_291\":\"\",\"Col_318\":\"\",\"Col_076\":\"2019-02-21 14:37:00\",\"Col_109\":\"\",\"Col_062\":\"\",\"Col_063\":\"\",\"Col_106\":\"\",\"Col_281\":\"\",\"Col_282\":\"\",\"Col_107\":\"\",\"Col_108\":\"\",\"Col_113\":\"\",\"Col_328\":\"\",\"Col_329\":\"\",\"Col_263\":\"\",\"Col_423\":null,\"Col_422\":\"\",\"COMPANYNO\":\"\",\"Scry\":\"\",\"ScTel\":\"\",\"SCAssistantN\":\"\",\"SCAssistantT\":\"\",\"DD_117\":\"\",\"DD_118\":\"\",\"sys_guid\":\"\",\"Col_360\":\"\",\"MO_012\":\"\",\"Col_209\":\"\",\"FlightNo\":\"\",\"FlightTime\":\"\",\"Col_262\":\"\",\"Col_415\":\"\"}]}}";

1、我们使用正则表达式"key":"?"来拿取

long begin = System.currentTimeMillis();
String s1 = JsonRegUtil.getJsonString(jsonstr, "Col_117");
String s2 = JsonRegUtil.getJsonString(jsonstr, "Col_051");
System.out.println(s1);
System.out.println(s2);
long end = System.currentTimeMillis();

2、使用FastJson解析器，一层一层解析，然后拿到关键字的值

long begin2 = System.currentTimeMillis();
JSONObject omsObj = JSONObject.parseObject(jsonstr);
JSONObject result = omsObj.getJSONObject("result");
JSONArray datas = result.getJSONArray("Datas");
JSONObject jsonObject = datas.getJSONObject(0);
String Col_117 = jsonObject.getString("Col_117");
String Col_051 = jsonObject.getString("Col_051");
System.out.println(Col_117);
System.out.println(Col_051);
long end2 = System.currentTimeMillis();

打印结果

System.out.println("正则："+(end-begin));
System.out.println("json解析："+(end2-begin2));

结果发现：正则真的很快，0ms都有出现

image

当然，正则匹配比较呆板，适用场景不多，只适合拿取某个大json的时候获取值。

附上正则：

     /**
     * 获取 String 类型的value
     * @param jsonstr
     * @param key
     */
    public static String getJsonString(String jsonstr,String key) {
        String regex = "\""+key+"\":\"(.*?)\"";//使用非贪婪模式
        Matcher matcher = Pattern.compile(regex).matcher(jsonstr);
        while (matcher.find()) {
            //set.add(matcher.group(1));
            return matcher.group(1);
        }
        return null;
    }
     /**
     * 获取 Number 类型的value
     * @param jsonstr
     * @param key
     */
    public static String  getJsonNumber(String jsonstr,String key) {
        String regex = "\""+key+"\":([0-9.]+)";//使用非贪婪模式 匹配一个以上
        Matcher matcher = Pattern.compile(regex).matcher(jsonstr);
        while (matcher.find()) {
            //set.add(Integer.valueOf(matcher.group(1)));
            return matcher.group(1);

        }
        return null;
    }

也可以通过set或者map存储出现key的所有值，编码随自己定，欢迎讨论

相关文章

网友评论

      本文标题：获取Json的值通过正则或Json解析器哪个快？

      本文链接：https://www.haomeiwen.com/subject/fevhuqtx.html

      延伸阅读

      深度阅读

      • 您也可以注册成为美文阅读网的作者，发表您的原创作品、分享您的心情！

      栏目导航

      热点阅读

      关于我们|服务条款|联系我们|获取Json的值通过正则或Json解析器哪个快？|投稿指南|网站地图|RSS订阅|排版工具|手机版

      提供经典美文摘抄,优美散文欣赏,现代诗歌精选,短篇小说,心情随笔,表白情书范文,故事会在线阅读欣赏

      Copyright © 2014-2023 Haomeiwen.com All Rights Reserved. 好美文阅读网 版权所有

      备案信息：桂公网安备 45052102000051号 · 桂ICP备13007215号-3

      本站所收录作品、热点评论等信息部分来源互联网，目的只是为了系统归纳学习和传递资讯

      所有作品版权归原创作者所有，与本站立场无关，如不慎侵犯了你的权益，请联系我们告知，我们将做删除处理！