List of usage examples for org.json.simple JSONArray add
public boolean add(E e)
From source file:eumetsat.pn.common.ISO2JSON.java
/** * Parse the hierarchy name to tentatively form facets * * @param hierarchyNames/*from ww w .j a v a 2 s .co m*/ */ @SuppressWarnings("unchecked") private JSONObject parseThemeHierarchy(String fid, JSONArray hierarchyNames) { String dummy = null; JSONObject jsonObject = new JSONObject(); for (Object hName : hierarchyNames) { dummy = (String) hName; String[] elems = dummy.split("\\."); // log.trace("Analyze " + dummy); if (elems[0].equalsIgnoreCase("sat")) { if (elems[1].equalsIgnoreCase("METOP")) { jsonObject.put("satellite", "METOP"); if (elems.length > 2) { //there is an instrument jsonObject.put("instrument", elems[2]); } } else if (elems[1].startsWith("JASON")) { jsonObject.put("satellite", elems[1]); if (elems.length > 2) { //there is an instrument jsonObject.put("instrument", elems[2]); } } else { jsonObject.put("satellite", elems[1]); } } else if (elems[0].equalsIgnoreCase("theme")) { if (elems[1].equalsIgnoreCase("par") && elems.length > 2) { if (elems[2].equalsIgnoreCase("sea_surface_temperature")) { elems[2] = "sst"; } else if (elems[2].equalsIgnoreCase("level_0_data")) { elems[2] = "level0 "; } else if (elems[2].equalsIgnoreCase("level_1_data")) { elems[2] = "level1"; } else if (elems[2].equalsIgnoreCase("level_2_data")) { elems[2] = "level2"; } if (!jsonObject.containsKey("category")) { JSONArray array = new JSONArray(); array.add(elems[2]); jsonObject.put("category", array); } else { ((JSONArray) (jsonObject.get("category"))).add(elems[2]); } } } else if (elems[0].equalsIgnoreCase("dis")) { if (elems.length == 2) { if (!elems[1].equalsIgnoreCase("Eumetcast")) { if (!jsonObject.containsKey("distribution")) { JSONArray array = new JSONArray(); array.add(elems[1]); jsonObject.put("distribution", array); } else { ((JSONArray) (jsonObject.get("distribution"))).add(elems[1]); } } } else { log.debug("*** ALERT ALERT. DIS is different: " + hName); } } else if (elems[0].equalsIgnoreCase("SBA")) { if (elems.length == 2) { if (!jsonObject.containsKey("societalBenefitArea")) { JSONArray array = new JSONArray(); array.add(elems[1]); jsonObject.put("societalBenefitArea", array); } else { ((JSONArray) (jsonObject.get("societalBenefitArea"))).add(elems[1]); } } else { log.debug("*** ALERT ALERT. SBA is different: " + hName); } } } return jsonObject; }
From source file:modelo.ParametrizacionManagers.TiposContactos.java
/** * SELECT/* w w w .j ava 2 s . c o m*/ * Obtiene la informacion de una unidad de medida y * guarda todo en un JSONArray para entregarselo a la vista. * * @return JSONArray * @throws SQLException */ public JSONArray getTiposContactos(String descripcion) throws Exception { //Ejecutamos la consulta y obtenemos el ResultSet SeleccionarTiposContactos seleccionar = new SeleccionarTiposContactos(); ResultSet rst = seleccionar.getTiposContactos(descripcion); //Creamos los JSONArray para guardar los objetos JSON JSONArray jsonArray = new JSONArray(); JSONObject jsonObject = new JSONObject(); JSONArray jsonArreglo = new JSONArray(); while (rst.next()) { //Creamos el objecto JSON jsonObject.put("descripcion", rst.getString("DESCRIPCION")); jsonObject.put("codigo", rst.getString("CODIGO")); //Creamos el Array JSON jsonArray.add(jsonObject.clone()); } jsonArreglo.add(jsonArray); seleccionar.desconectar(); return jsonArreglo; }
From source file:net.duckling.ddl.web.controller.JoinPublicTeamController.java
/** * ???// ww w .j a v a 2s.c o m * @param size * @return */ private JSONArray initStatusMap(int size) { JSONArray maps = new JSONArray(); for (int i = 0; i < size; i++) { JSONObject obj = new JSONObject(); obj.put("status", OUTSIDE); obj.put("reason", ""); maps.add(obj); } return maps; }
From source file:modelo.ParametrizacionManagers.MotivosVisitas.java
/** * SELECT/* www . j av a 2 s . c om*/ * Obtiene la informacion de una unidad de medida y * guarda todo en un JSONArray para entregarselo a la vista. * * @return JSONArray * @throws SQLException */ public JSONArray getMotivosVisitas(String descripcion) throws Exception { //Ejecutamos la consulta y obtenemos el ResultSet SeleccionarMotivosVisitas seleccionar = new SeleccionarMotivosVisitas(); ResultSet rst = seleccionar.getMotivosVisitas(descripcion); //Creamos los JSONArray para guardar los objetos JSON JSONArray jsonArray = new JSONArray(); JSONObject jsonObject = new JSONObject(); JSONArray jsonArreglo = new JSONArray(); while (rst.next()) { //Creamos el objecto JSON jsonObject.put("descripcion", rst.getString("DESCRIPCION")); jsonObject.put("codigo", rst.getString("CODIGO")); //Creamos el Array JSON jsonArray.add(jsonObject.clone()); } seleccionar.desconectar(); jsonArreglo.add(jsonArray); return jsonArreglo; }
From source file:com.piusvelte.hydra.ConnectionManager.java
@SuppressWarnings("unchecked") JSONObject getDatabases() {/*from ww w . j ava 2 s .co m*/ JSONObject response = new JSONObject(); JSONArray rows = new JSONArray(); synchronized (databaseLock) { Set<String> databases = sDatabaseSettings.keySet(); Iterator<String> iter = databases.iterator(); while (iter.hasNext()) { JSONArray rowData = new JSONArray(); rowData.add(iter.next()); rows.add(rowData); } } response.put("result", rows); return response; }
From source file:net.matthewauld.racetrack.server.WrSQL.java
@SuppressWarnings("unchecked") public String getRaceDates(String year, int classID) { try {// w ww. j ava 2 s . c om connect(); st = con.createStatement(); rs = st.executeQuery("SELECT `date` FROM `wcmcpoints` WHERE `date` LIKE '" + year + "%' AND `isCMA` = '1' GROUP BY `date`"); JSONObject json = new JSONObject(); JSONArray dates = new JSONArray(); while (rs.next()) { dates.add(rs.getString("date")); } json.put("dates", dates); // Rider Information JSONArray riders = new JSONArray(); st = con.createStatement(); rs = st.executeQuery("SELECT `rid` FROM `wcmcpoints` WHERE `isCMA` = '1' AND `cid` = '" + classID + "' GROUP BY `rid`"); while (rs.next()) { JSONObject riderInfo = new JSONObject(); Statement pointsSumQuery = con.createStatement(); ResultSet points = pointsSumQuery .executeQuery("SELECT SUM(points) FROM `wcmcpoints` WHERE `isCMA` = '1' AND `rid` = '" + rs.getInt("rid") + "' AND `cid` = '" + classID + "'"); if (points.next()) { riderInfo.put("totalPoints", points.getInt("SUM(points)")); } riderInfo.put("id", rs.getInt("rid")); Statement riderQuery = con.createStatement(); ResultSet riderDetails = riderQuery .executeQuery("SELECT * FROM `riders` WHERE `id` = '" + rs.getInt("rid") + "'"); if (riderDetails.next()) { riderInfo.put("first_name", riderDetails.getString("first_name")); riderInfo.put("last_name", riderDetails.getString("last_name")); riderInfo.put("license", riderDetails.getString("license")); riderInfo.put("city", riderDetails.getString("city_text")); riderInfo.put("sponsors", riderDetails.getString("sponsors_old")); Statement classQuery = con.createStatement(); ResultSet classDetails = classQuery.executeQuery("SELECT * FROM `ridersclasses` WHERE `rid` = '" + riderDetails.getInt("id") + "' AND `cid` = '" + classID + "'"); if (classDetails.next()) { JSONObject bike = new JSONObject(); bike.put("plate", classDetails.getInt("bike_number")); bike.put("brand", classDetails.getString("bike_brand")); riderInfo.put("bike", bike); } else { riderInfo.put("bike", null); } classDetails = classQuery.executeQuery("SELECT * FROM `wcmcpoints` WHERE `rid` = '" + riderDetails.getInt("id") + "' AND `cid` = '" + classID + "' AND `isCMA` = '1'"); JSONArray events = new JSONArray(); while (classDetails.next()) { JSONObject event = new JSONObject(); event.put("date", classDetails.getString("date")); event.put("position", classDetails.getInt("position")); event.put("points", classDetails.getInt("points")); events.add(event); } riderInfo.put("events", events); riders.add(riderInfo); } } json.put("riders", riders); return json.toJSONString(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; }
From source file:dk.magenta.rm.scripts.datalists.LayoutManager.java
private org.json.simple.JSONArray getCustomTypes() { PagingResults<CustomModelDefinition> modelDefinitionPagingResults = customModelService .getCustomModels(new PagingRequest(100)); Iterator it = modelDefinitionPagingResults.getPage().iterator(); while (it.hasNext()) { CustomModelDefinition cmd = (CustomModelDefinition) it.next(); }//from w w w . j a v a2 s. com PagingResults<TypeDefinition> customModelServiceAllCustomTypes = customModelService .getAllCustomTypes(new PagingRequest(100)); org.json.simple.JSONArray result = new org.json.simple.JSONArray(); it = customModelServiceAllCustomTypes.getPage().iterator(); while (it.hasNext()) { JSONObject model = new JSONObject(); TypeDefinition cmd = (TypeDefinition) it.next(); try { model.put("model", cmd.getModel().getName()); model.put("type", cmd.getName()); result.add(model); } catch (JSONException e) { e.printStackTrace(); } } return result; }
From source file:eclserver.threads.EmergencyNotifyPush.java
private String getJsonString(String machineName, String confirmURL) { JSONObject m1 = new JSONObject(); m1.clear();/*w w w .j a va2 s . co m*/ JSONArray list1 = new JSONArray(); try { m1.put("details", enPanel.getNotifyDetails()); m1.put("acknowledgeurl", confirmURL + "?MyMessage=EmergencyNotificationAcknowledged"); list1.add(m1); } catch (Exception ex) { // ex.printStackTrace(); } String jsonString = "{\"Source\":[{\"machinename\":\"" + machineName + "\"}],"; jsonString += "\"Confirmation\":[{\"url\":\"" + confirmURL + "\"}],"; jsonString += "\"EmergencyCall\":" + list1.toString() + "}"; System.out.println("Call JSON: " + jsonString); return jsonString; }
From source file:com.intbit.dao.ScheduleSocialPostDAO.java
public static JSONArray getScheduledActionsfacebook(int userid) throws SQLException { JSONObject json_action_facebook = new JSONObject(); JSONArray json_array_facebook = new JSONArray(); String query = "Select * from tbl_scheduled_entity_list" + " where entity_id=?" + " and entity_type =?" + " and user_id = ?"; try (Connection conn = connectionManager.getConnection(); PreparedStatement ps = conn.prepareStatement(query)) { ps.setInt(1, 0);/*from w w w . j a va2s . c o m*/ ps.setString(2, "facebook"); ps.setInt(3, userid); try (ResultSet result_set = ps.executeQuery()) { while (result_set.next()) { JSONObject json_object = new JSONObject(); Integer id = result_set.getInt("id"); String schedule_title = result_set.getString("schedule_title"); String schedule_desc = result_set.getString("schedule_desc"); Timestamp scheduleTimestamp = result_set.getTimestamp("schedule_time"); long scheduleTime = scheduleTimestamp.getTime(); json_object.put("id", id); json_object.put("schedule_title", schedule_title); json_object.put("schedule_desc", schedule_desc); json_object.put("schedule_time", scheduleTime); json_array_facebook.add(json_object); } } } return json_array_facebook; }
From source file:com.intbit.dao.ScheduleSocialPostDAO.java
public static JSONArray getScheduledActionstwitter(int userid) throws SQLException { JSONObject json_action_facebook = new JSONObject(); JSONArray json_array_twitter = new JSONArray(); String query = "Select * from tbl_scheduled_entity_list" + " where entity_id=?" + " and entity_type =?" + " and user_id = ?"; try (Connection conn = connectionManager.getConnection(); PreparedStatement ps = conn.prepareStatement(query)) { ps.setInt(1, 0);//w w w. jav a2 s.c om ps.setString(2, "twitter"); ps.setInt(3, userid); try (ResultSet result_set = ps.executeQuery()) { while (result_set.next()) { JSONObject json_object = new JSONObject(); Integer id = result_set.getInt("id"); String schedule_title = result_set.getString("schedule_title"); String schedule_desc = result_set.getString("schedule_desc"); Timestamp scheduleTimestamp = result_set.getTimestamp("schedule_time"); long scheduleTime = scheduleTimestamp.getTime(); json_object.put("id", id); json_object.put("schedule_title", schedule_title); json_object.put("schedule_desc", schedule_desc); json_object.put("schedule_time", scheduleTime); json_array_twitter.add(json_object); } } } return json_array_twitter; }