List of usage examples for org.json.simple JSONArray get
public E get(int index)
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(); }