对两种形式的json数组进行解析:
1.形式一如:[{"id":"4","latitude":"39.9192","longitude":"116.327","description":"","icon":"","type":"0","distance":"12232406"},{"id":"1","latitude":"39.9392","longitude":"116.357","description":"","icon":"","type":"3","distance":"12234172"}]
服务器端我是用thinkPHP写的:
$result = M("数据库表名")->query("SQL语句");
echo json_encode($result);
android端解析代码如下:
public static void parseJson(String result){
try {
JSONArray jsonArray=new JSONArray(result);
for(int i=0;i<jsonArray.length();i++){
JSONObject jsonObject=new JSONObject();
jsonObject=jsonArray.getJSONObject(i);
String latitude=jsonObject.optString("latitude");
}
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
2.形式二如:
{"posts":[{"post{"id":"4","latitude":"39.9192","longitude":"116.327","description":"","icon":"","type":"0","distance":"12232406"}},
{"post":{"id":"25","latitude":"39.66","longitude":"116.46","description":"","icon":"","type":"1","distance":"12252102"}}]}
服务器端代码如下:
$result = M("数据库表名")->query("SQL语句");
$posts = array();
foreach ($result as $key => $value) {
$posts[] = array('post'=>$value);
}
echo json_encode(array('posts'=>$posts));
android端解析json代码如下:
public static List<Map<String,String>> resolveData(String jsonStr)
{
ArrayList<Map<String,String>> list=new ArrayList<Map<String,String>>();
JSONObject json;
try {if(jsonStr!=null){
json = new JSONObject(jsonStr);
JSONArray jArray = json.getJSONArray("posts");
for (int i = 0; i < jArray.length(); i++) {
JSONObject e = jArray.getJSONObject(i);
String s = e.getString("post");
JSONObject jObject = new JSONObject(s);
Map<String,String> map=new HashMap<String,String>();
map.put("latitude",jObject.optString("latitude"));
.....
list.add(map);
}
}
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (NumberFormatException e) {
// TODO: handle exception
e.printStackTrace();
}
catch(Exception e)
{
return null;
}
return list;
}