How to sort/order JSON output?

Question

I have a JSON loop and I am able to get objects in the loop, but the problem is my output is not in order:

My expected output is:

Menu Id 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23

but I get results like:

Menu Id: 19,18,23,16,17,14,15,12,13,21,20,22,4,3,11,2,1.

How can I sort this the way I expect?

           JSONArray values = menuObject.toJSONArray(names);
           for (int i = 0; i< values.length(); i++) {
                        JSONObject json2 = (JSONObject) values.getJSONObject(i);
                        //int menu_id = json2.getInt("menu_id");
                        menu_id = json2.getString("menu_id");
                        int m_id = Integer.parseInt(menu_id);
                        if (json2.has("menu_parent")) {
                           menu_parent = json2.getString("menu_parent");    
                        }
            if (m_id < 0) {

               //
             } else {
               id = id + menu_id + ",";
               int menu_category = Integer.parseInt(menu_parent);
               System.out.println("Menu Id" + id);
                   if (json2.has("menu_name")) {
                     menu_list = json2.getString(KEY_MENU).trim();
                     System.out.println("Menu List" +menu_title);
                     menu_title = menu_title + menu_list + ",";
                   }
               }

           }

@user1051599 it is the definition of json: An object is an unordered set of name/value pairs — Blackbelt
– Blackbelt, Commented Jan 30, 2013 at 14:32

Bigflow · Accepted Answer · 2013-01-30 13:25:23Z

1

I think you can get it sorted this way:

Collections.sort("your data", new Comparator<Item>() {
        public int compare(Item i1, Item i2) {
            return i1.getCaption().compareTo(i2.getCaption());
        }
    });

After this is done, it should be sorted out.

answered Jan 30, 2013 at 13:25

Bigflow

3,6646 gold badges31 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vamshi · Accepted Answer · 2013-01-30 14:46:25Z

Try this:

String menuids = "19,18,23,16,17,14,15,12,13,21,20,22,4,3,11,2,1";
        String[] ids = menuids.split(",");

                Integer[] result = new Integer[ids.length];
                for (int i = 0; i < ids.length; i++) {
                    result[i] = Integer.parseInt(ids[i].trim());
                }


                Collections.sort(Arrays.asList(result));

                StringBuilder sb = new StringBuilder();
                for (int i = 0; i < result.length; i++) {
                    Integer intValue = result[i];
                    sb.append(intValue);
                    if (i < result.length - 1) {
                        sb.append(", ");
                    }
                }

        String finaldata = sb.toString();

        System.out.println(finaldata);

Collectives™ on Stack Overflow

How to sort/order JSON output?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related