Get data from MYSQL and put it in android ListView

Ashish Tripathi

Due to some busyness i can not reply.

So now it's a sample code which populate the list data coming from the server.

Activity Class

package com.example.parsing_data_demo;

import android.app.ListActivity;
import android.app.ProgressDialog;
import android.os.AsyncTask;
import android.os.Bundle;
import android.view.Menu;
import android.widget.ArrayAdapter;

import com.example.call_service.Call_Service_Url;
import com.example.parse_data.Authentication_parser;

public class MainActivity extends ListActivity {

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);

// setContentView(R.layout.activity_main);
new call_url().execute("");

}


@Override
public boolean onCreateOptionsMenu(Menu menu) {
    // Inflate the menu; this adds items to the action bar if it is present.
    getMenuInflater().inflate(R.menu.main, menu);
    return true;
}
class call_url extends AsyncTask<String, Void,String>{
  ProgressDialog dialog;
  @Override
  protected void onPreExecute(){
      dialog =  ProgressDialog.show(MainActivity.this,"Wait..","Loading...");
  }
  @Override
  protected void onPostExecute(String Result){

      dialog.dismiss();
       setListAdapter(new ArrayAdapter<String>(MainActivity.this, android.R.layout.simple_list_item_1,Authentication_parser.list));

  }
  @Override
  protected String doInBackground(String... params) {
      try{
      Call_Service_Url c = new Call_Service_Url();
      c.Call_Url();
      }
      catch(Exception ex){
          System.out.println("Main Activity Exception"+ex);
          ex.printStackTrace();
      }

      // TODO Auto-generated method stub
      return " ";
  }
}

}

Calling Web Service

public class Call_Service_Url {
String data = "";
public void Call_Url(){
try{
DefaultHttpClient client = new DefaultHttpClient();
//
HttpGet request = new HttpGet("Your Service URL");
HttpResponse response = client.execute(request);
HttpEntity entity = response.getEntity();
InputStream is = entity.getContent();
BufferedReader reader = new BufferedReader(new InputStreamReader(is, "UTF8"), 8);
StringBuilder sb = new StringBuilder();
String line = null;
while ((line = reader.readLine()) != null) {
sb.append(line);
}
data = sb.toString();
System.out.println(data);
//Here you can check whether the response is coming or not. it is the row result. if result is coming than u will parse the response (here is JSON format response)
Authentication_parser p = new Authentication_parser();
p.Parse_Data(data);

Parser the response

public class Authentication_parser {

public static ArrayList list = new ArrayList();
//Declare you xmlor json tag;
protected String a,b,c;

/**
* @param url
* @return
* @throws JSONException
*/
public JSONArray getJSONfromURL(String url) throws JSONException{
String str_response=url;

     JSONArray json_Array=new JSONArray(str_response);
     return json_Array; //<< retun jsonArray

}
/**
* @param response
*/
public void Parse_Data(String response){

  try {
      JSONArray jArray = getJSONfromURL(response);
      for(int i=0;i<jArray.length();i++){
      JSONObject jobj = jArray.getJSONObject(i);
       if(jobj.has("return")){

      //if your service is giving you the status regarding data is avaliable or not
      }
       if(jobj.has("parent")){
      JSONArray my = jobj.getJSONArray("parent");
      for(int j=0;j<my.length();j++){
      JSONObject inObj = my.getJSONObject(j);
      a = inObj.getString("a");
      list.add(a);
        }

}
catch (Exception ex)
{
Log.e("log_tag", "Error getJSONfromURL "+ex.toString());
ex.printStackTrace();
}
}
}

  }
  catch(Exception ex){
      System.out.println("Call Service URL Class Exception=="+ex);
      ex.printStackTrace();
  }
  }

  }

Check if it can help you. Any Issue Share

Sir giving an exception Could'nt connect to database
please give me a proper solution to solve the problem
at this time i'm running on the localhost of this code