how to separate data from a ArrayList<Object>

Question

i have a method that return a ArrayList from a sqlite query, only a 1 row, this array must have 3 strings; name,description and photo(This is a patch string). But i don't know how i can separate the data.

public ArrayList<Object> getLugarPorNombre(String nombre)
{

    ArrayList<Object> rowArray = new ArrayList<Object>();
    Cursor cursor;

    try
    {

        cursor = db.query
        (
                TABLE_NAME,
                new String[] { TABLE_ROW_ID, CNOMBRE, CDESC, CFOTO },
                CNOMBRE + "=" + nombre,
                null, null, null, null, null
        );

        //movemos el puntero a la primera posicion
        cursor.moveToFirst();

        // Si hay datos los añado al array que sera devuelto
        if (!cursor.isAfterLast())
        {
            do
            {
                rowArray.add(cursor.getLong(0));
                rowArray.add(cursor.getString(1));
                rowArray.add(cursor.getString(2));
                rowArray.add(cursor.getString(3));
            }
            while (cursor.moveToNext());
        }

        cursor.close();
    }
    catch (SQLException e) 
    {
        Log.e("Error obteniendo datos de lugar", e.toString());
        e.printStackTrace();
    }

    return rowArray;
}

and

   ayudabbdd = new DataBaseHelper(this);
    ArrayList<Object> datosLugar = ayudabbdd.getLugarPorNombre(nombreClick);

Can i get the name from array list or description in a separate string?

Tobias · Accepted Answer · 2011-10-11 13:51:06Z

1

Do you mean something like that:

String name = (String) datosLugar.get(1);
String description = (String) datosLugar.get(2);

You have to be sure that element 1 & 2 are always Strings othweise you will get a ClassCastException. If you would like to make that cleaner you could probably create an own class for your return type.

answered Oct 11, 2011 at 13:51

Tobias

9,4203 gold badges27 silver badges30 bronze badges

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

Comments

Android Killer · Accepted Answer · 2011-10-11 13:59:38Z

0

Sure you can.But your ArrayList has 4 items not 3 as you mentioned in your question above.just you have to play with ArrayList like this

String name=datosLugar.get(1).toString();
String description=datosLugar.get(2).toString();

answered Oct 11, 2011 at 13:59

Android Killer

18.6k15 gold badges70 silver badges94 bronze badges

Collectives™ on Stack Overflow

how to separate data from a ArrayList<Object>

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