public JSONArray GetRestaurantsNearLoation(double lat, double lon) {
try {
if (conn == null) {
return null;
}
Statement stmt = conn.createStatement();
String sql =
"SELECT business_id, name, full_address, categories, stars, latitude, longitude, city, state from RESTAURANTS LIMIT 10";
// execute query expect result set
ResultSet rs = stmt.executeQuery(sql);
List<JSONObject> list = new ArrayList<JSONObject>();
while (rs.next()) {
JSONObject obj = new JSONObject();
obj.append("business_id", rs.getString("business_id"));
obj.append("name", rs.getString("name"));
obj.append("stars", rs.getFloat("stars"));
obj.append("latitude", rs.getFloat("latitude"));
obj.append("longitude", rs.getFloat("longitude"));
obj.append("full_address", rs.getString("full_address"));
obj.append("city", rs.getString("city"));
obj.append("state", rs.getString("state"));
obj.append("categories", DBImport.stringToJSONArray(rs.getString("categories")));
list.add(obj);
}
return new JSONArray(list);
} catch (Exception e) {
/* report an error */
System.out.println(e.getMessage());
}
return null;
}
private JSONObject getRestaurantsById(String businessId) {
try {
Statement stmt = conn.createStatement();
String sql =
"SELECT business_id, name, full_address, categories, stars, latitude, longitude, city, state, image_url from "
+ "RESTAURANTS where business_id='"
+ businessId
+ "'"
+ " ORDER BY stars DESC";
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
JSONObject obj = new JSONObject();
obj.append("business_id", rs.getString("business_id"));
obj.append("name", rs.getString("name"));
obj.append("stars", rs.getFloat("stars"));
obj.append("latitude", rs.getFloat("latitude"));
obj.append("longitude", rs.getFloat("longitude"));
obj.append("full_address", rs.getString("full_address"));
obj.append("city", rs.getString("city"));
obj.append("state", rs.getString("state"));
obj.append("categories", DBImport.stringToJSONArray(rs.getString("categories")));
obj.append("image_url", rs.getString("image_url"));
return obj;
}
} catch (Exception e) {
/* report an error */
System.out.println(e.getMessage());
}
return null;
}