Fill list of objects with SQLite data

Question

Fill list of objects with SQLite data

Navigation

#1 by (2 votes)

1

I have an object of type Status contains the following attributes.

idEstado (String), siglaState (String)

And I have a table already populated in the database with the same attributes as above. But I would like to return all this data to a collection of this object so that I can load a spinner. But the method I did to search for this data is returning null.

Class that creates the bank:

 public static final String NOME_BANCO = "carona";
private static final int VERSAO_BANCO = 1;

public BancoDados(Context context) {
    super(context, NOME_BANCO, null, VERSAO_BANCO);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(SQL_ESTADO);
    db.execSQL(SQL_CIDADE);
    db.execSQL(SQL_INSERE_UF);
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}


String SQL_ESTADO = "CREATE TABLE [Estado](\n" +
        "[EstadoId] [INT] NOT NULL,\n" +
        "[Sigla] [char](2) NOT NULL,\n" +
        "CONSTRAINT [PK_Estado] PRIMARY KEY ([EstadoId])\n" +
        ");";

String SQL_CIDADE = "CREATE TABLE [Cidade](\n" +
        "[CidadeId] [int] NOT NULL,\n" +
        "[Nome] [varchar](50) NOT NULL,\n" +
        "[EstadoId] [INT] NULL,\n" +
        "CONSTRAINT [PK_Cidade] PRIMARY KEY ([CidadeId]\n" +
        "), CONSTRAINT[FK_ESTADO] FOREIGN KEY ([EstadoID]) REFERENCES [Estado] ([EstadoID])\n" +
        ");";


String SQL_INSERE_UF =  "INSERT INTO [Estado] ([EstadoId],[Sigla]) VALUES " +
        "(11,'MG')," +
        "(19,'RJ')," +
        "(26,'SP');" ;

Class with Method that searches the database and creates list of states

public class EstadoDAO {


public SQLiteDatabase sqLiteDatbase;
public BancoDados bancoDados;

public EstadoDAO (Context context) { bancoDados = new BancoDados(context);}


public List<Estado> carregarEstado (){

    List<Estado> estadoList = new ArrayList<>();

    this.sqLiteDatbase = this.bancoDados.getWritableDatabase();

    Cursor cursor = sqLiteDatbase.rawQuery("SELECT * FROM Estado",null);

    if(cursor.moveToFirst()){
        do{
        Estado estado = new Estado();
        estadoList.add(estado);

            estado.setIdEstado(cursor.getString(0));
            estado.setSiglaEstado(cursor.getString(1));

        }while(cursor.moveToNext());

    }
        return estadoList;

    }



}

1st Question: Why are you returning null from the bank?

2 Doubt: Another question I have is that it will actually be 2 spinner one for another state for city, how do I select the state when I make a select in the city table to load only with the cities of the indicated state.

java android sqlite

asked by anonymous 22.05.2017 / 14:23

1 answer

How to display data from a Node.js script in an HTML page Problem with the Ruby on Rails web server

score 2 · Answer 1

1 - You are adding the empty object in your ArrayList. Try this:

Cursor cursor = sqLiteDatbase.rawQuery("SELECT * FROM Estado",null);   
if(cursor.moveToFirst()){
        do{
       Estado estado = new Estado();

       estado.setIdEstado(cursor.getString(0));
       estado.setSiglaEstado(cursor.getString(1));

       estadoList.add(estado);

    }while(cursor.moveToNext());

}
    return estadoList

Some suggestions:

Create a class to store strings with SQL, thus facilitating reuse in other classes.
A class with all the queries you'll need.