How to convert List to JsonArray in JAVA

Question

I have written a code, where I need to create a JSON format output from a "select * query". So far I am able to get the output like this, but I have to wrap it up inside "users"

{
  "displayName": "Tony Stark",
  "givenName": "Tony",
  "surname": "Stark"
},
{
  "displayName": "James Martin",
  "givenName": "James",
  "surname": "Martin"
}

I need something like this:

{
   "users": 
      [
            {
                  "displayName": "Tony Stark",
                  "givenName": "Toney",
                  "surname": "Stark"
            },
            {
                  "displayName": "James Martin",
                  "givenName": "James",
                  "surname": "Martin"
            }
      ]
}

Please help me out in this.

Please update the question with code where you are querying database and converting to json, — Smile, Aug 11 '20 at 06:34
Does this answer your question? [How to create correct JSONArray in Java using JSONObject](https://stackoverflow.com/questions/18983185/how-to-create-correct-jsonarray-in-java-using-jsonobject) — wovano, Aug 11 '20 at 15:25

score 1 · Answer 1 · edited Aug 11 '20 at 06:33

1

Yes it's possible if you create a model class named Users, map it properly along it with it's attributes so it will show exactly as shown by you in the screenshot. Attaching reference model class.

enter image description here

edited Aug 11 '20 at 06:33

Smile

3,832
3
25
39

answered Aug 11 '20 at 06:29

Ben Rahul

11
2

List jObj = getJSONFormat(resultSet); – SharadxDutta Aug 11 '20 at 06:41
I have a List as given above, I have the resultSet which is a List as well, if you print this you will get what I am getting now, – SharadxDutta Aug 11 '20 at 06:42
Can you tell me how can I wrap this list inside "users" – SharadxDutta Aug 11 '20 at 06:42

score 0 · Answer 2 · answered Aug 11 '20 at 06:43

0

It would be easy if add a wrap class and convert it to json

import java.util.List;

public class UserWrap {
    private List<User> users;

    public UserWrap(List<User> users) {
        this.users = users;
    }
}

answered Aug 11 '20 at 06:43

Lê Hoàng Dững

481
5
9

How to convert List to JsonArray in JAVA

2 Answers2