Insert selected SPINNER item into SQLITE

Question

How to identify the selected item in the SPINNER and insert it into the SQLITE database.

I can do the Insert in Sqlite using the data provided in Edittext, however I am not able to create a way to do something similar with SPINNER.

Code:

    @Override
    protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.recadastramento);

    marca = (EditText) findViewById(R.id.ed_marca);
    modelo = (EditText) findViewById(R.id.ed_modelo);
    constante = (EditText) findViewById(R.id.ed_constante);
    data_fabricacao = (EditText) findViewById(R.id.ed_fabricacao);
    salvar = (Button) findViewById(R.id.btn_salvar);

    myDb = new DatabaseHelper(this);
    AddData();

    spiner_constante = (Spinner) findViewById(R.id.sp_constante);
    spiner_constante.setOnItemSelectedListener(this);

    loadSpinnerData();

    private void loadSpinnerData() {
    DatabaseHelper db = new DatabaseHelper(getApplicationContext());

    List<Integer> constante = db.GetAllConstante();

    ArrayAdapter<Integer> dataAdapter3 = new ArrayAdapter<Integer> (this,android.R.layout.simple_spinner_item,constante);

    spiner_constante.setAdapter(dataAdapter3);
    dataAdapter3.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
}


public void AddData() { // AQUI É FEITO O INSERT DOS DADOS DOS EDITTEXT, NO SQLITE

    salvar.setOnClickListener(
            new View.OnClickListener() {
                @Override
                public void onClick(View v) {
                    boolean isInserted = myDb.insertData(marca.getText().toString(), modelo.getText().toString(), constante.getText().toString(), data_fabricacao.getText().toString());


}

}

Answer 1

You failed to copy the method you had to implement, onItemSelected.

You must implement the following in this method:

@Override
    public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
        //Ele irá retornar o objeto selecionado no Spinner conforme o tipo que você utilizou para preencher o ArrayAdapter, no seu caso.
        objeto = parent.getItemAtPosition(position);
        // Após pegar o objeto selecionado é só fazer a inserção na base de dados
        myDb.insertData(objeto);
    }

I hope I helped! Good luck!

Answer 2

Once you have the list of items from Spinner with this code snippet:

List<Integer> constante = db.GetAllConstante();

Just use it to get which item is selected:

constante.get(spinner.getSelectedItemPosition())

And then, this value be entered into the database, along with its other values. This discards the use of the OnItemSelectedListener, since its intention is not to carry out this action by selecting an item from Spinner yes on the button Save (unless you are using for another action).