java - reformat json from database query -
this current
[{ "year": "2015", "org_name": "mooe", "suborg_name": "forms expenses", "amt": "2", "org_id": "4", "suborg_id": "24" }, { "year": "2016", "org_name": "mooe", "suborg_name": "forms expenses", "amt": "1", "org_id": "4", "suborg_id": "24" }]
i want format
[{ "org_name": "mooe", "suborg_name": "forms expenses", "suborg_id": "24", "org_id": "4", "year": [{ "year": "2015", "amt": "2" }, { "year": "2016", "amt": "1" }] }]
below how current values:
list<string> list = new arraylist<string>(); while (rs2.next()) { jsonobject json = new jsonobject(); if (!rs2.getstring("suborg_id").isempty()) { json.put("org_name", org_name); json.put("year", year); json.put("suborg_name", suborg_name); json.put("amt", amt); json.put("org_id", org_id); json.put("suborg_id", suborg_id); } finaljson2.put(counter2, json.tostring()); counter2++; list.add("" + json + ""); } //out.println("[" + finaljson2.tostring() + "]"); out.println(list);
i put in if statement hoping group same suborg_id
update
tried adding year , amount new array before pushing json like
list<string> list = new arraylist<string>(); while (rs2.next()) { jsonobject json = new jsonobject(); jsonobject json1 = new jsonobject(); if (!rs2.getstring("suborg_id").isempty()) { json.put("year", year); json.put("amt", amt); json.put("org_name", org_name); json.put("suborg_name", suborg_name); json.put("org_id", org_id); json.put("suborg_id", suborg_id); json.put("year", json1); } finaljson2.put(counter2, json.tostring()); counter2++; list.add("" + json + ""); } //out.println("[" + finaljson2.tostring() + "]"); out.println(list);
my ouput looks like:
[{ "org_name": "mooe", "suborg_name": "forms expenses", "org_id": "4", "suborg_id": "24", "year": { "year": "2015", "amt": "2" } }, { "org_name": "mooe", "suborg_name": "forms expenses", "org_id": "4", "suborg_id": "24", "year": { "year": "20165", "amt": "1" } }]
my aim format
[{ "org_name": "mooe", "suborg_name": "forms expenses", "suborg_id": "24", "org_id": "4", "year": [{ "year": "2015", "amt": "2" }, { "year": "2016", "amt": "1" }] }]
try
list<string> list = new arraylist<string>(); while (rs2.next()) { jsonobject json = new jsonobject(); if (!rs2.getstring("suborg_id").isempty()) { json.put("org_name", org_name); json.put("suborg_name", suborg_name); json.put("org_id", org_id); json.put("suborg_id", suborg_id); json.put("year"); [{ json.put("year", year); json.put("amt", amt); },{ json.put("year", year); json.put("amt", amt); }] } finaljson2.put(counter2, json.tostring()); counter2++; list.add("" + json + ""); }
Comments
Post a Comment