@SuppressWarnings("unchecked") private String searchAndReturnDatainJSONFormat( String sLong, String sLat, String radius, String result) { String query = ""; String retValue = ""; PersistenceManager pm = PMF.get().getPersistenceManager(); StringBuffer sb = new StringBuffer(100); sb.append("http://ws.geonames.net/findNearbyPostalCodesJSON?lat="); sb.append(sLat); sb.append("&lng="); sb.append(sLong); sb.append("&radius="); sb.append(radius); sb.append("&maxRows=100"); sb.append("&username="******"URL:" + sb); String JSONResult = callServletToGetData(url); String zipCodeArray[] = null; Integer iResult = new Integer(result); String state = parseJSONDatatoGetState(JSONResult); zipCodeArray = parseJSONData(JSONResult); ArrayList beanList = new ArrayList(); HashMap containsMap = new HashMap(); List<EPAToxicDataBean> xmlDataList = null; try { if (zipCodeArray != null) { int resultCounter = 0; System.out.println("Startime" + new Date()); for (String zipCode : zipCodeArray) { if (resultCounter >= iResult) { break; } query = "LocationZIPCode =='" + zipCode + "'"; System.out.println("Executing Query:" + query); xmlDataList = (List<EPAToxicDataBean>) pm.newQuery(EPAToxicDataBean.class, query).execute(); if (xmlDataList != null) { for (EPAToxicDataBean rec : xmlDataList) { if (resultCounter < iResult) { if (!containsMap.containsKey(rec.getFacilityregistryId())) { beanList.add(rec); containsMap.put(rec.getFacilityregistryId(), 0); ++resultCounter; System.out.println("ResultSize time:" + beanList.size()); } else { continue; } } else { break; } } } } } if (beanList.size() > 0) { retValue = new JSONSerializer().include("*").serialize("EPAData", beanList); } } catch (Exception exec) { System.out.println("Error" + exec.getMessage()); System.out.println("Error at time" + new Date()); } finally { JsonReturnValueForIphone = new JSONSerializer().include("*").serialize("EPAData", beanList); } return retValue; }
@SuppressWarnings("unchecked") private String searchAndReturnDatainJSONFormatForWebApp( String sLong, String sLat, String radius, String result) { String query = ""; String retValue = ""; PersistenceManager pm = PMF.get().getPersistenceManager(); StringBuffer sb = new StringBuffer(100); sb.append("http://ws.geonames.net/findNearbyPostalCodesJSON?lat="); sb.append(sLat); sb.append("&lng="); sb.append(sLong); sb.append("&radius="); sb.append(radius); sb.append("&maxRows=100"); sb.append("&username="******"URL:" + sb); String JSONResult = callServletToGetData(url); String zipCodeArray[] = null; Integer iResult = new Integer(result); String state = parseJSONDatatoGetState(JSONResult); zipCodeArray = parseJSONData(JSONResult); ArrayList beanList = new ArrayList(); List<EPAToxicDataBean> xmlDataList = null; try { if (zipCodeArray != null) { int resultCounter = 0; System.out.println("Startime" + new Date()); HashMap containsMap = new HashMap(); for (String zipCode : zipCodeArray) { if (resultCounter >= iResult) { break; } query = "SELECT FROM com.mycompany.sampleProject.server.EPAToxicDataBean " + "where LocationZIPCode.startsWith(tradeName) " + "parameters String tradeName"; System.out.println("Executing Query:" + query); xmlDataList = (List<EPAToxicDataBean>) pm.newQuery(query).execute(zipCode); if (xmlDataList != null) { for (EPAToxicDataBean rec : xmlDataList) { if (resultCounter < iResult) { if (!containsMap.containsKey(rec.getFacilityregistryId())) { beanList.add(rec); ++resultCounter; containsMap.put(rec.getFacilityregistryId(), 0); System.out.println("ResultSize time:" + beanList.size()); } else { continue; } } else { break; } } } } } if (beanList.size() > 0) { StringBuffer retValuBuffer = new StringBuffer(8000); retValuBuffer.append("["); int beanCounter = 0; for (int i = 0; i < beanList.size(); ++i) { org.json.JSONObject jsonObject = new org.json.JSONObject(beanList.get(i)); retValuBuffer.append(jsonObject.toString()); if ((beanCounter != beanList.size() - 1) && beanList.size() > 1) { retValuBuffer.append(","); } ++beanCounter; } retValuBuffer.append("]"); retValue = retValuBuffer.toString(); } } catch (Exception exec) { System.out.println("Error" + exec.getMessage()); System.out.println("Error at time" + new Date()); } finally { StringBuffer retValuBuffer = new StringBuffer(8000); retValuBuffer.append("["); int beanCounter = 0; for (int i = 0; i < beanList.size(); ++i) { org.json.JSONObject jsonObject = new org.json.JSONObject(beanList.get(i)); retValuBuffer.append(jsonObject.toString()); if ((beanCounter != beanList.size() - 1) && beanList.size() > 1) { retValuBuffer.append(","); } ++beanCounter; } retValuBuffer.append("]"); JsonReturnValueForIphone = retValuBuffer.toString(); } return retValue; }