package com.dynu.thekalulefoundationmobile; import android.app.ListActivity; import android.app.ProgressDialog; import android.content.Intent; import android.os.AsyncTask; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.AdapterView; import android.widget.ListAdapter; import android.widget.ListView; import android.widget.SimpleAdapter; import android.widget.TextView; import org.apache.http.NameValuePair; import org.json.JSONArray; import org.json.JSONException; import org.json.JSONObject; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import static android.widget.AdapterView.*; public class tenant_cont extends ListActivity { private ProgressDialog pDialog; JSONParser jParser = new JSONParser(); ArrayList> tenantContacts; // JSON Node Names private static final String KEY_STATUS = "status"; private static final String KEY_TENANTS = "tenants"; private static final String KEY_TENID = "ten_id"; private static final String KEY_TEN_NAME = "ten_name"; private static final String KEY_MNUM = "m_num"; private static final String KEY_HNUM = "h_num"; JSONArray tenants = null; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_tenant_cont); tenantContacts = new ArrayList<>(); new LoadAllTenants().execute(); ListView lv = getListView(); lv.setOnItemClickListener(new OnItemClickListener() { @Override public void onItemClick(AdapterView parent, View view, int position, long id) { String ten_id = ((TextView) view.findViewById(R.id.tenid)).getText().toString(); Intent in = new Intent(getApplicationContext(), admin_home.class); in.putExtra(KEY_TENID, ten_id); startActivityForResult(in, 100); } }); } class LoadAllTenants extends AsyncTask { @Override protected void onPreExecute() { super.onPreExecute(); pDialog = new ProgressDialog(tenant_cont.this); pDialog.setMessage("Loading contacts. Please wait..."); pDialog.setIndeterminate(false); pDialog.setCancelable(false); pDialog.show(); } @Override protected String doInBackground(String... args) { List params = new ArrayList<>(); String url_tenant_contact = "http://192.168.137.91:8081/app_data/get_tenant_contacts.php"; JSONObject json = jParser.makeHttpRequest(url_tenant_contact, "GET", params); Log.d("All Products: ",json.toString()); try { int status = json.getInt(KEY_STATUS); if (status == 0) { tenants = json.getJSONArray(KEY_TENANTS); for (int i =0; i < tenants.length(); i++) { JSONObject c = tenants.getJSONObject(i); String ten_id = c.getString(KEY_TENID); String ten_name = c.getString(KEY_TEN_NAME); String m_num = c.getString(KEY_MNUM); String h_num = c.getString(KEY_HNUM); HashMap map = new HashMap<>(); map.put(KEY_TENID, ten_id); map.put(KEY_TEN_NAME, ten_name); map.put(KEY_MNUM, m_num); map.put(KEY_HNUM, h_num); tenantContacts.add(map); } } } catch (JSONException e) { e.printStackTrace(); } return null; } protected void onPostExecute(String file_url) { pDialog.dismiss(); runOnUiThread(new Runnable() { @Override public void run() { ListAdapter adapter = new SimpleAdapter( tenant_cont.this, tenantContacts,R.layout.list_item, new String[] { KEY_TENID, KEY_TEN_NAME, KEY_MNUM, KEY_HNUM}, new int[] { R.id.tenid, R.id.ten_name, R.id.m_num, R.id.h_num} ); setListAdapter(adapter); } }); } } }

Android Development List Items from SQL Server