How to Parse parent-child related JsonArray in JAVA?

Question

This is the Json text. I can get "name,surname and books" as an Array. But the problem is books also is an array.And the content of books is coming in this form ;{"title:heresometext",paragraphs{value1:heresometext,value2:heresometext}} so it is like array in array. Like a parant-child relation. the thing i want to do is to reach thoose value1,value2,value3 strings seperated.

{"data"
 [
  "name" : "Here some text",
  "surname" : "Here some text",
  "books" : [
  {
    "title1" : "Here some text.",
    "paragraphs" : [
    {
        "value1" : "Here some text."
    },
    {
        "value2" : "Here some text."
    }
    ]
  },
  {
    "title2" : "Here some text.",
    "paragraphs" : [
    {
        "value3" : "Here some text.",
        "image1" : "Here some text."
    },
    {
        "value4" : "Here some text."
    },
    {
        "value5" : "Here some text."
    }
    ]
  }
  ]
 ]
}

How can i get them like this form, in a tree form seperated all datas to be able to save them in a DB. any help will be usefull

  name: "Here some text",
  surname: "Here some text",
  books:
         - title1 : "Here some text."
             -paragraphs:
                 - value : "Here some text.
                 - value : "Here some text.
         - title2 : "Here some text."
             -paragraphs:
                 - value : "Here some text.
                 - image : "Here some text.

mambax · Accepted Answer · 2015-07-15 08:07:12Z

1

We used JSON.simple in our projects. It is a JSON Parser.

Example:

public class JSONParsingExample {
  public static void main(String[] args) {
    JSONParser parser = new JSONParser();
    try {
      Object obj = parser.parse(new FileReader(parser.getClass().getClassLoader().getResource("jsondata.json").getFile()));
      JSONObject jsonObject = (JSONObject) obj;
      JSONObject data = (JSONObject) jsonObject.get("data");
      JSONArray books = (JSONArray) data.get("books");
      System.out.println(books);
      Iterator<JSONObject> iterator = books.iterator();
      while (iterator.hasNext()) {
        JSONObject book = (JSONObject) iterator.next();
        System.out.println("This books name is " + book.get("name"));
        JSONArray paras = (JSONArray) book.get("paras");
        Iterator<JSONObject> parasI = paras.iterator();
        int i = 0;
        while (parasI.hasNext()) {
          JSONObject para = (JSONObject) parasI.next();
          para.keySet().forEach(o -> System.out.println(o + "/" + para.get(o)));
        }
      }
    } catch (FileNotFoundException e) {
      e.printStackTrace();
    } catch (IOException e) {
      e.printStackTrace();
    } catch (ParseException e) {
      e.printStackTrace();
    }
  }
}

edited Jul 15, 2015 at 8:07

answered Jul 14, 2015 at 14:11

mambax

1,1278 silver badges18 bronze badges

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

4 Comments

Toolbox Over a year ago

i am using the JSON.simple too, but i cannot reach to sub array

mambax Over a year ago

We can in our bachelor work, let me check tomorrow how we do it.

Toolbox Over a year ago

look, mine has 3 arrays; data[books [pharagraphs [, , , ]]]. i can reach books elements but the output is {pharagraphs [, , ,]} and not useful in this way

mambax Over a year ago

I adapted my example, hope this helps (Youll need JDK8+ or adapt the forEach to a for loop)

Collectives™ on Stack Overflow

How to Parse parent-child related JsonArray in JAVA?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related