How to Update JSONArray value on java

Question

can anyone help me, i'am new on java programing

let say i have JSONArray with this data below :

[{
    "STATUSUPDATE": 0,
    "IDSERV": "2"
}, {
   "STATUSUPDATE": 0,
   "IDSERV": "3"
}, {
   "STATUSUPDATE": 0,
   "IDSERV": "1"
}]

How to update STATUSUPDATE to 1 in IDSERV 2

How to update STATUSUPDATE to 2 in IDSERV 3

and was trying to loop the data

for (int i=0; i < array.length; i++){
JSONObject itemArr = (JSONObject)array.get(j);
if(itemArr.get("IDSERV").equals(2)){
//should be itemArr.set(with new val) 
//but method *set* can cal; only on JSONArray not an JSONObject
//and looping the next one 
}
}

can anyone help me

You could use replace with a regex pattern.

Olian04
– Olian04

2016-08-12 08:30:23 +00:00
Commented Aug 12, 2016 at 8:30 — Olian04
– Olian04, Commented Aug 12, 2016 at 8:30
can u direct me to the example @Olian?

user3502930
– user3502930

2016-08-12 08:34:53 +00:00
Commented Aug 12, 2016 at 8:34 — user3502930
– user3502930, Commented Aug 12, 2016 at 8:34
just posted an answer. Take a look :)

Olian04
– Olian04

2016-08-12 08:46:26 +00:00
Commented Aug 12, 2016 at 8:46 — Olian04
– Olian04, Commented Aug 12, 2016 at 8:46

Kruti Patel · Accepted Answer · 2016-08-12 08:53:42Z

9

Here is the code:

array is your JSONArray

for (int i=0; i < array.length(); i++){
    JSONObject itemArr = (JSONObject)arr.get(i);
    if(itemArr.get("IDSERV").getAsString().equals("2")){
        itemArr.put("STATUSUPDATE", 1);
    }else if(itemArr.get("IDSERV").getAsString().equals("3")){
        itemArr.put("STATUSUPDATE", 2);
    }
}

Now, if you print array then you can see values are changed.

answered Aug 12, 2016 at 8:53

Kruti Patel

1,4722 gold badges24 silver badges37 bronze badges

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

1 Comment

Hemanth Annavarapu Over a year ago

thanks for the answer. However, This approach will modify the value of STATUSUPDATE in itemArr right? the values in the original JSONArray array will the remain the same as before, right? @KrutiPatel

Raman Sahasi · Accepted Answer · 2016-08-12 08:43:51Z

JSONArray specific code:

Output

Initial array : [{"STATUSUPDATE":0,"IDSERV":"2"},{"STATUSUPDATE":0,"IDSERV":"3"},{"STATUSUPDATE":0,"IDSERV":"1"}]
Output array : [{"STATUSUPDATE":"1","IDSERV":"2"},{"STATUSUPDATE":"2","IDSERV":"3"},{"STATUSUPDATE":0,"IDSERV":"1"}]

Code

public class Test {
    public static void main(String[] args) throws JSONException {
        JSONArray array = new JSONArray("[{\"STATUSUPDATE\":0,\"IDSERV\":\"2\"},{\"STATUSUPDATE\":0,\"IDSERV\":\"3\"},{\"STATUSUPDATE\":0,\"IDSERV\":\"1\"}]");
        System.out.println("Initial array : " + array);

        for (int i=0; i < array.length(); i++){
            JSONObject jsonObject = new JSONObject(array.get(i).toString());
            if(jsonObject.get("IDSERV").equals("2")) {
                jsonObject.put("STATUSUPDATE", "1");
                array.put(i, jsonObject);
            }
            else if(jsonObject.get("IDSERV").equals("3")) {
                jsonObject.put("STATUSUPDATE", "2");
                array.put(i, jsonObject);
            }
        }

        System.out.println("Output array : " + array);
    }
}

Olian04 · Accepted Answer · 2016-08-12 08:54:06Z

0

Using regex and replaceAll:

String json = ...
json.replaceAll("(?<=\"IDSERV\":\")\\d*(?=\")", new value);

The above will locate and replace ALL IDSERV fields.
If you only want to find and replace ONE of the IDSERV fields, change the \\d to [] and put the expected value to swap in between the braces.
Ex: [1] will find and replace all values equal to 1.

EDIT1:
Ok, you just edited the question.

This regex allows you to target a specific IDSERV and changes its STATUSUPDATE field.

(?<=:)\d*(?=,"IDSERV":"1")

In the above, change the number 1 to whatever value of IDSERV you want to look for.

In java that would be:

String json = ...
json.replaceAll("(?<=:)\\d*(?=,\"IDSERV\":\"1\")", new value);

edited Aug 12, 2016 at 8:54

answered Aug 12, 2016 at 8:42

Olian04

6,9002 gold badges31 silver badges56 bronze badges

Comments

Santhosh Hirekerur · Accepted Answer · 2020-05-13 05:40:05Z

0

I used replacing some fields its decimal values to zero on user role. Its working

shimpment=shimpment.replaceAll("\"shipmentValue\":[0-9]+.[0-9]+", "\"shipmentValue\":0.00");
shimpment=shimpment.replaceAll("\"price\":[0-9]+.[0-9]+", "\"price\":0.00");
shimpment=shimpment.replaceAll("\"tax\":[0-9]+.[0-9]+", "\"tax\":0.00");

answered May 13, 2020 at 5:40

Santhosh Hirekerur

8769 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to Update JSONArray value on java

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related