本文将为大家介绍json解析并按照某个字段排序的方法。如果是汉字，转化为汉语拼音后，按照字典顺序排序。

 

原始json

[{"proportionCost":0,"busiName":"aaav","userList":"李雷","allCost":53800,"liuCost":"0","projectName":"AMBHOME","storageCost":52000,"calculationCost":1800},
{"proportionCost":0,"busiName":"aaaa","userList":"韩梅梅","allCost":1000,"liuCost":"0","projectName":"SCCS","storageCost":0,"calculationCost":0},
{"proportionCost":0,"busiName":"aaas","userList":"孙悟空","allCost":3000,"liuCost":"0","projectName":"JPJ","storageCost":0,"calculationCost":1800},
{"proportionCost":0,"busiName":"aaaj","userList":"白骨精","allCost":2600,"liuCost":"0","projectName":"EMAIL","storageCost":2600,"calculationCost":0},
{"proportionCost":0,"busiName":"aaah","userList":"牛魔王","allCost":2000,"liuCost":"0","projectName":"FOP","storageCost":0,"calculationCost":0},
{"proportionCost":0,"busiName":"aaab","userList":"周瑜","allCost":1200,"liuCost":"0","projectName":"TXTP","storageCost":0,"calculationCost":0},
{"proportionCost":0,"busiName":"aaak","userList":"黄盖","allCost":8000,"liuCost":"0","projectName":"FQL","storageCost":0,"calculationCost":0}]

 

一、value为int，按照数值的大小排序

public void sortByInt(){
    String result="[{\"proportionCost\":0,\"busiName\":\"aaav\",\"userList\":\"李雷\",\"allCost\":53800,\"liuCost\":\"0\",\"projectName\":\"AMBHOME\",\"storageCost\":52000,\"calculationCost\":1800},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaaa\",\"userList\":\"韩梅梅\",\"allCost\":1000,\"liuCost\":\"0\",\"projectName\":\"SCCS\",\"storageCost\":0,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaas\",\"userList\":\"孙悟空\",\"allCost\":3000,\"liuCost\":\"0\",\"projectName\":\"JPJ\",\"storageCost\":0,\"calculationCost\":1800},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaaj\",\"userList\":\"白骨精\",\"allCost\":2600,\"liuCost\":\"0\",\"projectName\":\"EMAIL\",\"storageCost\":2600,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaah\",\"userList\":\"牛魔王\",\"allCost\":2000,\"liuCost\":\"0\",\"projectName\":\"FOP\",\"storageCost\":0,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaab\",\"userList\":\"周瑜\",\"allCost\":1200,\"liuCost\":\"0\",\"projectName\":\"TXTP\",\"storageCost\":0,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaak\",\"userList\":\"黄盖\",\"allCost\":8000,\"liuCost\":\"0\",\"projectName\":\"FQL\",\"storageCost\":0,\"calculationCost\":0}]";
    System.out.println(result);
    JSONArray jsonArray = JSON.parseArray(result);
    JSONArray sortJsonArray = new JSONArray();
    List<JSONObject> jsonValue = new ArrayList<JSONObject>();
    for (int i = 0; i < jsonArray.size(); i++){
        jsonValue.add(jsonArray.getJSONObject(i));
    }
    Collections.sort(jsonValue, new Comparator<JSONObject>() {
        private static final String key = "allCost";
        @Override
        public int compare(JSONObject o1, JSONObject o2) {
            int va1 = o1.getIntValue(key);
            int va2 = o2.getIntValue(key);
            return va1-va2;
        }
    });
    for(int i = 0; i < jsonArray.size(); i++){
        sortJsonArray.add(jsonValue.get(i));
    }
    System.out.println(sortJsonArray.toJSONString());
}

运行结果

