How to count the object inside the JsonArray?

Question

Below Json format is my input, i need to count the total based on Object

Students:[
        {
        "Student_id": "101"
        "Name": "Jon",
        "Course" : "Engineer"
        },
        {
        "Student_id": "102"
        "Name": "Snow",
        "Course" : "Medical"
        },
        {
        "Student_id": "103"
        "Name": "Walter",
        "Course" : "Chemistry"
        },
        {
        "Student_id": "104"
        "Name": "White",
        "Course" : "Chemistry"
        }
    ]

When i loop the JsonArray Am not able to count the total?? it will show always count 1,i want output like below format

No Of Students: 4
Total Chemistry Students :2

Below code i tried,

            JsonArray Students=Details.getAsJsonArray("Students");

            for(int i=0;i<Students.size();i++)
            {
                JsonObject Std=Students.get(i).getAsJsonObject();
                String SrdID=Std.get("Student_id").getAsString();

                System.out.println("Student Details----"+SrdID);
            }


            String [] Studentarr=new String[] {"Student_id"};
            int Count=Studentarr.length;

            System.out.println("Count ---"+ Count);

Any Help will be Appreciate!! Thanks In Advance

When i loop the JsonArray Am not able to count the total?? it will show always count 1 -- Share the code that apparently does this. Also, which json library are you using? — Nicholas K
– Nicholas K, Commented Mar 14, 2019 at 16:54

Joni Sykes · Accepted Answer · 2019-03-14 17:01:03Z

0

Given that you know the structure for each element in the array is the same, could you create a Student class and have an array of Student objects?

In my experience, it's always better to manipulate objects than pure json, but you've not said in your question if that is a requirement or not, so I'll assume it is.

Therefore, you may find the answer on this similar question useful: how to count length of the JSON array element

Hope this helps!

answered Mar 14, 2019 at 17:01

Joni Sykes

192 bronze badges

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

Comments

C.P.O · Accepted Answer · 2019-03-14 17:06:57Z

0

With this structure:

var object = {"Students":[
    {
    "Student_id": "101",
    "Name": "Jon",
    "Course" : "Engineer"
    },
    {
    "Student_id": "102",
    "Name": "Snow",
    "Course" : "Medical"
    },
    {
    "Student_id": "103",
    "Name": "Walter",
    "Course" : "Chemistry"
    },
    {
    "Student_id": "104",
    "Name": "White",
    "Course" : "Chemistry"
    }]};

Now, we can try with JS this:

print(object.Students.length) // print total
print(object.Students.filter(st => st.Course === 'Chemistry').length) // print occurrences

Output is:

> 4
> 2

edited Mar 14, 2019 at 17:06

answered Mar 14, 2019 at 17:01

C.P.O

1,3212 gold badges14 silver badges31 bronze badges

1 Comment

tisispa1 Over a year ago

in java we cant pass the pass st => st.Course === 'Chemistry').length in stream like this coz its not accepted 'Chemistry' it will accept single Char 'e'

Collectives™ on Stack Overflow

How to count the object inside the JsonArray?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related