how to get the database value to a String array in android(sqlite Database)

Question

I have a database name "CUED" (sqlite Android)it have a table HELLO which contain a column NAME I can get the value to String from that column. Let me show you my code section

myDB =hello.this.openOrCreateDatabase("CUED", MODE_PRIVATE, null); 
Cursor crs = myDB.rawQuery("SELECT * FROM HELLO", null);
                
while(crs.moveToNext())
{
    String uname = crs.getString(crs.getColumnIndex("NAME"));
    System.out.println(uname);
}

It will print the value one by one. Now what I need is that I want to get the column values from database and so that I can store it in a String Array.

Alois Heimer · Accepted Answer · 2015-06-19 10:14:22Z

25

You already did the hard part... the array stuff is pretty simple:

String[] array = new String[crs.getCount()];
int i = 0;
while(crs.moveToNext()){
    String uname = crs.getString(crs.getColumnIndex("NAME"));
    array[i] = uname;
    i++;
}

Whatever, I always recommend to use collections in cases like this:

List<String> array = new ArrayList<String>();
while(crs.moveToNext()){
    String uname = crs.getString(crs.getColumnIndex("NAME"));
    array.add(uname);
}

In order to compare the arrays, you can do things like this:

boolean same = true;
for(int i = 0; i < array.length; i++){
    if(!array[i].equals(ha[i])){
        same = false;
        break;
    }
}
// same will be false if the arrays do not have the same elements

edited Jun 19, 2015 at 10:14

Alois Heimer

1,8521 gold badge20 silver badges40 bronze badges

answered Jan 25, 2012 at 14:18

Cristian

200k63 gold badges360 silver badges265 bronze badges

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

4 Comments

Ramz Over a year ago

thank you bro now can help me one more time i have another string array i want to compare both value in the array let me explain my first array--- String[] ha={"hello","hai"}; and String array from database----String[] array={"hello","hai"}; i want to check the each position of both array if both are same let me enter next page

Subha Over a year ago

Good , but if need to get all the column values from only one row to form string array means how to do ?

Tushar Narang Over a year ago

Hey, Great answer... What to do in case multiple rows are returned. ?? String uname = crs.getString(crs.getColumnIndex("NAME")); String lname = crs.getString(crs.getColumnIndex("LASTNAME"));

PhilipB Over a year ago

Don't forget to crs.close();

Ramesh Solanki · Accepted Answer · 2012-01-26 06:22:35Z

0

       String[] str= new String[crs.getCount()];
       crs.movetoFirst();           
     for(int i=0;i<str.length();i++)
        { 
           str[i] = crs.getString(crs.getColumnIndex("NAME"));
            System.out.println(uname);
      crs.movetoNext();
        }

Enjoy it

edited Jan 26, 2012 at 6:22

answered Jan 25, 2012 at 14:38

Ramesh Solanki

2,9464 gold badges31 silver badges45 bronze badges

1 Comment

Cristian Over a year ago

You are not moving the cursor position.

Luke Beveridge · Accepted Answer · 2016-03-09 01:11:24Z

0

This is my code that returns arraylist contains afield value:

public ArrayList<String> getAllPlayers() {

    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cur = db.rawQuery("SELECT " + serailnumber + " as _id, " + title
            + " from " + table, new String[] {});
    ArrayList<String> array = new ArrayList<String>();
    while (cur.moveToNext()) {
        String uname = cur.getString(cur.getColumnIndex(title));
        array.add(uname);

    }
    return array;
}

edited Mar 9, 2016 at 1:11

Luke Beveridge

5051 gold badge7 silver badges19 bronze badges

answered Apr 20, 2013 at 11:32

Ribin Haridas

1,62011 silver badges17 bronze badges

Collectives™ on Stack Overflow

how to get the database value to a String array in android(sqlite Database)

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related