Create json array with hashtable in java

Question

I'm a little confused on how to construct associative arrays from a hashtable in java with either JSONObject() or the gson library from google.

Any help on this is appreciated!

    JSONObject message = new JSONObject();
    Map<String,String> responseData = new Hashtable<String, String>();

[...]

    ResultSet results = getApprovalCount.executeQuery();

    while (results.next()) {
        responseData.put("vote" + results.getString("submission_id"), results.getString("counter"));
    }

[...]

    message.put("submissions", responseData);

Result:

{"submissions":{"vote1":"2","vote7":"1","vote25":"1","vote6":"1","vote13":"1","vote9":"1","vote11":"1"}}

Desired result:

{"submissions":[{"vote1":"2"},{"vote7":"1"},{"vote25":"1"},{"vote6":"1"},{"vote13":"1"},{"vote9":"1"},{"vote11":"1"}]}

Oh, ok, i've seen the update.

uraimo
– uraimo

2015-03-17 14:41:20 +00:00
Commented Mar 17, 2015 at 14:41 — uraimo
– uraimo, Commented Mar 17, 2015 at 14:41

Luc Laverdure · Accepted Answer · 2015-03-17 14:52:43Z

2

Figured it out...!

  JSONObject message = new JSONObject();
  ArrayList<Map<String,String>> responseData = new ArrayList<Map<String,String>>();
  User user = new User(request);

[...]

    while (results.next()) {
        Map<String,String> tmpdata = new Hashtable<String, String>();
        tmpdata.put("vote" + results.getString("submission_id"), results.getString("counter"));
        responseData.add(tmpdata);
    }

[...]

    message.put("submissions", responseData);

answered Mar 17, 2015 at 14:52

Luc Laverdure

1,5002 gold badges21 silver badges39 bronze badges

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

1 Comment

uraimo Over a year ago

Correct, that's a list of objects with one field, didn't read too closely your update.

Collectives™ on Stack Overflow

Create json array with hashtable in java

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related