How to save data from spinner to SQLite?

[Malavika Shanker]

Hello! I'm brand new-ish to app development so here's what I'm trying to do
1.Take the selected option from the spinner(there are two), convert it to string, and then save it to SQLite database for viewing it using a card view.
2.The issue I'm facing here is that in the lines 64 and 65 of the third code block setText is obviously wrong. I don't know what else I should do to prevent this error and make the holder work.

spinner2.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
            @Override
            public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
                String string = (String) spinner2.getItemAtPosition(spinner2.getSelectedItemPosition());
                Toast.makeText(MainActivity2.this,  string, Toast.LENGTH_SHORT).show();

            }

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

            }
        });
        spinner.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {      @Override
        public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
            String string = (String) spinner.getItemAtPosition(spinner.getSelectedItemPosition());
            Toast.makeText(MainActivity2.this,  string, Toast.LENGTH_SHORT).show();

        }

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

        }
    });

 package com.example.myrecipiebook;



public class recipe {
    private int id;
    private String name;
    private String serves;
    private String difficulty;
    private String meal;
    private String ingredients;
    private String recipe;
    private String time;
    byte[] image;



    public recipe(int id, String name, String serves, String difficulty, String meal, String ingredients, String recipe, String time) {
        this.id = id;
        this.name = name;
        this.serves = serves;
        this.difficulty = difficulty;
        this.meal = meal;
        this.ingredients = ingredients;
        this.recipe = recipe;
        this.time = time;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getServes() {
        return serves;
    }

    public void setServes(String serves) {
        this.serves = serves;
    }

    public String getDifficulty() {
        return difficulty;
    }

    public void setDifficulty(String difficulty) {
        this.difficulty = difficulty;
    }

    public String getMeal() {
        return meal;
    }

    public void setMeal(String meal) {
        this.meal = meal;
    }

    public String getIngredients() {
        return ingredients;
    }

    public void setIngredients(String ingredients) {
        this.ingredients = ingredients;
    }

    public String getRecipe() {
        return recipe;
    }

    public void setRecipe(String recipe) {
        this.recipe = recipe;
    }

    public String getTime() {
        return time;
    }

    public void setTime(String time) {
        this.time = time;
    }

    public byte[] getImage() {
        return image;
    }

    public void setImage(byte[] image) {
        this.image = image;
    }
}

public class RecipeBAdapter extends BaseAdapter {
    private Context context;
    private int layout;
    private ArrayList<recipe> recipelist;

    public RecipeBAdapter(Context context, int layout, ArrayList<recipe> recipelist) {
        this.context = context;
        this.layout = layout;
        this.recipelist = recipelist;
    }

    @Override
    public int getCount() {
        return recipelist.size();
    }

    @Override
    public Object getItem(int position) {
        return recipelist.get(position);
    }

    @Override
    public long getItemId(int position) {
        return position;
    }
    private class ViewHolder{
        ImageView addimage;
        TextView Title;
        TextView Type;
        TextView Prep;
        TextView Time;
        TextView Serves;
        Spinner spinner;
        Spinner spinner2;
    }

    @Override
    public View getView(int position, View view, ViewGroup viewGroup) {
        View row = view;
        ViewHolder holder = new ViewHolder();
        if(row==null){
            LayoutInflater inflater = (LayoutInflater) context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
            row = inflater.inflate(layout,null);

            holder.Title= (TextView) row.findViewById(R.id.Title);
            holder.Prep=(TextView) row.findViewById(R.id.Prep);
            holder.Time= (TextView) row.findViewById(R.id.Time);
            holder.Serves= (TextView) row.findViewById(R.id.Serves);
            holder.Type= (TextView) row.findViewById(R.id.Type);
            holder.spinner= (Spinner) row.findViewById(R.id.spinner);
            holder.spinner2 = (Spinner) row.findViewById(R.id.spinner2);
            holder.addimage= (ImageView) row.findViewById(R.id.addimage);

            row.setTag(holder);
        }
        else{
            holder=(ViewHolder) row.getTag();
        }
        recipe recipe= recipelist.get(position);
        holder.Title.setText(recipe.getName());
        holder.Prep.setText(recipe.getIngredients());
        holder.Time.setText(recipe.getTime());
        holder.Serves.setText(recipe.getServes());
        holder.spinner.setText(recipe.getMeal());
        holder.spinner2.setText(recipe.getDifficulty());

        return row;
    }
}

[Malavika Shanker]

Spinner here is for meal and spinner2 here us for difficulty level!!!

[Randy Tong]

I'm facing here is that in the lines 64 and 65 of the third code block setText is obviously wrong.

What's the error?

[Randy Tong]

Malavika Shanker wrote:Spinner here is for meal and spinner2 here us for difficulty level!!!

And what you get now?  

[Malavika Shanker]

It says cannot resolve method setText in spinner

[Randy Tong]

You can use setSelection instead of setText. Get the position of recipe.getMeal() from your spinner and set to it.

Here the example

holder.spinner.setSelection(getIndex(holder.spinner, recipe.getMeal()));

 private int getIndex(Spinner spinner, String myString){
     for (int i=0;i<spinner.getCount();i++){
         if (spinner.getItemAtPosition(i).toString().equalsIgnoreCase(myString)){
             return i;
         }
     }
     return 0;
 } 

[Tim Moores]

In the future, please do not start several topics for the same question, especially if you have answers already. I have now closed the other one where you asked essentially the same question.