doukuipei9938
doukuipei9938
2012-12-18 05:03

在android中使用JSON传递数据数组

已采纳

I need to pass data from MYSQL database to android application by creating JSON object. I am able to pass only the first value from MYSQL database. How to pass all the values together to android application. (My database contains Latitude and Longitude values of more than 10 locations.)

Following is my code for passing only the first row value from database to android app.

        try {

        HttpClient client = new DefaultHttpClient();
        URI website = new URI("http://192.168.1.15/latlonret1.php");
        HttpGet request = new HttpGet();
        request.setURI(website);
        HttpResponse response = client.execute(request);
        in = new BufferedReader(new InputStreamReader(response
                .getEntity().getContent()));
        StringBuffer sb = new StringBuffer("");
        String l = "";
        String nl = System.getProperty("line.separator");

        while ((l = in.readLine()) != null) {
            sb.append(l + nl);
        }
        in.close();
        data = sb.toString();
        // return data;
    } catch (Exception e) {
        Log.e("log_tag", "Error converting result " + e.toString());
    }
        try {
        String returnString;
        String returnString1;
        JSONArray jArray = new JSONArray(data);
        for (int i = 0; i < jArray.length(); i++) {
            JSONObject json_data = jArray.getJSONObject(i);
            JSONObject json_data1 = jArray.getJSONObject(i);


            returnString=json_data.getString("lat") + "
";
            returnString1=json_data1.getString("lon") + "
";
            System.out.println(returnString);
            System.out.println(returnString1);

            Intent viewIntent =new Intent(Androidmap.this,Mapview.class);

            Bundle bundle = new Bundle();
            bundle.putString("stuff", returnString); 
            viewIntent.putExtras(bundle);

            Bundle bundle1 = new Bundle();
            bundle1.putString("stuff1", returnString1); 
            viewIntent.putExtras(bundle1); 
            startActivity(viewIntent);
      }

This is my Server side coding :

<?php
 ob_start();
 $host="localhost"; // Host name 
 $username=""; // Mysql username 
 $password=""; // Mysql password 
 $db_name="test"; // Database name 
 $tbl_name="manu"; // Table name 

 mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
 mysql_select_db("$db_name")or die("cannot select DB");
 $sql = "select lat , lon from manu ";
 $result=mysql_query($sql);

 if(! $result )
 {
 die('Could not get data: ' . mysql_error());
 }

 while($row=mysql_fetch_array($result , MYSQL_ASSOC)) 
{

$output[]=$row;

}

 echo json_encode($output);
 mysql_close();
?>
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

2条回答

  • dsbfbz75185 dsbfbz75185 9年前

    you will need to append next lat and lon value in previous string as:

    ArrayList<String> arrlan=new ArrayList<String>();
    ArrayList<String> arrlat=new ArrayList<String>(); 
           for (int i = 0; i < jArray.length(); i++) {
                JSONObject json_data = jArray.getJSONObject(i);
                JSONObject json_data1 = jArray.getJSONObject(i);
    
    
                returnString  =json_data.getString("lat") + "
    ";
                returnString1  =json_data1.getString("lon") + "
    ";
    
                arrlat.add(returnString);  
                arrlan.add(returnString1);   
    
                System.out.println(returnString);
                System.out.println(returnString1);
          }
     Intent viewIntent =new Intent(Androidmap.this,Mapview.class);
    
    
     viewIntent.putStringArrayListExtra("returnString",arrlat);
     viewIntent.putStringArrayListExtra("returnString1",arrlan);
    
    
     startActivity(viewIntent);
    

    and in Mapview get these arraylist as:

    ArrayList<String> arrlan=new ArrayList<String>();
    ArrayList<String> arrlat=new ArrayList<String>(); 
    
    arrlat = getIntent().getStringArrayListExtra("returnString");
    arrlan = getIntent().getStringArrayListExtra("returnString1");
    
    点赞 评论 复制链接分享
  • duankeng2026 duankeng2026 9年前

    Try this, you need to create only one object.

        for (int i = 0; i < jArray.length(); i++) 
           {
            JSONObject json_data = jArray.getJSONObject(i);
    
            returnString=json_data.getString("lat") + "
    ";
            returnString1=json_data.getString("lon") + "
    ";
           }
    
    点赞 评论 复制链接分享