我正在尝试从php服务器获取一组数据到android。但是在我执行项目时出现了一个错误，尝试参考几个相关的问题，但我仍然无法找到解决方案。
这是我的异步任务，它将建立连接并将momentID发送到php
class GetAllComment extends AsyncTask<String, String, ArrayList<Comment>> {
protected ArrayList<Comment> doInBackground(String... params) {
List<NameValuePair> param = new ArrayList<NameValuePair>();
int success;
try {
Log.d("","@@@### " + postedID);
param.add(new BasicNameValuePair("momentid", postedID));
JSONObject json = jsonParser.makeHttpRequest(
"http://192.168.168.111:80/testmoment/getallcomment.php", "GET", param);
// check your log for json response
Log.d("Single comments Details", json.toString());
// json success tag
success = json.getInt("success");
if (success == 1) {
JSONArray productObj = json
.getJSONArray("product"); // JSON Array
try {
JSONObject comments = productObj.getJSONObject(0);
Comment comment = new Comment();
comment.setCommentContentbody(comments.getString("vcontentbody"));
comment.setCommentDate(comments.getString("vcdate"));
comment.setCommentTime(comments.getString("vctime"));
list.add(comment);
Log.d("","tryget : " + comments.getString("vcid") + " AND " + comments.getString("vcontentbody") + " AND " + comments.getString("vcdate") + " AND " + comments.getString("vctime"));
} catch (JSONException e) {
e.printStackTrace();
}
} else {
}
}catch (JSONException e) {
e.printStackTrace();
}
return list;
}
protected void onPostExecute(ArrayList<Comment> list) {
cAdapter = new CommentAdapter(getActivity().getBaseContext(), mCommentLists);
commentList.setAdapter(cAdapter);
mComment = new Comment();
cAdapter.Update();
if(list != null){
for(Comment comment: list){
cAdapter.add(comment);
}
}
cAdapter.notifyDataSetChanged();
}
}
这是我的php脚本：
<?php
header('Content-type: application/json');
include "db.config.php";
if (isset($_GET['momentid'])){
$momentid = $_GET['momentid'];
$result =mysql_query("SELECT * FROM commenttable WHERE vcmomentid = $momentid");
if (!empty($result)) {
// check for empty result
while($row=mysql_fetch_assoc($result))
$json_output[]=$row;
print(json_encode($json_output));
mysql_close();
echo json_encode($response);
} else {
// no product found
$response["success"] = 0;
$response["message"] = "No product found";
// echo no users JSON
echo json_encode($response);
}
} else {
// no product found
$response["success"] = 0;
$response["message"] = "No product found";
// echo no users JSON
echo json_encode($response);
}
?>
这是我执行后得到的错误：
JSON Parser: Error parsing data org.json.JSONException: Value [{"vcontentbody":"gkkgv","vcid":"1","vcmomentid":"109","vcdate":"2015-11-23","vcuserid":"1578","vctime":"17:09 PM"}] of type org.json.JSONArray cannot be converted to JSONObject
请帮我查找错误。感谢
实际上，您得到的是要转换为JSONObject 的JSONArray
[ // This is Array
{ // This is Object
"vcontentbody":"gkkgv",
"vcid":"1",
"vcmomentid":"109",
"vcdate":"2015-11-23",
"vcuserid":"1578",
"vctime":"17:09 PM"
}
]
所以你必须这样写：
JSONArray jsonArray = jsonParser.makeHttpRequest("http://192.168.168.111:80/testmoment/getallcomment.php", "GET", param);
现在检查它是否为空
if(jsonArray != null)
{
// Here You may not have any key like 'success' so i don't have taken.
// You can directly get JSON Object here.. If you are getting more than one JSONObject then make loop here...
JSONObject object = jsonArray.getJSONObject(0);
// Now you can do with object that you want to do.
Comment comment = new Comment();
comment.setCommentContentbody(object.getString("vcontentbody"));
comment.setCommentDate(object.getString("vcdate"));
comment.setCommentTime(object.getString("vctime"));
list.add(comment);
}
如果有任何问题，你可以打电话给我。希望这对你有帮助。谢谢
以下是您可以解析数据的代码，请将您的jsonArray放入响应变量中
try {
JSONArray arr=new JSONArray(response);
JSONObject jobj=new JSONObject(arr.get(0).toString());
for(int i=0;i<jobj.length();i++)
{
Log.e("Index 0", ":"+jobj.getString("vcontentbody")) ;
Log.e("Index 1", ":"+jobj.getString("vcid"));
Log.e("Index 2", ":"+jobj.getString("vcmomentid")) ;
Log.e("Index 3", ":"+jobj.getString("vcuserid")) ;
Log.e("Index 4", ":"+jobj.getString("vcdate")) ;
Log.e("Index 4", ":"+jobj.getString("vctime")) ;
}
} catch (JSONException e) {
e.printStackTrace();
}