How to get other values from the selected Spinner item than shown?

Question

Doubt:

How do I find the value of the field handle concerning the nome that was selected in the Spinner ?

Setting:

Table clientes

Campos _id, handle, nome

The ArrayList of Spinner is established as follows:

public ArrayList<String> getClientes(){

        sqLiteDatabase = banco.getReadableDatabase();
        ArrayList<String> clientes = new ArrayList<>();
        Cursor cursor = sqLiteDatabase.rawQuery("SELECT nome FROM clientes ORDER BY nome", null);
        if(cursor != null && cursor.moveToFirst()){
            do{
                clientes.add(cursor.getString(cursor.getColumnIndex("nome")));
            }while(cursor.moveToNext());
        }
        return clientes;
    }

Answer 1

The information you can get from the selected Spinner item is only the one stored in the Arraylist that is used by the Adapter.

As far as I can tell, Arraylist only guards the column name.

Define a class that represents a client:

public class Cliente{

    private int id;
    private int handle;
    private String nome;

    public Cliente(int id, int handle, String nome){

        this.id = id;
        this.handle = handle;
        this.nome = nome;
    }

    public int getId(){
        return id;
    }

    public int getHandle(){
        return handle;
    }

    public String nome(){
        return nome;
    }

    //O que este método retornar é o que Spinner mostrará.
    @Override
    public String toString()
    {
        return nome;
    }
} 

This class must be the type used by Arraylist to be used by Adapter.

Change the method getClientes() to return ArrayList<Cliente>:

public ArrayList<Cliente> getClientes(){

    sqLiteDatabase = banco.getReadableDatabase();
    ArrayList<Cliente> clientes = new ArrayList<>();
    Cursor cursor = sqLiteDatabase.rawQuery("SELECT * FROM clientes ORDER BY nome", null);
    if(cursor != null && cursor.moveToFirst()){
        do{
            int id = cursor.getInt(cursor.getColumnIndex("_id")));
            int handle = cursor.getInt(cursor.getColumnIndex("handle")));
            String nome = cursor.getString(cursor.getColumnIndex("nome")));
            Cliente cliente = new Cliente(id, handle, nome);
            clientes.add(cliente);
        }while(cursor.moveToNext());
    }
    return clientes;
}

Get the selected Customer with:

Cliente cliente = ((cliente)spinner.getSelectedItem());

and Handle with:

int handle = cliente.getHandle();