[{"proportionCost":0,"busiName":"aaaa","userList":"韩梅梅","allCost":1000,"liuCost":"0","projectName":"SCCS","storageCost":0,"calculationCost":0},{"proportionCost":0,"busiName":"aaab","userList":"周瑜","allCost":1200,"liuCost":"0","projectName":"TXTP","storageCost":0,"calculationCost":0},{"proportionCost":0,"busiName":"aaah","userList":"牛魔王","allCost":2000,"liuCost":"0","projectName":"FOP","storageCost":0,"calculationCost":0},{"proportionCost":0,"busiName":"aaaj","userList":"白骨精","allCost":2600,"liuCost":"0","projectName":"EMAIL","storageCost":2600,"calculationCost":0},{"proportionCost":0,"busiName":"aaas","userList":"孙悟空","allCost":3000,"liuCost":"0","projectName":"JPJ","storageCost":0,"calculationCost":1800},{"proportionCost":0,"busiName":"aaak","userList":"黄盖","allCost":8000,"liuCost":"0","projectName":"FQL","storageCost":0,"calculationCost":0},{"proportionCost":0,"busiName":"aaav","userList":"李雷","allCost":53800,"liuCost":"0","projectName":"AMBHOME","storageCost":52000,"calculationCost":1800}]

 

二、value为String类型，按照字典顺序排序

public void sortByString(){
    String result="[{\"proportionCost\":0,\"busiName\":\"aaav\",\"userList\":\"李雷\",\"allCost\":53800,\"liuCost\":\"0\",\"projectName\":\"AMBHOME\",\"storageCost\":52000,\"calculationCost\":1800},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaaa\",\"userList\":\"韩梅梅\",\"allCost\":1000,\"liuCost\":\"0\",\"projectName\":\"SCCS\",\"storageCost\":0,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaas\",\"userList\":\"孙悟空\",\"allCost\":3000,\"liuCost\":\"0\",\"projectName\":\"JPJ\",\"storageCost\":0,\"calculationCost\":1800},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaaj\",\"userList\":\"白骨精\",\"allCost\":2600,\"liuCost\":\"0\",\"projectName\":\"EMAIL\",\"storageCost\":2600,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaah\",\"userList\":\"牛魔王\",\"allCost\":2000,\"liuCost\":\"0\",\"projectName\":\"FOP\",\"storageCost\":0,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaab\",\"userList\":\"周瑜\",\"allCost\":1200,\"liuCost\":\"0\",\"projectName\":\"TXTP\",\"storageCost\":0,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaak\",\"userList\":\"黄盖\",\"allCost\":8000,\"liuCost\":\"0\",\"projectName\":\"FQL\",\"storageCost\":0,\"calculationCost\":0}]";
    System.out.println(result);
    JSONArray jsonArray = JSON.parseArray(result);
    JSONArray sortJsonArray = new JSONArray();
    List<JSONObject> jsonValue = new ArrayList<JSONObject>();
    for (int i = 0; i < jsonArray.size(); i++){
        jsonValue.add(jsonArray.getJSONObject(i));
    }
    Collections.sort(jsonValue, new Comparator<JSONObject>() {
        private static final String key = "busiName";
        @Override
        public int compare(JSONObject o1, JSONObject o2) {
            String val1 = o1.getString(key);
            String val2 = o2.getString(key);
            return val1.compareTo(val2);
        }
    });
    for(int i = 0; i < jsonArray.size(); i++){
        sortJsonArray.add(jsonValue.get(i));
    }
    System.out.println(sortJsonArray.toJSONString());
}

运行结果

