1. Download our Official Android App: Forums for Android!

[Ask] how to make list menu from database

Discussion in 'Android Lounge' started by n3wbie, Mar 24, 2011.

  1. n3wbie

    n3wbie Lurker
    Thread Starter
    Rank:
    None
    Points:
    5
    Posts:
    1
    Joined:
    Mar 24, 2011

    Mar 24, 2011
    1
    0
    5
    i've problem here...

    i just make a simple project with android...i make some connection with my database in my host....so it's online...i can view all my records with a simple textview. from here i just want to take the string value on my database and make it as menu list. this is my source hope someone would help me...please :)

    the database content is username


    package com.test;
    import java.io.BufferedReader;
    import java.io.IOException;
    import java.io.InputStream;
    import java.io.InputStreamReader;
    import java.util.ArrayList;

    import org.apache.http.HttpEntity;
    import org.apache.http.HttpResponse;
    import org.apache.http.NameValuePair;
    import org.apache.http.client.ClientProtocolException;
    import org.apache.http.client.HttpClient;
    import org.apache.http.client.entity.UrlEncodedFormEntity;
    import org.apache.http.client.methods.HttpPost;
    import org.apache.http.impl.client.DefaultHttpClient;
    import org.json.JSONArray;
    import org.json.JSONException;
    import org.json.JSONObject;

    import android.app.ListActivity;
    import android.os.Bundle;
    import android.util.Log;
    import android.view.View;
    import android.widget.ArrayAdapter;
    import android.widget.ListView;
    import android.widget.Toast;

    public class testing extends ListActivity {
    @Override
    public void onCreate(Bundle icicle) {
    super.onCreate(icicle);
    cek();
    }

    public void cek(){

    String address = "http//mywebsite/select.php";

    HttpClient httpclient = new DefaultHttpClient();
    HttpPost httppost = new HttpPost(address);

    ArrayList<NameValuePair> parameter = new ArrayList<NameValuePair>();

    try {
    httppost.setEntity(new UrlEncodedFormEntity(parameter));
    HttpResponse httpResponse = httpclient.execute(httppost);
    HttpEntity httpentity = httpResponse.getEntity();

    InputStream input = httpentity.getContent();
    BufferedReader read = new BufferedReader(new InputStreamReader(input));

    String content = "";
    String line = "";

    while((line = read.readLine())!=null){
    content += line;

    }

    Log.d("ADBUG", "content: "+content);

    if(!content.equals("null")){

    try {
    JSONArray jArr = new JSONArray(content);
    String[] user = new String[jArr.length()];
    for(int i=0;i<jArr.length();i++){
    JSONObject jObj = jArr.getJSONObject(i);
    String username = jObj.getString("username");
    user=username;

    }


    this.setListAdapter(new ArrayAdapter<String>(this,android.R.layout.simple_list_item_1, user));

    } catch (JSONException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    }else{
    Toast.makeText(this, "Error", Toast.LENGTH_LONG).show();
    }
    } catch (ClientProtocolException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }catch (IOException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    }
    @Override
    protected void onListItemClick(ListView l, View v, int position, long id) {
    super.onListItemClick(l, v, position, id);
    Object o = this.getListAdapter().getItem(position);
    String keyword = o.toString();
    Toast.makeText(this, "not yet : " + keyword, Toast.LENGTH_LONG).show();

    }
    }
     

    Advertisement

Share This Page

Loading...