Example usage for org.json.simple JSONArray get

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

Introduction

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

Prototype

public E get(int index) 

Source Link

Document

Returns the element at the specified position in this list.

Usage

From source file:luceneindexdemo.LuceneIndexDemo.java

public static void missOperation(String type)
        throws FileNotFoundException, IOException, org.json.simple.parser.ParseException, SQLException {
    //JSONObject jsObject=new JSONObject();
    System.out.println("this brings out all your connection with the person you miss");
    String query = "match (n:People)-[r:KNOWS]-(b:People) where n.name='" + user + "' and r.relType='" + type
            + "' return filter(x in n.interest where x in b.interest) as common,b.name";
    Connection con = DriverManager.getConnection("jdbc:neo4j://localhost:7474/");
    ResultSet rs = con.createStatement().executeQuery(query);
    JSONParser jsParser = new JSONParser();
    FileReader freReader = new FileReader("/home/rishav12/NetBeansProjects/LuceneIndexDemo/location.json");
    JSONObject jsono = (JSONObject) jsParser.parse(freReader);
    JSONArray jslocArray = (JSONArray) jsono.get("CHENNAI");
    int count = 0;
    while (rs.next()) {
        System.out.println(rs.getString("b.name"));
        String searchQuery = "start n=node:restaurant('withinDistance:[" + jslocArray.get(0) + ","
                + jslocArray.get(1) + ",13.5]') where ";
        JSONArray jsArray = (JSONArray) jsParser.parse(rs.getString("common"));
        Iterator<JSONArray> iterJsArray = jsArray.iterator();

        count++;//from  w ww  .  j  a v a 2 s . c  om
        int k = 0;
        int flag = 0;
        while (iterJsArray.hasNext()) {
            flag = 1;
            if (k == 0) {
                searchQuery = searchQuery + "n.type='" + iterJsArray.next() + "'";
                k = k + 1;

            } else
                searchQuery = searchQuery + " or n.type='" + iterJsArray.next() + "'";
        }

        if (flag == 1) {
            searchQuery += " return n.name,n.type";
            ResultSet commonInterest = con.createStatement().executeQuery(searchQuery);
            System.out.println("Sir based on your common interests with " + rs.getString("b.name")
                    + " \ni will plan out something nearby you");
            while (commonInterest.next()) {
                System.out
                        .println(commonInterest.getString("n.name") + " " + commonInterest.getString("n.type"));
            }
        } else {
            System.err.println("you do not seem to share any common interest with" + rs.getString("b.name"));
        }

    }
    return;

}

From source file:gov.nasa.jpl.xdata.nba.impoexpo.parse.ParseUtil.java

public static GameInfo parseInfo(JSONObject jsonObject) {
    JSONArray resultSets = (JSONArray) jsonObject.get("resultSets");
    JSONObject infoObject = (JSONObject) resultSets.get(8);
    JSONArray rowSet = (JSONArray) infoObject.get("rowSet");
    JSONArray row = (JSONArray) rowSet.get(0);
    String gameDate = (String) row.get(0);
    long attendance = (Long) row.get(1);
    String gameTime = (String) row.get(2);
    return GameInfo.newBuilder().setGameDate(gameDate).setAttendance(attendance).setGameTime(gameTime).build();
}

From source file:jGPIO.DTO.java

public static JSONObject findDetails(String gpio_name) {
    // Do we have a valid definition file, or should we just direct map?
    if (pinDefinitions == null) {
        autoDetectSystemFile();//  www  .j  a  v  a  2  s.  c o m
    }
    if (pinDefinitions == null) {
        System.out.println("No definitions file found, assuming direct mapping");
        return null;
    }
    for (Object obj : pinDefinitions) {
        JSONObject jObj = (JSONObject) obj;
        String key = (String) jObj.get("key");
        if (key.equalsIgnoreCase(gpio_name)) {
            return jObj;
        }
        if (jObj.containsKey("options")) {
            JSONArray options = (JSONArray) jObj.get("options");
            for (int i = 0; i < options.size(); i++) {
                String option = (String) options.get(i);
                if (option.equalsIgnoreCase(gpio_name)) {
                    return jObj;
                }
            }
        }
    }

    // not found
    return null;
}

From source file:gov.nasa.jpl.xdata.nba.impoexpo.parse.ParseUtil.java

public static List<Officials> parseOfficials(JSONObject jsonObject) {
    JSONArray resultSets = (JSONArray) jsonObject.get("resultSets");
    JSONObject infoObject = (JSONObject) resultSets.get(7);
    JSONArray rowSet = (JSONArray) infoObject.get("rowSet");
    List<Officials> result = new ArrayList<Officials>();
    for (Object rowObject : rowSet) {
        JSONArray row = (JSONArray) rowObject;
        result.add(Officials.newBuilder().setOfficialId(row.get(0) == null ? -1 : (Long) row.get(0))
                .setOfficialFirstName(row.get(1) == null ? "" : (String) row.get(1))
                .setOfficialLastName(row.get(2) == null ? "" : (String) row.get(2))
                .setOfficialJerseyNum(row.get(3) == null ? -1 : Long.parseLong(row.get(3).toString().trim()))
                .build());/*from  w  w  w  .j a va 2 s  .c om*/
    }
    return result;
}

