Parsing and retrieving elements in a JSON Java

Question

   JSONParser parser = new JSONParser();
   try {
       Object obj = parser.parse(new FileReader("C:/Users/dan/Documents/rental.txt"));
       JSONObject jsonObject = (JSONObject) obj;
       for(Iterator iterator = jsonObject.keySet().iterator(); iterator.hasNext();) {
           String key = (String) iterator.next();
           System.out.println(jsonObject.get(key));
       }

    } catch (Exception e) {
        e.printStackTrace();
    }

Following is the JSON String:

{
    "Search": {
        "VehicleList": [
            {
                "sipp": "CDMR",
                "name": "Ford Focus",
                "price": 157.85,
                "supplier": "Hertz",
                "rating": 8.9
            },
            {
                "sipp": "FVAR",
                "name": "Ford Galaxy",
                "price": 706.89,
                "supplier": "Hertz",
                "rating": 8.9
            }
          ]
        }
      }
 }

Hi, I can iterate over the whole JSON object with my code but right now I want to print out the name of a vehicle and the price of the vehicle individually. Any help would be appreciated, I am a beginner when it comes to working with JSON.

I want to print out the name of each vehicle and the price of each vehicle @PSM — John Staples
– John Staples, Commented Nov 15, 2016 at 12:25

Murat Karagöz · Accepted Answer · 2016-11-15 12:31:47Z

1

Your JSON is structured like this JsonObject -> JsonArray-> [JsonObject]
With that in mind you can access the name and price with this

Object obj = parser.parse(new FileReader("C:/Users/dan/Documents/rental.txt"));
JSONArray jsonArray = (JSONObject) obj.getJsonArray("VehicleList");
for(JSONObject jsonObject : jsonArray){
        System.out.println(jsonObject.getString("name") + " " + jsonObject.getDouble("price"))
    }
}

Depending on your import library it may deviate from the above but the concept is the same.

answered Nov 15, 2016 at 12:31

Murat Karagöz

37.8k16 gold badges82 silver badges114 bronze badges

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

1 Comment

John Staples Over a year ago

Hi, my import library is the org.json.simple; library

Sheetal Mohan Sharma · Accepted Answer · 2016-11-15 12:31:05Z

0

You need to iterate over the json. For example.

$.Search.VehicleList[0].price will give you [157.85]
$.Search.VehicleList[1].price will give you [706.89]

http://www.jsonquerytool.com/ will come handy for you :)

answered Nov 15, 2016 at 12:31

Sheetal Mohan Sharma

2,9501 gold badge25 silver badges25 bronze badges

Collectives™ on Stack Overflow

Parsing and retrieving elements in a JSON Java

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related