android database display in listview shows one row

Question

i've got a database what i wanted to display in a listview. i have something to work. heres the code:

Cursor cursor = myDataBase
                    .rawQuery(
                            "SELECT * FROM Accelerometer where cur_timestamp<'2012-09-04 11:36:25'",
                            null);          

            while (cursor.moveToNext()) {
                // Which column you want to exprort
                String arrStr[] = { cursor.getString(0)+" | " + cursor.getString(1)+" | " + cursor.getString(2)+" | "+ cursor.getString(3)+" | " + cursor.getString(4)+"\n" };
                if (arrStr.length != 0) {
                    Log.d("TravellerLog :: ", Arrays.toString(arrStr));
                    //data.setText(Arrays.toString(arrStr));
                    ListView listView = (ListView) findViewById(R.id.listView1);
                    // a listát berakni aegy arraylist-be
                     ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, android.R.id.text1,
                             arrStr);
                     listView.setAdapter(adapter);

                } else {
                    Log.e("TravellerLog :: ", "Üres a tömb!");
                }
            }

            cursor.close();

what should i change in the code to get it work?To list all the rows i want Thank you very much for the answers!

Mike Mackintosh · Accepted Answer · 2012-09-06 13:23:58Z

1

l.setOnItemClickListener(new OnItemClickListener(){
    public void onItemClick(AdapterView<?> a, View v, int pos,long id){
        Cursor cursor = (Cursor) a.getItemAtPosition(pos);

        I.putExtra("ID", cursor.getInt(cursor.getColumnIndex("_id")));

       // more code here

connect to database and get the value from database by using select query....

edited Sep 6, 2012 at 13:23

Mike Mackintosh

14.3k7 gold badges64 silver badges87 bronze badges

answered Sep 6, 2012 at 12:56

Karthi

7584 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nermeen · Accepted Answer · 2012-09-06 12:37:07Z

0

You are initializing the list view and the adapter inside the while loop.. which means that for every db row you create a new list.

List<String> arrStr = new Vector<String>();
while (cursor.moveToNext()) {
            // Which column you want to exprort
            arrStr.add(cursor.getString(0)+" | " + cursor.getString(1)+" | " + cursor.getString(2)+" | "+ cursor.getString(3)+" | " + cursor.getString(4)+"\n" );
            if (arrStr.length != 0) {
                Log.d("TravellerLog :: ", Arrays.toString(arrStr));
                //data.setText(Arrays.toString(arrStr));
            } else {
                Log.e("TravellerLog :: ", "Üres a tömb!");
            }
        }

        cursor.close();

 ListView listView = (ListView) findViewById(R.id.listView1);
                // a listát berakni aegy arraylist-be
                 ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, android.R.id.text1,
                         arrStr);
                 listView.setAdapter(adapter);

edited Sep 6, 2012 at 12:37

answered Sep 6, 2012 at 12:30

Nermeen

16k5 gold badges62 silver badges73 bronze badges

1 Comment

david Over a year ago

how can i put it out from the while loop?bacause somehow i try it i cant :/

Collectives™ on Stack Overflow

android database display in listview shows one row

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related