How to put the values of a db column in an array?

0

I have a table, which is written below. Busy is the part I'm going to play. the value of busy will change according to the program from 0 to 1, depending on whether you are busy or not. I need to load these values into an array, how can I do this?

String QUERY_COLUNA = "CREATE TABLE " + TABELA_SLOT + "(" +
    COLUNA_CODIGO + " INTEGER PRIMARY KEY ," +
    COLUNA_BUSY + " INTEGER )";

db.execSQL(QUERY_COLUNA);

db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
db.execSQL("INSERT INTO " + TABELA_SLOT + "(BUSY) VALUES ('0')");
    
asked by anonymous 10.09.2017 / 23:33

0 answers