im 检索 JSON 数据数组并尝试打开和访问它。但是当我尝试显示它时,它只显示 JSON 数据数组中的最后一行。当我尝试做类似json1.get(2)(json1这里是包含JSONObject)的JSONArray时,我得到数组越界错误。请告诉我我做错了什么以及如何检索 JSON以下是此问题的相关代码。
谢谢。
im调用UserFunctions的getAllFreebies函数.java类从Freebies.java类
UserFunctions uf = new UserFunctions();
JSONObject json = uf.getAllFreebies();
下面是我的 getAllFreebies() 函数的代码来自 UserFunctions.java 类:
public JSONObject getAllFreebies(){
List<NameValuePair> params = new ArrayList<NameValuePair>();
params.add(new BasicNameValuePair("tag", getAllFreebies_tag));
JSONObject json = jsonParser.getJSONFromUrl(getAllFreebiesURL,params);
JSONArray json1 = new JSONArray();
json1.put(json);
try {
System.out.println(json1.get(2));
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return json;
}
下面是来自 index.php 类的代码,其中 im 调用DB_Functions.php类的 getFreebies() 函数
else if($tag = 'getAllFreebies'){
$username = "";
$catagory = "";
$subcatagory = "";
$title = "";
$condition = "";
$description = "";
$address = "";
$city = "";
$state = "";
$country = "";
$zipcode = "";
$posted_on= "";
$getAllFreebies = $db->getFreebies($username,$catagory,$subcatagory,$title,$condition,$description,$address,$city,$state,$country,$zipcode,$posted_on);
$data = array();
while($row = mysql_fetch_assoc($getAllFreebies)) {
$response["success"] = 1;
$data[] = array(
$response["getAllFreebies"]["username"] = $row["username"],
$response["getAllFreebies"]["catagory"] = $row["catagory"],
$response["getAllFreebies"]["subcatagory"] = $row["subcatagory"],
$response["getAllFreebies"]["title"] = $row["title"],
$response["getAllFreebies"]["item_condition"] = $row["item_condition"],
$response["getAllFreebies"]["description"] = $row["description"],
$response["getAllFreebies"]["address"] = $row["address"],
$response["getAllFreebies"]["city"] = $row["city"],
$response["getAllFreebies"]["state"] = $row["state"],
$response["getAllFreebies"]["country"] = $row["country"],
$response["getAllFreebies"]["zipcode"] = $row["zipcode"],
$response["getAllFreebies"]["posted_on"] = $row["posted_on"]);}
echo json_encode($response);
}// end of getAllFreebies tag
下面是 getFreebies() 函数的代码DB_Functions.php
public function getFreebies(){
$result = mysql_query("SELECT * FROM freebie") or die(mysql_error());
return($result);
}
更新:I在我的 JSONParser 类中添加了以下内容,以便解析 JSONArray public JSONArray getJSONArrayFromUrl(String url, List params) {
// Making HTTP request
try {
// defaultHttpClient
DefaultHttpClient httpClient = new DefaultHttpClient();
HttpPost httpPost = new HttpPost(url);
httpPost.setEntity(new UrlEncodedFormEntity(params));
HttpResponse httpResponse = httpClient.execute(httpPost);
HttpEntity httpEntity = httpResponse.getEntity();
is = httpEntity.getContent();
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
} catch (ClientProtocolException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
try {
BufferedReader reader = new BufferedReader(new InputStreamReader(
is, "iso-8859-1"), 8);
StringBuilder sb = new StringBuilder();
String line = null;
while ((line = reader.readLine()) != null) {
sb.append(line + "n");
}
is.close();
json = sb.toString();
Log.e("JSON", json);
} catch (Exception e) {
Log.e("Buffer Error", "Error converting result " + e.toString());
}
// try parse the string to a JSON object
try {
jObj = new JSONObject(json);
jarray.put(jObj);
} catch (JSONException e) {
Log.e("JSON Parser", "Error parsing data " + e.toString());
}
// return JSON String
return jarray;
}
我更改了getAllFreebie()以检索JSONArray
public JSONArray getAllFreebies() {
List<NameValuePair> params = new ArrayList<NameValuePair>();
params.add(new BasicNameValuePair("tag", getAllFreebies_tag));
JSONArray json = jsonParser.getJSONArrayFromUrl(getAllFreebiesURL,
params);
return json;
}
我仍然只得到一行而不是所有行。谁能告诉我我做错了什么。谢谢:(
将代码更新为:
// Initialize the array with your JSON string.
JSONArray json1 = new JSONArray(json);
// This line adds your String as the first element to
// the JSON array and is incorrect. You can safely remove it.
//json1.put(json);
编辑:尝试您发布的代码的更新版本:
// Making HTTP request
try {
// defaultHttpClient
DefaultHttpClient httpClient = new DefaultHttpClient();
HttpPost httpPost = new HttpPost(url);
httpPost.setEntity(new UrlEncodedFormEntity(params));
HttpResponse httpResponse = httpClient.execute(httpPost);
try {
// Get our response as a String.
String jsonString = EntityUtils.toString(httpResponse.getEntity());
Log.d(TAG, "JSON: "+jsonString);
// Parse the JSON String into a JSONArray object.
return new JSONArray(jsonString);
} catch (JSONException e) {
Log.e("JSON Parser", "Error parsing data " + e.toString());
} catch (Exception e) {
Log.e("Buffer Error", "Error converting result " + e.toString());
}
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
} catch (ClientProtocolException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return null;
检查以下代码:
JSONObject json = jsonParser.getJSONFromUrl(getAllFreebiesURL,params);
JSONArray json1 = new JSONArray();
json1.put(json);
try {
System.out.println(json1.get(2));
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
创建一个新的空JSONArray
,向其添加一个元素,然后尝试访问其第二个元素。
getJSONFromUrl
应该解析对象还是数组?我相信您需要它来返回JSONArray
。