JAVA org.json not showing empty value

Question

Here is my JAVA JSON code

@GET
@Consumes("application/x-www-form-urlencoded")
@Path("/getAllEmp")
public Response GetAllEmp() {
    JSONObject returnJson = new JSONObject();
    try {
        ArrayList<Emp_Objects> objList = new ArrayList<Emp_Objects>();
        DBConnection conn = new DBConnection();
        objList = conn.GetEmpDetails();

        JSONArray empArray = new JSONArray();
        if (!objList.isEmpty()) {
            GetLocation loc = new GetLocation();
            for (Emp_Objects obj : objList) {
                JSONObject jsonObj = new JSONObject();
                jsonObj.put("id", obj.id);
                jsonObj.put("name", obj.name);
                jsonObj.put("email", obj.email);
                jsonObj.put("address", obj.address);
                empArray.put(jsonObj);
            }
        }
        returnJson.put("data", empArray);
    } catch (Exception e) {
    }

    return Response.ok(returnJson.toString()).header("Access-Control-Allow-Origin", "*").build();
}

When i execute this it gives me the following json

{
    "data": [{
        "id": 1,
        "name": "123_name"
    }, {
        "id": 2,
        "name": "321_name",
        "email": "[email protected]"
    }]
}

In the above json email and address are missing because email and address is null on database.

So can i show json with empty value like following

{
    "data": [{
        "id": 1,
        "name": "123_name",
        "email": "",
        "address": ""
    }, {
        "id": 2,
        "name": "321_name",
        "email": "",
        "address": ""
    }]
}

I am using JAVA and org.json with MySQL database.

numsu · Accepted Answer · 2016-06-03 13:21:06Z

4

If the objects are null, insert an empty String instead.

jsonObj.put("email", obj.email == null ? "" : obj.email);
jsonObj.put("address", obj.address == null ? "" : obj.address);

If you have a larger amount of rows to process, I recommend you to turn this is to a function for better readability and to save you some time.

jsonObj.put("email", nullToEmpty(obj.address));

private String nullToEmpty(String arg) {
    return arg == null ? "" : arg;
}

edited Jun 3, 2016 at 13:21

answered Jun 3, 2016 at 13:05

numsu

4803 silver badges10 bronze badges

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

5 Comments

user3441151 Over a year ago

by using your code i have to check all values and write it with all json field, is that possible if i can use any json property if possible?

numsu Over a year ago

Updated my answer :) does it answer your question?

user3441151 Over a year ago

@namsu i think you check only null value, so can you check null or empty both?

numsu Over a year ago

If an empty String is given as a parameter to that function, it will just return the empty String as is.

user3441151 Over a year ago

@namsu can we have annotation like "@JsonInclude(Include.NULL)" in org.json?

Collectives™ on Stack Overflow

JAVA org.json not showing empty value

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related