Example usage for org.json.simple JSONArray add

List of usage examples for org.json.simple JSONArray add

Introduction

In this page you can find the example usage for org.json.simple JSONArray add.

Prototype

public boolean add(E e) 

Source Link

Document

Appends the specified element to the end of this list.

Usage

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;
}