Access the data from database and put them into String[]

Question

I built a table in the database, and now I want to access the all of the values in a certain column. Finally, I want to put the data into byte[]. Part of my code:

db.execSQL("create table thing(id integer primary key" +
            " autoincrement, name varchar(20))");

List<Integer> all = new ArrayList<Integer>();       
String sql = " SELECT id from " + DB_NAME;
Cursor result = this.db.rawQuery(sql, null);

for (result.moveToFirst(); result.isAfterLast(); result.moveToNext()) {
    all.add(result.getInt(0));          
}

String[] fstr = (String[]) all.toArray();
for (String bstr : fstr) {
    byte[] bbs = bstr.getBytes();
}

XEENA · Accepted Answer · 2013-03-23 04:28:56Z

3

Use this code

String[] fstr = new String[result.getCount()] ; 

    do {
    int posi = result.getPosition();
     fstr[posi] =result.getString(0);                           
    }while (result.moveToNext());

answered Mar 23, 2013 at 4:28

XEENA

5672 silver badges6 bronze badges

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

Comments

Lalit Sharma · Accepted Answer · 2013-03-23 04:59:26Z

0

try this

Cursor c=this.db.rawQuery(sql, null);
if(c.getCount()>0)
{
   for(c.moveToFirst();!c.isAfterLast();c.moveToNext())
   {
     String str=c.getInt(0));// or c.getString();
   }
}

else
{
  Log.d(" Null value in cursor ", " null ");
}
c.close();
dbhelper.close();

answered Mar 23, 2013 at 4:59

Lalit Sharma

1,1501 gold badge15 silver badges32 bronze badges

Collectives™ on Stack Overflow

Access the data from database and put them into String[]

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related