[{"proportionCost":0,"busiName":"aaaa","userList":"韩梅梅","allCost":1000,"liuCost":"0","projectName":"SCCS","storageCost":0,"calculationCost":0},{"proportionCost":0,"busiName":"aaab","userList":"周瑜","allCost":1200,"liuCost":"0","projectName":"TXTP","storageCost":0,"calculationCost":0},{"proportionCost":0,"busiName":"aaah","userList":"牛魔王","allCost":2000,"liuCost":"0","projectName":"FOP","storageCost":0,"calculationCost":0},{"proportionCost":0,"busiName":"aaaj","userList":"白骨精","allCost":2600,"liuCost":"0","projectName":"EMAIL","storageCost":2600,"calculationCost":0},{"proportionCost":0,"busiName":"aaak","userList":"黄盖","allCost":8000,"liuCost":"0","projectName":"FQL","storageCost":0,"calculationCost":0},{"proportionCost":0,"busiName":"aaas","userList":"孙悟空","allCost":3000,"liuCost":"0","projectName":"JPJ","storageCost":0,"calculationCost":1800},{"proportionCost":0,"busiName":"aaav","userList":"李雷","allCost":53800,"liuCost":"0","projectName":"AMBHOME","storageCost":52000,"calculationCost":1800}]

 

三、value为汉字，按照汉语拼音的字典顺序排序

 

首先，需要添加汉字转拼音的工具类的依赖

<!-- https://mvnrepository.com/artifact/com.belerweb/pinyin4j -->
<dependency>
    <groupId>com.belerweb</groupId>
    <artifactId>pinyin4j</artifactId>
    <version>2.5.0</version>
</dependency>
/**
 * value为汉字，按照汉语拼音的字典顺序排序
 */
@Test
public void sortByPinyin(){
    String result="[{\"proportionCost\":0,\"busiName\":\"aaav\",\"userList\":\"李雷\",\"allCost\":53800,\"liuCost\":\"0\",\"projectName\":\"AMBHOME\",\"storageCost\":52000,\"calculationCost\":1800},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaaa\",\"userList\":\"韩梅梅\",\"allCost\":1000,\"liuCost\":\"0\",\"projectName\":\"SCCS\",\"storageCost\":0,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaas\",\"userList\":\"孙悟空\",\"allCost\":3000,\"liuCost\":\"0\",\"projectName\":\"JPJ\",\"storageCost\":0,\"calculationCost\":1800},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaaj\",\"userList\":\"白骨精\",\"allCost\":2600,\"liuCost\":\"0\",\"projectName\":\"EMAIL\",\"storageCost\":2600,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaah\",\"userList\":\"牛魔王\",\"allCost\":2000,\"liuCost\":\"0\",\"projectName\":\"FOP\",\"storageCost\":0,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaab\",\"userList\":\"周瑜\",\"allCost\":1200,\"liuCost\":\"0\",\"projectName\":\"TXTP\",\"storageCost\":0,\"calculationCost\":0},\n" +
            "{\"proportionCost\":0,\"busiName\":\"aaak\",\"userList\":\"黄盖\",\"allCost\":8000,\"liuCost\":\"0\",\"projectName\":\"FQL\",\"storageCost\":0,\"calculationCost\":0}]";
    System.out.println(result);
    JSONArray jsonArray = JSON.parseArray(result);
    JSONArray sortJsonArray = new JSONArray();
    List<JSONObject> jsonValue = new ArrayList<JSONObject>();
    for (int i = 0; i < jsonArray.size(); i++){
        jsonValue.add(jsonArray.getJSONObject(i));
    }
    Collections.sort(jsonValue, new Comparator<JSONObject>() {
        private static final String key = "userList";
        @Override
        public int compare(JSONObject o1, JSONObject o2) {
            String val1 = getPinyin(o1.getString(key));
            String val2 = getPinyin(o2.getString(key));
            return val1.compareTo(val2);
        }
    });
    for(int i = 0; i < jsonArray.size(); i++){
        sortJsonArray.add(jsonValue.get(i));
    }
    System.out.println(sortJsonArray.toJSONString());
}


/**
 * 汉字转拼音
 * @param chinese
 * @return
 */
