lundi 17 août 2015

SQLite Data to Spinner

I have a method that gets all values in the sqlite table. The application uses SQLITE. Now, I want to make these data load in the spinner. How will I do that?

public List getAllOutlet(){

    List<Outlet> outletlist = new ArrayList<>();
    // Select All Query
    String selectQuery = "SELECT  * FROM " + TABLE_OUTLET;

    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);

    // looping through all rows and adding to list
    if (cursor.moveToFirst()) {
        do {
            Outlet outlet = new Outlet();
            outlet.setOID(Integer.parseInt(cursor.getString(1)));
            outlet.setOutletname((cursor.getString(2)));
            outlet.setOCode(cursor.getString(3));
            // Adding outlet to list
            outletlist.add(outlet);
        } while (cursor.moveToNext());
    }

    // return outlet list
    return outletlist;
}

Aucun commentaire:

Enregistrer un commentaire