Populate spinner from database content (SQLite)

Question

How can I populate a spinner content from database (SQLite)

I have POJO: categories, contain id and name, I have the table already, with a function to get the ArrayList like this:

public List<SetcardCategory> getAllSetcardCategory()
{
    List<SetcardCategory> setcardCategories = new ArrayList<SetcardCategory>();
    String selectQuery = "SELECT  * FROM " + TABLE_SETCARD_CATEGORIES;

    SQLiteDatabase db = this.getReadableDatabase();
    Cursor c = db.rawQuery(selectQuery, null);

    // looping through all rows and adding to list
    if (c.moveToFirst()) {
        do {
            SetcardCategory setcardCategory = new SetcardCategory();
            setcardCategory.setId(c.getInt((c.getColumnIndex("id"))));
            setcardCategory.setName(c.getString(c.getColumnIndex("name")));

            // adding to tags list
            setcardCategories.add(setcardCategory);
        } while (c.moveToNext());
    }
    return setcardCategories;
}

Then on Activity I call it like this:

List<SetcardCategory> setcardCategories = db.getAllSetcardCategory();
    ArrayAdapter<SetcardCategory> arrayAdapter = new ArrayAdapter<SetcardCategory>(
            this, android.R.layout.simple_spinner_item, setcardCategories);
    arrayAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
    Spinner sItems = (Spinner) findViewById(R.id.setcardCategory);
    sItems.setAdapter(arrayAdapter);

when I run it, it loads string like this: "schema.SetcardCategory@22293c98" and many others values similar to that.

How can I populate the spinner to show the name field as a label, and id field as the value that we fetch to save into DB?

in the pojo class overide tostring method and return the value you want to display in the spinner — Manoj kumar
– Manoj kumar, Commented Nov 17, 2017 at 6:23
you can do that just in 5 lines of code by using SimpleCursorAdapter — pskink
– pskink, Commented Nov 17, 2017 at 7:47

Manoj kumar · Accepted Answer · 2017-11-17 06:25:24Z

3

class Pojo{
 private String name;
  @Override
    public String toString() {
        return name;
    }
}

do it like this in the pojo class, so this will return a value for the object when it uses the to string method in the adapter, to load the data

answered Nov 17, 2017 at 6:25

Manoj kumar

4704 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

J.R · Accepted Answer · 2017-11-17 06:44:06Z

2

Solution 1 Overide the toString method in your SetcardCategory class

class SetcardCategory {
...
...
@Override
    public String toString() {
        return this.name;
    }
}

Solution 2 If you just want to show the name, Just pick name only from DB

public List<String> getAllSetcardCategory()
    {
        List<String> setcardCategories = new ArrayList<String>();
        String selectQuery = "SELECT  * FROM " + TABLE_SETCARD_CATEGORIES;

        SQLiteDatabase db = this.getReadableDatabase();
        Cursor c = db.rawQuery(selectQuery, null);

        // looping through all rows and adding to list
        if (c.moveToFirst()) {
            do {
                // adding to tags list
                setcardCategories.add(c.getString(c.getColumnIndex("name")));
            } while (c.moveToNext());
        }
        return setcardCategories;
    }

And create Array Adapter as

List<String> setcardCategories = db.getAllSetcardCategory();
    ArrayAdapter<SetcardCategory> arrayAdapter = new ArrayAdapter<SetcardCategory>(
            this, android.R.layout.simple_spinner_item, setcardCategories);
    arrayAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);

edited Nov 17, 2017 at 6:44

answered Nov 17, 2017 at 6:30

J.R

2,16320 silver badges21 bronze badges

4 Comments

Gabriel Over a year ago

by using this one, i cannot fetch the id, right? Manoj kumar answer fit the situation better

J.R Over a year ago

I given both solutions. I have given the second solution because of looks like you only need the name.

Gabriel Over a year ago

oh ya, im so sorry, i saw Manoj answer first, but actually your answer posted first.

pskink Over a year ago

@Gabriel no, it does not provide valid row IDs in the adapter, for that you should use CursorAdapter - for example SimpleCursorAdapter

Collectives™ on Stack Overflow

Populate spinner from database content (SQLite)

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related