Android "read a chapter" by using JSON to read and write data to MySQL _android

Source: Internet
Author: User
Tags parse error

This article illustrates the way Android reads data to MySQL via JSON. Share to everyone for your reference, specific as follows:

First, you define several methods for parsing JSON Parsejsonmulti, the code is as follows:

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++) {///Base station information processing///mapdata m=new MapData (1, dlat[5], dlong[5], 10, 20, 300
    , 500, 105, "Teach 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 address string wifi_name=jsonobject.getstring ("Wifi_ Name "); SSID if (!jsonobject.isnull ("lat") &&!jsonobject.isnull ("Lon")) {lat= double.valueof (Jsonobject.getstrin G ("lat"));/Latitude Lon=double.valUeof (jsonobject.getstring ("Lon"));//Longitude} String location_name=jsonobject.getstring ("Location_name"); SSID string wifi_adds = jsonobject.getstring ("Wifi_adds"),//wifi address specific to how many routes number String area = Jsonobject.getstrin
     G ("area"); What district of Beijing String Location_type = jsonobject.getstring ("Location_type"); where is the type of office? 
     String ap_free = jsonobject.getstring ("Ap_free"),//ap free string category = Jsonobject.getstring ("category"); string password = jsonobject.getstring ("password");//ap free string capabilities = Jsonobject.getstring ("Capabil Ities ");//ap whether free string user_score = jsonobject.getstring (" User_score ");//ap whether free string nw_score = jsonobject.ge
  Tstring ("Nw_score");//ap free}//Tvjson.settext (s);
   catch (Jsonexception e) {System.out.println ("Jsons parse Error!");
  E.printstacktrace ();

 }
}

To define a method to send HTTP requests to MySQL Connserverforresult, the code is as follows:

private string Connserverforresult (string strurl) {
  //HttpGet object
  httpget HttpRequest = new HttpGet (strurl);
  String strresult = "";
  try {
   //HttpClient object
   httpclient httpclient = new Defaulthttpclient ();
   Obtain HttpResponse object
   httpresponse httpresponse = Httpclient.execute (HttpRequest);
   if (Httpresponse.getstatusline (). Getstatuscode () = = HTTPSTATUS.SC_OK) {
    //Get the returned data
    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;
}

Then you call the two methods in the main program: The code is as follows

String STRURL1 = "http://192.168.1.2/call_for_wifiMapData.php";
Gets the returned JSON string string
strResult1 = Connserverforresult (STRURL1);
LOG.V ("StrResult1", STRRESULT1);
Parsejsonmulti (STRRESULT1);

Just a few words, PHP also to replace your own file path,

The PHP code is as follows:

<?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;
  ////the dot (lat,lon) distance in the cell table is smaller than 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);?>

It's also important to note that if you have an operating system on your terminal that is android4.0 above, add that piece of code, the previous "Android through JSON to read and write data in MySQL" in the details of the "write article" has written, here skip

In this way, data can be successfully read from MySQL

For more information on Android-related content readers can view the site: "The Android operation JSON format Data Skills summary", "Android Database Operating skills summary", "Android Programming activity Operating Skills summary", " Android File Operation Tips Summary, "Android programming development of the SD card operation method Summary", "Android Development introduction and Advanced Course", "Android Resource Operation skills Summary", "Android View tips Summary" and " A summary of the usage of Android controls

I hope this article will help you with the Android program.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.