How to create multiple JSON array to JSON object in servlets

Question

I need to create variable amount of JSON objects and based on the result set from a database query. States retrieving from mysql database. I am saving the response in JSON array but it is saving in multiple JSON objects like that:

    jString userid = rs2.getString("state");
    JSONObject mainObj = new JSONObject();
    JSONArray jsArray = new JSONArray();
    jsArray.put(userid );
    mainObj.put("states", jsArray);

With this output:

    {"states":["karnataka"]}
    {"states":["kerala"]}
    {"states":["chennai"]}

Can I get output in single JSON object like {"States":"karnataka","kerala","chennai"}?

it really depends on your JSON structure. you can structure it as a list: "States": [ "karnataka", "kerala", "chennai" ] — Joseph D.
– Joseph D., Commented Mar 7, 2018 at 13:13

yri · Accepted Answer · 2018-03-07 14:30:30Z

1

You probably just got some code structure confused.

Try something like this:

JSONArray jsArray = new JSONArray();
JSONObject mainObj = new JSONObject();

//some kind of loop 
{
    jString userid = rs2.getString("state");
    jsArray.put(userid);
}
mainObj.put("states", jsArray);

answered Mar 7, 2018 at 14:30

yri

115 bronze badges

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

Collectives™ on Stack Overflow

How to create multiple JSON array to JSON object in servlets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related