Spinner with Sqlite

Question

Hello, good evening. In my project I have a spinner

<Spinner
    android:id="@+id/spnCategorie"
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    android:entries="@array/categories_array"
    android:prompt="@string/categories_prompt" />

That one spinner is responsible for adding the value in the column CATEGORIE in my database through the class Insertproduct.class.
The categories that populate this spinner is the following:

<string-array name="categories_array">
    <item>Mantimentos</item>
    <item>Açougue</item>
    <item>Peixaria</item>
    <item>Frios</item>
    <item>Hortifruti</item>
    <item>Café da Manhã</item>
    <item>Higiene</item>
    <item>Limpeza</item>
</string-array>

I’m converting the value of spinner for String to insert into the banco de dados as follows. (I don’t know if it’s the right way.)

Spinner CATEGORIE = (Spinner) findViewById(R.id.spnCategorie);
String stringCATEGORIE = CATEGORIE.getSelectedItem().toString();
...

I have another class (Alterproduct.class) responsible for changing the values of products, would like the spinner class Alterproduct.class return the category saved in the database.

Ex: My product has been entered in the database with the category Frios, when the user clicked to change the product, it returned the value Frios in the spinner class Alterproduct.class

Att.
Giovani Rodrigo

Answer 1

I believe that what you need to do is query the value in the database and set the selected item in the spinner, this can be done using the method setSelection(int position)

If you want to set the value by the text and not by its position in the spinner options this link can help: https://stackoverflow.com/questions/2390102/how-to-set-selected-item-of-spinner-by-value-not-by-position