Android Studio中点击RecyclerView时如何获取数据库ID？

核心问题是你没把数据库的唯一ID和RecyclerView的列表项绑定，导致只能通过名称查询（会匹配多条）。直接把ID存入CourseModal，从数据库加载数据时就带上ID，点击项时直接传递ID到操作页面，就能精准定位单条记录。

1. 完善CourseModal的构造与属性 #

先补上带ID的构造函数，确保加载数据时能把数据库ID赋值给Modal：

public class CourseModal {
    private String studentName;
    private String studentSubject;
    private String studentHours;
    private String studentCore;
    private int id; // 数据库唯一ID

    // 新增带ID的构造函数
    public CourseModal(int id, String studentName, String studentSubject, String studentHours, String studentCore) {
        this.id = id;
        this.studentName = studentName;
        this.studentSubject = studentSubject;
        this.studentHours = studentHours;
        this.studentCore = studentCore;
    }

    // 保留原有无ID构造（若需要创建新记录时使用）
    public CourseModal(String studentName, String studentSubject, String studentHours, String studentCore) {
        this.studentName = studentName;
        this.studentSubject = studentSubject;
        this.studentHours = studentHours;
        this.studentCore = studentCore;
    }

    // 已有的getter/setter保留
    public int getId() { return id; }
    public void setId(int id) { this.id = id; }
    public String getStudentName() { return studentName; }
    public void setStudentName(String studentName) { this.studentName = studentName; }
    public String getStudentSubject() { return studentSubject; }
    public void setStudentSubject(String studentSubject) { this.studentSubject = studentSubject; }
    public String getStudentHours() { return studentHours; }
    public void setStudentHours(String studentHours) { this.studentHours = studentHours; }
    public String getStudentCore() { return studentCore; }
    public void setStudentCore(String studentCore) { this.studentCore = studentCore; }
}

2. 从数据库加载数据时包含ID #

修改数据加载方法，把数据库ID一并查询并赋值给每个CourseModal：

public ArrayList<CourseModal> getAllCourses() {
    ArrayList<CourseModal> courseList = new ArrayList<>();
    SQLiteDatabase db = this.getReadableDatabase();
    // 查询所有字段，包含ID
    Cursor cursor = db.rawQuery("SELECT * FROM " + TABLE_NAME, null);

    if (cursor.moveToFirst()) {
        do {
            CourseModal modal = new CourseModal(
                    cursor.getInt(cursor.getColumnIndex(ID_COL)), // 读取数据库ID
                    cursor.getString(cursor.getColumnIndex(NAME_COL)),
                    cursor.getString(cursor.getColumnIndex(SUBJECT_COL)), // 替换为你的真实列名
                    cursor.getString(cursor.getColumnIndex(HOURS_COL)),
                    cursor.getString(cursor.getColumnIndex(CORE_COL))
            );
            courseList.add(modal);
        } while (cursor.moveToNext());
    }
    cursor.close();
    return courseList;
}

3. RecyclerView点击时传递ID #

在onBindViewHolder中，点击列表项时把ID通过Intent传递到更新页面：

@Override
public void onBindViewHolder(@NonNull ViewHolder holder, int position) {
    CourseModal modal = courseModalArrayList.get(position);

    holder.studentNameRV.setText(modal.getStudentName());
    holder.studentCoreRV.setText(modal.getStudentCore());
    holder.studentSubjectRV.setText(modal.getStudentSubject());
    holder.studentHoursRV.setText(modal.getStudentHours());

    holder.itemView.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            Intent i = new Intent(context, UpdateCourseActivity.class);
            // 新增传递数据库ID
            i.putExtra("id", modal.getId());
            i.putExtra("name", modal.getStudentName());
            i.putExtra("core", modal.getStudentCore());
            i.putExtra("subject", modal.getStudentSubject());
            i.putExtra("hours", modal.getStudentHours());

            context.startActivity(i);
        }
    });
}

4. 更新页面直接用ID操作 #

不用再查询Cursor，直接获取Intent中的ID，调用更新方法：

updateCourseBtn.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View v) {
        // 获取传递的ID，-1为默认值（表示无效）
        int courseId = getIntent().getIntExtra("id", -1);
        if (courseId == -1) {
            Toast.makeText(UpdateCourseActivity.this, "无效的课程ID", Toast.LENGTH_SHORT).show();
            return;
        }

        // 调用更新方法，用ID作为唯一条件
        dbHandler.updateCourse(
                String.valueOf(courseId),
                studentNameUpd.getText().toString(),
                studentSubjectUpd.getText().toString(),
                studentHoursUpd.getText().toString(),
                studentCoreUpd.getText().toString()
        );

        Toast.makeText(UpdateCourseActivity.this, "课程已更新", Toast.LENGTH_SHORT).show();
        startActivity(new Intent(UpdateCourseActivity.this, MainActivity.class));
    }
});

5. 确保update方法基于ID执行 #

你的updateCourse方法需要用ID作为WHERE条件，确保只修改单条记录：

public void updateCourse(String id, String name, String subject, String hours, String core) {
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(NAME_COL, name);
    values.put(SUBJECT_COL, subject);
    values.put(HOURS_COL, hours);
    values.put(CORE_COL, core);

    // 用ID作为唯一匹配条件，仅更新对应记录
    db.update(TABLE_NAME, values, ID_COL + " = ?", new String[]{id});
    db.close();
}

改完后，点击RecyclerView任意项都会直接拿到对应数据库的唯一ID，更新/删除时只会操作目标记录，不会再出现批量修改同名数据的问题。原来的getDbId方法可以直接删除，完全不再需要。

内容的提问来源于stack exchange，提问作者Orionbobo