From source file:gov.nasa.jpl.xdata.nba.impoexpo.parse.ParseUtil.java

public static SeasonSeries parseSeasonSeries(JSONObject jsonObject) {
    JSONArray resultSets = (JSONArray) jsonObject.get("resultSets");
    JSONObject infoObject = (JSONObject) resultSets.get(2);
    JSONArray rowSet = (JSONArray) infoObject.get("rowSet");
    JSONArray row = (JSONArray) rowSet.get(0);
    long seriesId = Long.parseLong(row.get(0).toString().trim());
    long homeTeamId = (Long) row.get(1);
    long visitorTeamId = (Long) row.get(2);
    String seriesDateEst = (String) row.get(3);
    long homeTeamWins = (Long) row.get(4);
    long homeTeamLosses = (Long) row.get(5);
    String seriesLeader = (String) row.get(6);
    return SeasonSeries.newBuilder().setGameSeasonSeriesId(seriesId).setSeasonSeriesHomeTeamId(homeTeamId)
            .setSeasonSeriesVisitorTeamId(visitorTeamId).setGameSeasonSeriesDateEst(seriesDateEst)
            .setHomeTeamWins(homeTeamWins).setHomeTeamLosses(homeTeamLosses).setSeriesLeader(seriesLeader)
            .build();//from w w w  .ja v  a2  s.  c  om
}

From source file:gov.nasa.jpl.xdata.nba.impoexpo.parse.ParseUtil.java

public static AvailableVideo parseAvailableVideo(JSONObject jsonObject) {
    JSONArray resultSets = (JSONArray) jsonObject.get("resultSets");
    JSONObject availableVideoObject = (JSONObject) resultSets.get(10);
    JSONArray rowSet = (JSONArray) availableVideoObject.get("rowSet");
    JSONArray row = (JSONArray) rowSet.get(0);
    return AvailableVideo.newBuilder().setVideoAvailableFlag((Long) row.get(0)).build();
}

From source file:gov.nasa.jpl.xdata.nba.impoexpo.parse.ParseUtil.java

public static List<LineScore> parseLineScore(JSONObject jsonObject) {
    JSONArray resultSets = (JSONArray) jsonObject.get("resultSets");
    JSONObject infoObject = (JSONObject) resultSets.get(1);
    JSONArray rowSet = (JSONArray) infoObject.get("rowSet");
    List<LineScore> result = new ArrayList<LineScore>();
    for (int i = 0; i < 2; i++) {
        JSONArray row = (JSONArray) rowSet.get(i);
        result.add(LineScore.newBuilder().setGameLineScoreDateEst((String) row.get(0))
                .setGameLineScoreSequence((Long) row.get(1))
                .setGameLineScoreId(Long.parseLong((String) row.get(2))).setLineScoreTeamId((Long) row.get(3))
                .setLineScoreTeamAbbreviation((String) row.get(4)).setTeamCityName((String) row.get(5))
                .setTeamWinsLosses((String) row.get(6)).setPtsQtr1((Long) row.get(7))
                .setPtsQtr2((Long) row.get(8)).setPtsQtr3((Long) row.get(9)).setPtsQtr4((Long) row.get(10))
                .setPtsOt1((Long) row.get(11)).setPtsOt2((Long) row.get(12)).setPtsOt3((Long) row.get(13))
                .setPtsOt4((Long) row.get(14)).setPtsOt5((Long) row.get(15)).setPtsOt6((Long) row.get(16))
                .setPtsOt7((Long) row.get(17)).setPtsOt8((Long) row.get(18)).setPtsOt9((Long) row.get(19))
                .setPtsOt10((Long) row.get(20)).setLineScorePts((Long) row.get(21)).build());
    }//w  w w . java 2 s .  c  o  m
    return result;
}

From source file:gov.nasa.jpl.xdata.nba.impoexpo.parse.ParseUtil.java

public static List<OtherStats> parseOtherStats(JSONObject jsonObject) {
    JSONArray resultSets = (JSONArray) jsonObject.get("resultSets");
    JSONObject infoObject = (JSONObject) resultSets.get(6);
    JSONArray rowSet = (JSONArray) infoObject.get("rowSet");
    List<OtherStats> result = new ArrayList<OtherStats>();
    for (Object rowObject : rowSet) {
        JSONArray row = (JSONArray) rowObject;
        result.add(OtherStats.newBuilder()
                .setLeagueId(row.get(0) == null ? -1 : Long.parseLong(row.get(0).toString().trim()))
                .setSeasonId(row.get(1) == null ? -1 : Long.parseLong(row.get(1).toString().trim()))
                .setOtherStatsTeamId(row.get(2) == null ? -1 : (Long) row.get(2))
                .setOtherStatsTeamAbbreviation(row.get(3) == null ? "" : (String) row.get(3))
                .setOtherStatsTeamCity(row.get(4) == null ? "" : (String) row.get(4))
                .setPtsPaint(row.get(5) == null ? -1 : (Long) row.get(5))
                .setPts2ndChance(row.get(6) == null ? -1 : (Long) row.get(6))
                .setPtsFb(row.get(7) == null ? -1 : (Long) row.get(7))
                .setLargestLead(row.get(8) == null ? -1 : (Long) row.get(8))
                .setLeadChanges(row.get(9) == null ? -1 : (Long) row.get(9))
                .setTimesTied(row.get(10) == null ? -1 : (Long) row.get(10)).build());
    }//from w w w .  j a  v  a  2s  . c o m
    return result;
}

