Android getting data out of listview

Question

I'm at the moment programming an APP with an listview which is filled with data from an SQLite Table like this:

public void printDatabase(){
    Cursor c = handler.getAllRows();
    String[] fieldNames = new String[] {DBHandler.COLUMN_WORKER_ID, DBHandler.COLUMN_WORKER_NAME, DBHandler.COLUMN_WORKER_SURNAME, DBHandler.COLUMN_WORKER_COST};
    int[] toView = new int[] {R.id.item_worker_id, R.id.item_worker_name, R.id.item_worker_surname, R.id.item_worker_cost};
    SimpleCursorAdapter cAdapter;
    cAdapter = new SimpleCursorAdapter(getBaseContext(), R.layout.worker_items, c, fieldNames, toView, 0);
    list = (ListView) findViewById(R.id.worker_listView);
    list.setAdapter(cAdapter);
}

Now I'd like to get the data from the listview of an item by clicking the item. I've searched everywhere to find a solution for this and found this:

class ItemListener implements AdapterView.OnItemClickListener{

    @Override
    public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {
        Object o = list.getItemAtPosition(i);
        String s = list.toString();
    }
}

But all I get from this is the reference to the cursor I've used for filling the listview. What do I need to get the data from the listview?

Kamran Ahmed · Accepted Answer · 2017-01-01 18:15:54Z

You are half way to your solution already.

Cursor itemCursor = (Cursor) list.getItemAtPosition(i);

This returns you a cursor pointing to the row that is clicked. You can get the data out of it like:

class ItemListener implements AdapterView.OnItemClickListener {
    @Override
    public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {
        Cursor itemCursor = (Cursor) list.getItemAtPosition(i);

        String workerId = itemCursor.getString(itemCursor.getColumnIndex(DBHandler. COLUMN_WORKER_ID));
        String workerName = itemCursor.getString(itemCursor.getColumnIndex(DBHandler.COLUMN_WORKER_NAME));
        String workerSurname = itemCursor.getString(itemCursor.getColumnIndex(DBHandler.COLUMN_WORKER_SURNAME));
        String workerCost = itemCursor.getString(itemCursor.getColumnIndex(DBHandler.COLUMN_WORKER_COST));
    }
}

Saurabh Padwekar · Accepted Answer · 2017-01-01 18:24:14Z

1

Make the cursor global ;

Cursor cursor ;

In your OnItemClick

class ItemListener implements AdapterView.OnItemClickListener{

@Override
public void onItemClick(AdapterView<?> adapterView, View view, int position, long l) {
     cursor.moveToPosition(position);
     String Id = cursor.getString(itemCursor.getColumnIndex(DBHandler. COLUMN_WORKER_ID));
 }

}

answered Jan 1, 2017 at 18:24

Saurabh Padwekar

4,0841 gold badge37 silver badges37 bronze badges

2 Comments

Kamran Ahmed Over a year ago

Oh God why a global variable?

Saurabh Padwekar Over a year ago

Because it is less expensive than casting sir.

András Ferencz · Accepted Answer · 2017-01-01 18:10:01Z

0

Try this:

class ItemListener implements AdapterView.OnItemClickListener{

@Override
public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {
    TextView textView = (TextView) view.findViewById(R.id.list_content);
        String text = textView.getText().toString(); 
        //Log.d("Choosen: " + text);
}}

answered Jan 1, 2017 at 18:10

András Ferencz

6321 gold badge7 silver badges15 bronze badges

Collectives™ on Stack Overflow

Android getting data out of listview

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related