Android中通过json向MySql中读写数据的方法（二）

首先 要定义几个解析json的方法parseJsonMulti，代码如下：

private void parseJsonMulti(String strResult) {   
        try {   

        	Log.v("strResult11","strResult11="+strResult);
        	
        	 int index=strResult.indexOf("[");
	            if(index>0)
	            	strResult=strResult.substring(index, strResult.length()); 
	            
	            Log.v("strResult22","strResult22="+strResult);
	            wifiMapData = new JSONArray(strResult);
	            
	            Log.v("wifiMapDataLength",""+wifiMapData.length());
	            
            for(int i = 0; i < wifiMapData.length() ; i++){///基站信息处理
				///MapData m=new MapData(1, dLat[5], dLong[5], 10, 20, 300, 500, 105, "教1", 1, 1, 4);
            	
            
				JSONObject jsonObject = wifiMapData.getJSONObject(i);
		
				 int id=Integer.parseInt(jsonObject.getString("id"));	//id
			
                // if(jsonObject.isNull("mac_address")) mac_address="";
				 String mac_address = jsonObject.getString("mac_address");//wifi的mac地址	
				 
				 String wifi_name=jsonObject.getString("wifi_name");	//ssid
				
				 
				 if(!jsonObject.isNull("lat")&&!jsonObject.isNull("lon")){
				
				  lat= Double.valueOf(jsonObject.getString("lat"));//纬度
				 
				  lon=Double.valueOf(jsonObject.getString("lon"));//经度
				  
				 }
				 String location_name=jsonObject.getString("location_name");	//ssid
				
				 String wifi_adds = jsonObject.getString("wifi_adds");//wifi地址 具体到多少路多少号
				
				 String area = jsonObject.getString("area");//北京的什么区
			
				 String location_type = jsonObject.getString("location_type");//地点是个什么类型的，写字楼？？
			
				 String ap_free = jsonObject.getString("ap_free");//ap是否免费
				
				 String category = jsonObject.getString("category");//ap是否免费
				 
				 String password = jsonObject.getString("password");//ap是否免费	
				 
				 String capabilities = jsonObject.getString("capabilities");//ap是否免费	
				 
				 String user_score = jsonObject.getString("user_score");//ap是否免费	
				
				 String NW_score = jsonObject.getString("NW_score");//ap是否免费	
}   
           // tvJson.setText(s);   
        } catch (JSONException e) {   
            System.out.println("Jsons parse error !");   
            e.printStackTrace();   
        }   
    }   

再定义一个向MySql发送http请求的方法connServerForResult，代码如下：

private String connServerForResult(String strUrl) {   
        // HttpGet对象   
        HttpGet httpRequest = new HttpGet(strUrl);   
        String strResult = "";   
        try {   
            // HttpClient对象   
            HttpClient httpClient = new DefaultHttpClient();   
            // 获得HttpResponse对象   
            HttpResponse httpResponse = httpClient.execute(httpRequest);   
            if (httpResponse.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {   
                // 取得返回的数据   
                strResult = EntityUtils.toString(httpResponse.getEntity());   
            }   
        } catch (ClientProtocolException e) { 
        	
        	Toast.makeText(Setting.this,
        			"protocol error", Toast.LENGTH_SHORT).show();
          
            e.printStackTrace();   
        } catch (IOException e) {   
        	Toast.makeText(Setting.this,
        			"IO error", Toast.LENGTH_SHORT).show();
           
            e.printStackTrace();   
        }   
        return strResult;   
    }   
    

然后就是在主程序中调用这两个方法：代码如下

String strUrl1 = "http://192.168.1.2/call_for_wifiMapData.php";
			                //获得返回的Json字符串   
			                String strResult1 = connServerForResult(strUrl1); 
			                
			                Log.v("strResult1",strResult1);
			                
			                parseJsonMulti(strResult1);

只有几句话而已，php同样要替换成你自己的文件路径，

php代码如下：

<?php 

    $jsonArrayString = $_POST["jsonArrayString"];	
	$jsonString = $_POST["jsonString"];	
	$objArray=json_decode($jsonArrayString,true);	
	$obj=json_decode($jsonString); 
	$lon = (float)$obj->lon;
	$lat = (float)$obj->lat;
	$distance=(float)$obj->distance;	
	if($lat==null||$lat==0){
	$lat=39.990132;
	$lon=116.332224;
	$distance=100000;
	
	}

    将cell表中与点（lat,lon）距离小于distance的点打包回来
	
	$con = mysql_connect("localhost","root",null);
	if (!$con) {
		die('Could not connect:'.mysql_error() );
	}

	mysql_select_db("a0722152915", $con);
	mysql_query("set names 'utf8'"); 
	$sqlfind = "select * from `wifi`";
	$resultFind = mysql_query($sqlfind, $con);
	$length=mysql_num_rows($resultFind);

    $arr=array();
	$j=0;
	for($i=0;$i<$length;$i++)
	{
	    $row = mysql_fetch_array($resultFind);

		$arr[$j]['id'] = $row['id'];
		$arr[$j]['mac_address']=$row['mac_address'];
		$arr[$j]['wifi_name']=$row['wifi_name'];	
		$arr[$j]['lat']=$row['gps_lat'];
		$arr[$j]['lon']=$row['gps_lon'];
		$arr[$j]['location_name']=$row['location_name'];
		$arr[$j]['wifi_adds']=$row['wifi_adds'];
		$arr[$j]['area']=$row['area'];
		$arr[$j]['location_type']=$row['location_type'];
		$arr[$j]['ap_free']=$row['ap_free'];
		$arr[$j]['category']=$row['category'];
		$arr[$j]['password']=$row['password'];
		$arr[$j]['capabilities']=$row['capabilities'];
		$arr[$j]['user_score']=$row['user_score'];
		$arr[$j]['NW_score']=$row['NW_score'];
		
		$j++;
		
		
	}
	
	//print_r($arr);\					
	echo  json_encode($arr);
	

	
	
	
?>

还有一点需要注意，就是如果你的终端上的操作系统是android4.0以上的，要添加上那一段代码，上一篇有写，这里略过

如此一来，可以从MySql中成功地将数据读取下来