From source file:freebase.api.FreebaseAPI.java

public static List<Film> encodeJSON(JSONArray results) {
    List<Film> films = new ArrayList<>();
    for (Object flmObj : results) {
        JSONObject flmJObj = (JSONObject) flmObj;
        Film film = new Film(getId((String) flmJObj.get("mid"), film_map), (String) flmJObj.get("mid"),
                (String) flmJObj.get("name"));

        JSONArray directed_by_arr = (JSONArray) flmJObj.get("directed_by");
        JSONObject directed_by = (JSONObject) directed_by_arr.get(0);
        Directedby directedby = new Directedby();
        directedby.setId(directedbyIDs.next());

        Director director = new Director(getId((String) directed_by.get("mid"), director_map),
                (String) directed_by.get("mid"), (String) directed_by.get("name"));
        directedby.setDirector(director);
        film.setDirectedBy(directedby);//from  w  w  w  .j  ava 2 s  .  c o  m

        JSONArray starrings = (JSONArray) flmJObj.get("starring");
        for (Object starringObj : starrings) {
            JSONObject starringJObj = (JSONObject) starringObj;
            Starring starring = new Starring();
            starring.setMid((String) starringJObj.get("mid"));
            starring.setId(getId((String) starringJObj.get("mid"), starring_map));

            JSONArray actorJObj_arr = (JSONArray) starringJObj.get("actor");
            JSONObject actorJObj = (JSONObject) actorJObj_arr.get(0);
            Actor actor = new Actor(getId((String) actorJObj.get("mid"), actor_map),
                    (String) actorJObj.get("mid"), (String) actorJObj.get("name"));
            starring.setActor(actor);

            JSONArray characterJObj_arr = (JSONArray) starringJObj.get("character");
            JSONObject characterJObj = (JSONObject) characterJObj_arr.get(0);
            freebase.api.entity.movie.FCharacter character = new freebase.api.entity.movie.FCharacter(
                    getId((String) characterJObj.get("mid"), character_map), (String) characterJObj.get("mid"),
                    (String) characterJObj.get("name"));
            starring.setCharacter(character);

            film.addStarring(starring);
        }

        films.add(film);
    }
    return films;
}

From source file:gov.nasa.jpl.xdata.nba.impoexpo.parse.ParseUtil.java

public static LastMeeting parseLastMeeting(JSONObject jsonObject) {
    JSONArray resultSets = (JSONArray) jsonObject.get("resultSets");
    JSONObject infoObject = (JSONObject) resultSets.get(3);
    JSONArray rowSet = (JSONArray) infoObject.get("rowSet");
    JSONArray row = (JSONArray) rowSet.get(0);
    long gameLastMeetingId = Long.parseLong(row.get(0).toString().trim());
    long lastGameId = Long.parseLong(row.get(1).toString().trim());
    String lastGameDate = (String) row.get(2);
    long lastGameHomeTeamId = (Long) row.get(3);
    String lastGameHomeTeamCity = (String) row.get(4);
    String lastGameHomeTeamName = (String) row.get(5);
    String lastGameHomeTeamAbbreviation = (String) row.get(6);
    long lastGameHomeTeamPoints = (Long) row.get(7);
    long lastGameVisitorId = (Long) row.get(8);
    String lastGameVisitorCity = (String) row.get(9);
    String lastGameVisitorName = (String) row.get(10);
    String lastGameVisitorCity1 = (String) row.get(11);
    long lastGameVisitorPoints = (Long) row.get(12);
    return LastMeeting.newBuilder().setGameLastMeetingId(gameLastMeetingId).setLastGameId(lastGameId)
            .setLastGameDateEst(lastGameDate).setLastGameHomeTeamId(lastGameHomeTeamId)
            .setLastGameHomeTeamCity(lastGameHomeTeamCity).setLastGameHomeTeamName(lastGameHomeTeamName)
            .setLastGameHomeTeamAbbreviation(lastGameHomeTeamAbbreviation)
            .setLastGameHomeTeamPoints(lastGameHomeTeamPoints).setLastGameHomeTeamId(lastGameHomeTeamId)
            .setLastGameVisitorTeamId(lastGameVisitorId).setLastGameVisitorTeamCity(lastGameVisitorCity)
            .setLastGameVisitorTeamName(lastGameVisitorName).setLastGameVisitorTeamCity1(lastGameVisitorCity1)
            .setLastGameVisitorTeamPoints(lastGameVisitorPoints).build();
}