Load SQLite data in listview

Question

Load SQLite data in listview

Navigation

#1 by (2 votes)

0

I would like to know how to load the data of an sql query in a list view. As much as I try, I can not do it: S

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("create table usuarios(nombre text primary key, edad int, puntuacion int)");

}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    db.execSQL("drop table usuarios");
    db.execSQL("create table usuarios(nombre text primary key, edad int, puntuacion int)");

}

public class Ranking extends AppCompatActivity{

    private ListView lv1;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.ranking);

        lv1 = (ListView)findViewById(R.id.lv1);

        ArrayList <String> ranking = new ArrayList<>();

        AdminSQLiteOpenHelper juego = new AdminSQLiteOpenHelper(this, "juego", null, 5);
        SQLiteDatabase bd = juego.getWritableDatabase();
        Cursor fila = bd.rawQuery("select nombre, puntuacion from usuarios", null);
        if(fila.moveToFirst()){
            fila = bd.rawQuery("select nombre, puntuacion from usuarios", null);
            ranking.add(fila.getString(0) + " - " + fila.getString(1));
            while(fila.moveToNext()){
                ranking.add(fila.getString(0) + " - " + fila.getString(1));
            }
        }
        bd.close();

        ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, ranking);
        lv1.setAdapter(adapter);

    }
}

android android-listview android-sqlite

asked by Sergio AG 03.03.2018 в 18:23

source

1 answer

Problems working with PHP Classes How to select and get the value of a cell in WPF?

score 2 · Accepted Answer

Try this:

public class Ranking extends AppCompatActivity{

    private ListView lv1;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.ranking);

        lv1 = (ListView)findViewById(R.id.lv1);

        ArrayList <String> ranking = new ArrayList<>();

        AdminSQLiteOpenHelper juego = new AdminSQLiteOpenHelper(this, "juego", null, 5);
        SQLiteDatabase bd = juego.getWritableDatabase();
        Cursor fila = bd.rawQuery("select nombre, puntuacion from usuarios", null);
        if(fila.moveToFirst()){
            do{
              ranking.add(fila.getString(0) + " - " + fila.getString(1))); 
            }while(fila.moveToNext())
        }
        bd.close();

        ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, ranking);
        lv1.setAdapter(adapter);

    }