如何在sql lite中从数据库获取要删除的id数据-setOnLongClickListener错误

Question

我有一个recyclerview和SQLLite数据库。我将城市名称保存在SQLite数据库中，并在recyclerview中显示它们。当城市在recyclerview中设置为setOnclickListener时，城市的天气就会显示出来，我通过从SQLLite数据库中获取城市的id来实现这一点。

arrayList.get(position).id

它在setOnClickListener中工作，但在setOnLongClickListener中不工作

当我长按时，我想删除recyclerview中的城市名称，但不想删除，因为它不起作用。

此错误出现在logcat中：“java.lang.IndexOutOfBoundsException:索引：0，大小：0”或类似的内容

我如何解决这个问题？

我的适配器类

public class Adapter extends RecyclerView.Adapter<Adapter.MyViewHolder>  {

ArrayList<City> arrayList;
Context context;
SQLiteDatabase db ;
Cursor cursor;
int dbId;



public Adapter(ArrayList<City> arrayList ,Context context ){
    this.arrayList = arrayList;
    this.context = context;

    db = context.openOrCreateDatabase("City",MODE_PRIVATE,null);


}

@NonNull
@Override
public MyViewHolder onCreateViewHolder(@NonNull ViewGroup parent, int viewType) {

    RecyclerviewRowBinding recyclerviewRowBinding = 
    RecyclerviewRowBinding.inflate(LayoutInflater.from(parent.getContext()),
    parent,
    false);
    return new MyViewHolder(recyclerviewRowBinding);

}

@Override
public void onBindViewHolder(@NonNull Adapter.MyViewHolder holder, int position) {

    holder.binding.MytxtCities.setText(arrayList.get(position).cityName);


    holder.itemView.setOnLongClickListener(new View.OnLongClickListener() {
        @Override
        public boolean onLongClick(View v) {

            AlertDialog.Builder builder = new AlertDialog.Builder(context);
            builder.setIcon(R.drawable.warningicon);
            builder.setMessage("Are you sure that you want to delete "+arrayList.get(position).cityName);
            builder.setPositiveButton("Ok", (dialog, which) -> {

                arrayList.remove(position);
                notifyItemRemoved(position);
                notifyItemRangeChanged(position,arrayList.size());

                dbId = arrayList.get(position).id; // <---the error is in this code
                System.out.println("dbId"+dbId);

                //db.execSQL("DELETE FROM city WHERE id ='" + arrayList.get(position).id + "'");


                cursor = db.rawQuery("SELECT * FROM city WHERE id=?",new String[]{String.valueOf(dbId)});
                Result(cursor);



            }).setNegativeButton("Cancel", (dialog, which) -> {

                //doing nothing
            }).show();


            return true;
        }


    });


    holder.itemView.setOnClickListener(v -> {

        Intent intent = new Intent(holder.itemView.getContext(),MainActivity.class);
        intent.putExtra("citId",arrayList.get(position).id); // <-- it works very well here and sends with intent
        holder.itemView.getContext().startActivity(intent);
    });
}


private void Result(Cursor cursor){

    if(cursor.getCount() > 0){

        db.delete("city","id=?",new String[]{String.valueOf(dbId)});
        notifyDataSetChanged();
    }
    else{
        Toast.makeText(context,"something went wrong !",Toast.LENGTH_LONG).show();
    }


}


@Override
public int getItemCount() {
    return arrayList.size();
}



public class MyViewHolder extends RecyclerView.ViewHolder {
    TextView Mytxt_cities;
    private RecyclerviewRowBinding binding;

    public MyViewHolder(@NonNull RecyclerviewRowBinding binding) {
        super(binding.getRoot());
        this.binding = binding;
        Mytxt_cities = itemView.findViewById(R.id.Mytxt_cities);



    }


 }
 }

Answer 1

你的代码里有

arrayList.remove(position);

下面几行

dbId = arrayList.get(position).id; // <---the error is in this code

调用remove后，您的数组列表为空，但您仍在尝试在位置获取此项，因此您正在获取索引自动边界异常：索引：0，大小：0-您正在尝试在位置=0获取项，数组为空

尝试在从数组中删除之前移动获取dbId

            dbId = arrayList.get(position).id;
            arrayList.remove(position);
            notifyItemRemoved(position);
            //notifyItemRangeChanged(position,arrayList.size()); // this line is unnecessary