Extract JSON array using Simple Json Library

Question

My JSON data look like this.

{"Users":[
    {"Username":"Admin1", "Password":"123"},
    {"Username":"Admin2", "Password":"456"},
    {"Username":"Admin3", "Password":"789"}
]}

I am trying to extract out all the list of Username and Password.

JSONParser parser=new JSONParser();
Object obj = parser.parse(new FileReader("./Database/Users.json"));
JSONObject jsonObject = (JSONObject) obj;
JSONArray userArray = (JSONArray) jsonObject.get("Users");

How do I then iterate through this JSONArray to achieve what I wanted?

Gavin · Accepted Answer · 2015-10-22 17:24:53Z

3

Sorry if I wasn't clear. I was using org.json.simple, not org.json. And the JSONArray does not have the int length() method.

What I did was

Iterator<JSONObject> iterator = userArray.iterator();
        while (iterator.hasNext()) {
             JSONObject factObj = (JSONObject) iterator.next();
             String userName = (String) factObj.get("Username");
             String passWord = (String) factObj.get("Password");
        }

answered Oct 22, 2015 at 17:24

Gavin

2,8447 gold badges45 silver badges81 bronze badges

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

Comments

Gaël J · Accepted Answer · 2015-10-22 17:20:28Z

0

Read the javadoc ;)

If you are using org.json.JSONArray, you can loop using int length() to know the array's length and Object get(index) or JSONObject getJSONObject(index) to get an item of the array.

answered Oct 22, 2015 at 17:20

Gaël J

15.9k5 gold badges25 silver badges47 bronze badges

Comments

wawek · Accepted Answer · 2015-10-22 17:21:41Z

0

You can iterate with for loop

for (int i = 0; i < userArray.length(); ++i) {
   JSONObject user = recs.getJSONObject(i);
   ...
}

answered Oct 22, 2015 at 17:21

wawek

1,5971 gold badge14 silver badges25 bronze badges

Comments

William Ku · Accepted Answer · 2015-10-22 17:23:24Z

-1

you can probably do something like the following

for(int i = 0; i < userArray.length; i++) {
   JSONObject user = userArray.getJSONObject(i);
   String username = user.getString("Username");
   String password = user.getString("Password");
   //etc
}

answered Oct 22, 2015 at 17:23

William Ku

7985 silver badges17 bronze badges

Collectives™ on Stack Overflow

Extract JSON array using Simple Json Library

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related