List always returns only the first row of the bank sqlite [closed]

Question

List always returns only the first row of the bank sqlite [closed]

Navigation

#1 by (3 votes)
#2 by (1 votes)

0

I have a list, which shows all sqlite bank data, image path, latitude and longitude, but in the list only changes the image path, latitude and longitude always stays the first record.

public List<Foto> todasFotos(){

    List<Foto> listaFotos = new ArrayList<Foto>();

    SQLiteDatabase db =  getReadableDatabase();

    String sqlTodasFotos =  "SELECT * FROM imagens";

    Cursor c = db.rawQuery(sqlTodasFotos,null);

    if (c.moveToNext()) {
        do {
            Foto foto = new Foto();
            foto.setId(c.getInt(0));
            foto.setCaminho_foto(c.getString(1));
            foto.setLatitude(c.getDouble(2));
            foto.setLongitude(c.getDouble(3));

            listaFotos.add(foto);
        } while (c.moveToNext());
    }
    db.close();
    return listaFotos;
}

java android sqlite

asked by anonymous 27.09.2016 / 16:59

2 answers

How do I compare two strings in c Wordpress using ajax in page template

score 3 · Answer 1

Use moveToFirst() . Considering SQLiteDataBase it is said that:

A Cursor object, which is positioned before the first entry.

moveToFirst() does two things:

Lets you test whether the query returned an empty set;

Moves the cursor to the first result (when the device is not empty).

Considering moveToNext() :

while (cursor.moveToNext());

The cursor starts before the first line of the result, so in the first iteration it moves to the first result if it exists. If the cursor is empty, or the last line has already been processed, then the loop will exit neatly.

The end result would look like this:

if (c.moveToFirst()) {
        do {
            Foto foto = new Foto();
            foto.setId(c.getInt(0));
            foto.setCaminho_foto(c.getString(1));
            foto.setLatitude(c.getDouble(2));
            foto.setLongitude(c.getDouble(3));

            listaFotos.add(foto);
        } while (c.moveToNext());
}

Details

Cursor

score 1 · Answer 2

Look like this:

public List<Foto> todasFotos(){

    List<Foto> listaFotos = new ArrayList<Foto>();

    SQLiteDatabase db =  getReadableDatabase();

    String sqlTodasFotos =  "SELECT * FROM imagens";

    Cursor c = db.rawQuery(sqlTodasFotos,null);
    cursor.moveToFirst();

     if (!cursor.isAfterLast()) {
               do {
                   Foto foto = new Foto();
                   foto.setId(c.getInt(0));
                   foto.setCaminho_foto(c.getString(1));
                   foto.setLatitude(c.getDouble(2));
                   foto.setLongitude(c.getDouble(3));

                    listaFotos.add(foto);
                 }
                  while (cursor.moveToNext());

        }

    db.close();
    return listaFotos;
}