public static String getPinyin(String chinese){

    String pinyinStr = "";
    char[] newChar = chinese.toCharArray();
    HanyuPinyinOutputFormat pinyinFormat = new HanyuPinyinOutputFormat();
    pinyinFormat.setCaseType(HanyuPinyinCaseType.LOWERCASE);
    pinyinFormat.setToneType(HanyuPinyinToneType.WITHOUT_TONE);
    for(int i = 0; i < newChar.length; i++){
        if(newChar[i] > 128){
            try {
                pinyinStr += PinyinHelper.toHanyuPinyinStringArray(newChar[i], pinyinFormat)[0];
//                    pinyinStr += PinyinHelper.toHanyuPinyinStringArray(newChar[i], pinyinFormat)[0];//转为拼音后取首字母
            } catch (BadHanyuPinyinOutputFormatCombination badHanyuPinyinOutputFormatCombination) {
                badHanyuPinyinOutputFormatCombination.printStackTrace();
            }
        }else{
            pinyinStr += newChar[i];
        }
    }
    return pinyinStr;
}

运行结果

[{"proportionCost":0,"busiName":"aaaj","userList":"白骨精","allCost":2600,"liuCost":"0","projectName":"EMAIL","storageCost":2600,"calculationCost":0},{"proportionCost":0,"busiName":"aaaa","userList":"韩梅梅","allCost":1000,"liuCost":"0","projectName":"SCCS","storageCost":0,"calculationCost":0},{"proportionCost":0,"busiName":"aaak","userList":"黄盖","allCost":8000,"liuCost":"0","projectName":"FQL","storageCost":0,"calculationCost":0},{"proportionCost":0,"busiName":"aaav","userList":"李雷","allCost":53800,"liuCost":"0","projectName":"AMBHOME","storageCost":52000,"calculationCost":1800},{"proportionCost":0,"busiName":"aaah","userList":"牛魔王","allCost":2000,"liuCost":"0","projectName":"FOP","storageCost":0,"calculationCost":0},{"proportionCost":0,"busiName":"aaas","userList":"孙悟空","allCost":3000,"liuCost":"0","projectName":"JPJ","storageCost":0,"calculationCost":1800},{"proportionCost":0,"busiName":"aaab","userList":"周瑜","allCost":1200,"liuCost":"0","projectName":"TXTP","storageCost":0,"calculationCost":0}]

 

 

 

 

# json
GitHub 加速计划 / js / json
41.72 K
6.61 K
下载
适用于现代 C++ 的 JSON。
最近提交(Master分支：1 个月前 )
960b763e 4 个月前
8c391e04 6 个月前
Logo
GitCode 开源社区

旨在为数千万中国开发者提供一个无缝且高效的云端环境，以支持学习、使用和贡献开源项目。

更多推荐

[转载]在Windows环境下安装GNU Radio

转自：在Windows环境下安装GNURadio_恐弱智_新浪博客GNU Radio是用Python开发的，大部分开源的工程能够在Linux环境下运行良好，而Windows下却运行的很勉强，而且安装配置都很复杂。GNU Radio算是个例外了，不光提供了Windows的二进制安装，还有比较详细的说明。我是Python小白，所以折腾了好久才弄好，特意记录下来，免得以后再装还折腾。GNU Radio的

avatar GitCode 开源社区

centOS 8 使用dnf安装Docker

DNF是什么？CentOS 8使用YUM软件包管理器版本v4.0.4。现在，该版本使用DNF(已删除YUM)。DNF是软件包管理器。它会在Linux发行版上安装，执行更新并删除软件包。使用DNF安装Docker跳过具有损坏依赖性的程序包一个有效的解决方案是使您的CentOS 8系统使用以下--nobest命令安装最符合条件的版本：sudo dnf install docker...

avatar GitCode 开源社区

定时同步数据库表(mysql+linux+crontab)

sync.sh里面的参数需要改变，ip/username/password/database/tablesync.sh#!/bin/sh# Please change the IP and password of the data source db.# Then change the table name.filename=/home/nington/db/$(date +%Y-%m

avatar GitCode 开源社区