Get database ID when selecting option in spinner?

Question

Get database ID when selecting option in spinner?

Navigation

#1 by (1 votes)

1

Generally I get the ID of a selected / clicked object with onItemClickListener , but it does not work with Spinner .

I've tried it this way:

spn.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
   @Override
   public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
       test1 = position;
       test2 = (int) id;
       test3 = view.getId();
   }

   @Override
   public void onNothingSelected(AdapterView<?> parent) {
   }
});

Also unsuccessful, it returns only the position of the items within the spinner , not the database ID.

Any ideas?

Edit : It's worth mentioning that this is all within onItemClickListener of a Custom List View , and Spinner is in a Custom Dialog part.

android sqlite

asked by anonymous 30.01.2015 / 02:39

1 answer

How to create a system to list the most popular images in my application Graphics with Crystal Reports

score 1 · Accepted Answer

You can use the getSelectedItem method to get the value of a selected item.

Create the following class SpinnerObject :

public class SpinnerObject {

    private  int databaseId;
    private String databaseValue;

    public SpinnerObject ( int databaseId , String databaseValue ) {
        this.databaseId = databaseId;
        this.databaseValue = databaseValue;
    }

    public int getId () {
        return databaseId;
    }

    public String getValue () {
        return databaseValue;
    }

    @Override
    public String toString () {
        return databaseValue;
    }

}

Now you will have to create the list as follows:

public List < SpinnerObject> getAllLabels(){
    List < SpinnerObject > labels = new ArrayList < SpinnerObject > ();
    // Seleciona todas as consultas
    String selectQuery = "SELECT  * FROM " + TABLE_LABELS;

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

    // Loop através de todas as linhas e adicionando à lista
    if ( cursor.moveToFirst () ) {
        do {
            labels.add ( new SpinnerObject ( cursor.getString(0) , cursor.getString(1) ) );
        } while (cursor.moveToNext());
    }

    // Fecha conexão
    cursor.close();
    db.close();

    return labels;
}

Now that you have the list of objects with values and ids, you load Spinner as follows:

private void loadSpinnerDataHama() {
    // database handler
    DatabaseSpinner db = new DatabaseSpinner(getApplicationContext()); 
    List <SpinnerObject> lables = db.getAllLabels();
    // Criando adaptador para o spinner
    ArrayAdapter<SpinnerObject> dataAdapter = new ArrayAdapter<SpinnerObject>(this,
    android.R.layout.simple_spinner_item, lables);
    dataAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
    // Anexando adaptador de dados para o spinner
    spn.setAdapter(dataAdapter);
}

spinner will display the values, even though they have their ids (from the database) as well.

To retrieve the ID of the selected item:

int itemId = Integer.parseInt(((SpinnerObject) spn.getSelectedItem()).getId());

Reference