如何同时从recyclerView和sqlite数据库中删除行?

我正在使用回收者视图和SQLite数据库创建一个应用程序.当用户输入一些数据时，它会显示在回收者"视图中，并且还会添加到我的数据库中.现在，我想在回收者视图中实现delete功能.

I'm creating an app with recycler view and SQLite database. When user enters some data, it is displayed in recycler view and also added to my database. Now I want to implement delete functionality in recycler view.

我想要的东西:

我想同时从数据库和回收者视图中删除所需的行，而不会得到任何意外结果.并且所有行均应删除.

I want to delete the required row from database and also from recycler view at the same time, without getting any unexpected results. And all the rows should be deleted.

我尝试过的事情:

我已经在回收站视图的cardView上实现了onLongClickListener(我使用cardView作为回收站视图的行).现在，当使用它的长按时，我将获得适配器位置.并删除该位置的数据库条目.

I've implemented onLongClickListener on cardView of recycler view (I'm using cardView as the row of recycler view). now when use long clicks its, I'm getting adapter position. and delete the entry of database at that position.

但是，这给了我意外的结果，例如:再次创建回收器视图的活动时，所有在实际删除行下面的删除行或一次删除的行都会再次出现，并且永远不会删除最后2-3行，数据库条目已被删除.

But this gives me unexpected results like: All the rows deleted which are below the actual deleting row or the row which are deleted once appears back when the activity of recycler view is again created and never deleting last 2-3 rows, which database entries are deleted already.

我的回收站视图适配器代码是:

My code of adapter of recycler view is:

public class AdapterForMain extends RecyclerView.Adapter<AdapterForMain.ViewHolder>{
ArrayList<String> mDataset;
ArrayList<String> mfooterSet;

private int[] icon;
MainActivity context;
DatabaseHelper myDb;


public class ViewHolder extends RecyclerView.ViewHolder implements View.OnClickListener{
    // each data item is just a string in this case

    public TextView txtHeader;
    public TextView txtFooter;
    public ImageView imgView;
 //   MainActivity mainActivity;

    CardView cardView;

    public ViewHolder(View v) {
        super(v);
        txtHeader = (TextView) v.findViewById(R.id.firstLine);
        txtFooter = (TextView) v.findViewById(R.id.secondLine);
        imgView = (ImageView) v.findViewById(R.id.icon);

        cardView = (CardView)v.findViewById(R.id.cardView);
        cardView.setOnClickListener(this);
        cardView.setOnLongClickListener(new View.OnLongClickListener() {
            @Override
            public boolean onLongClick(View view) {
                myDb = new DatabaseHelper(context);

                int detingPos = getAdapterPosition();
                boolean isDeleted = myDb.deleteEntry(detingPos);

                if(isDeleted){
                    mDataset.remove(getAdapterPosition());
                    notifyItemRemoved(getAdapterPosition());
                    notifyItemRangeChanged(getAdapterPosition(),mDataset.size());

                }
                Toast.makeText(context,"Delete from here",Toast.LENGTH_SHORT).show();

                  return true;
            }
        });
    }

    @Override
    public void onClick(View view) {

       // Toast.makeText(context,Integer.toString(getAdapterPosition()),Toast.LENGTH_SHORT).show();
        context.detailActivity(getAdapterPosition(),mDataset.get(getAdapterPosition()),mfooterSet.get(getAdapterPosition()));
    }
}


// Provide a suitable constructor (depends on the kind of dataset)
public AdapterForMain(ArrayList<String> myDataset, ArrayList<String> myFooterSet, int[] images, MainActivity context0) {
    icon = images;
    mDataset = myDataset;
    mfooterSet = myFooterSet;
    context = context0;
}

// Create new views (invoked by the layout manager)
@Override
public AdapterForMain.ViewHolder onCreateViewHolder(ViewGroup parent,
                                               int viewType) {
    // create a new view
    View v = LayoutInflater.from(parent.getContext()).inflate(R.layout.row_main, parent, false);
    // set the view's size, margins, paddings and layout parameters
    ViewHolder vh = new ViewHolder(v);

    return vh;
}

// Replace the contents of a view (invoked by the layout manager)
@Override
public void onBindViewHolder(ViewHolder holder, final int position) {
    // - get element from your dataset at this position
    // - replace the contents of the view with that element
    final String name = mDataset.get(position);
    holder.txtHeader.setText(mDataset.get(position));
    holder.txtHeader.setOnClickListener(new OnClickListener() {
        @Override
        public void onClick(View v) {
            //  Toast.makeText(AdapterForMain.this,"Settings Activity is under Construction.",Toast.LENGTH_SHORT).show();
        }
    });

    holder.txtFooter.setText(mfooterSet.get(position));
    holder.imgView.setImageResource(icon[position%1]);
}

// Return the size of your dataset (invoked by the layout manager)
@Override
public int getItemCount() {
    return mDataset.size();
}}

和delete方法的代码:

    public boolean deleteEntry(int row) {
        SQLiteDatabase db=this.getWritableDatabase();
        db.delete(TABLE_NAME, COL_1 + "=" + row,null);
        return true;
    }

我已经看到了以下链接的解决方案，但无法获得我想要的确切解决方案.

I've seen the following link for the solution but can't get exact solution for what I want.

链接1
>链接2 >

Link 1
Link 2