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

Popular posts from this blog

mysql - Dreamhost PyCharm Django Python 3 Launching a Site -

java - Sending SMS with SMSLib and Web Services -

python 3.5 - Pyqtgraph string in x tick -