CODEWITHSUNDEEP
javajson
Kushagra Sinha
Kushagra Sinha

Reputation: 89

Unable to parse the key and value of nested json file using java

Below is the json file i am trying to parse.I want to print all key and corresponding values.

{
 "A":{
   "name":"Ram",
   "gender":"male",
   "designation":"engineer"
 },
 "B":{
  "name":"Shyam",
  "gender":"male",
  "designation":"student"
 },
 "C":{
  "name":"Mohan",
  "gender":"male",
  "designation":"manager"
 }
}

I have tried the following code:

import java.io.FileNotFoundException;
import java.io.FileReader;
import java.util.Iterator;
import org.json.JSONArray;
import org.json.JSONObject;
import org.json.simple.parser.JSONParser;

public class FetchJsonNested {
    public static void main(String args[]) throws FileNotFoundException {
        try {
            JSONParser jp=new JSONParser();
            Object obj=jp.parse(new FileReader("C:\\Users\\DELL\\Documents\\NetBeansProjects\\WaterNetwork\\web\\kusharray.json"));
            JSONObject job=(JSONObject)obj;
            Iterator < ? > keys = job.keys();

            while (keys.hasNext()) {
                String key = (String) keys.next();
                System.out.println(key);
                if (job.get(key) instanceof JSONObject) {
                    System.out.println(job.get(key));
                }
            }
        } catch(Exception e) {
            e.printStackTrace();
        }
    }
}

I have read stuffs from many site but no one is working like the way i want.I want to print all keys and corresponding values.

Upvotes: 0

Views: 495

Answers (2)

Asew
Asew

Reputation: 374

Using org.json as you did in your example : 

String jsonStr = "{\"A\":{\"name\":\"Ram\",\"gender\":\"male\",\"designation\":\"engineer\"},\"B\":{\"name\":\"Shyam\",\"gender\":\"male\",\"designation\":\"student\"},\"C\":{\"name\":\"Mohan\",\"gender\":\"male\",\"designation\":\"manager\"}}";
JSONObject json = new JSONObject(jsonStr);

for (Object key : json.keySet().toArray()){
    JSONObject data = json.getJSONObject(key.toString());
    System.out.println("json :" + data.toString());
    System.out.println("name :" +data.getString("name"));
    System.out.println("gender :" +data.getString("gender"));
    System.out.println("designation :" +data.getString("designation"));
}

Now you can replace my first line "String jsonStr = ..." with your file reader.

Upvotes: 1

Marcelo Idemax
Marcelo Idemax

Reputation: 2810

below follow not the awesome and most elegant solution but this can lead you to what you need.

import com.google.gson.JsonElement;
import com.google.gson.JsonObject;
import com.google.gson.JsonParser;

import java.io.FileNotFoundException;
import java.io.FileReader;
import java.util.Map;
import java.util.Scanner;
import java.util.Set;

public class Main {

    public static void main(String[] args) throws Exception {
        String jsonString = loadJSONFile();

        JsonElement jsonElement = new JsonParser().parse(jsonString);
        JsonObject jsonObject = jsonElement.getAsJsonObject();

        print(jsonObject);
    }

    private static String loadJSONFile() throws FileNotFoundException {
        Scanner scanner = new Scanner(new FileReader("path/to/the/json/file.ext"));
        StringBuilder stringBuilder = new StringBuilder();

        while (scanner.hasNext()) {
            stringBuilder.append(scanner.next());
        }

        scanner.close();

        return stringBuilder.toString();
    }

    private static void print(JsonObject jsonObject) {
        Set<Map.Entry<String, JsonElement>> entries = jsonObject.entrySet();

        for (Map.Entry<String, JsonElement> entry : entries) {
            System.out.println(entry.getKey() + ": " + entry.getValue());

            try {
                JsonElement jsonElement = new JsonParser().parse(String.valueOf(entry.getValue()));
                JsonObject innerJsonObject = jsonElement.getAsJsonObject();

                print(innerJsonObject);
            } catch (Exception e) {
                // is not a JSON
            }
        }
    }
}

Output example:

A: {"name":"Ram","gender":"male","designation":"engineer"}
name: "Ram"
gender: "male"
designation: "engineer"
B: {"name":"Shyam","gender":"male","designation":"student"}
name: "Shyam"
gender: "male"
designation: "student"
C: {"name":"Mohan","gender":"male","designation":"manager"}
name: "Mohan"
gender: "male"
designation: "manager"

Upvotes: 0

Related Questions