java - 如何在 arrayadapter 中获取 openOrCreateDatabase

Question

我正在尝试访问数组适配器内的数据库以从列表中删除项目。但代码无法解析 openOrCreateDatabase 方法或符号 MODE_PRIVATE。

我的代码:

public class workoutListViewAdapter extends ArrayAdapter<String> {

public workoutListViewAdapter(Context context, ArrayList<String> values) {
    super(context, R.layout.workout_row_layout, values);
}

@Override
public View getView(int position, View convertView, ViewGroup parent) {

    final LayoutInflater theInflater =  LayoutInflater.from(getContext());

    final View theView = theInflater.inflate(R.layout.workout_row_layout,
            parent, false);

    //Handle buttons and add onClickListeners
    ImageButton deleteButton = (ImageButton)theView.findViewById(R.id.delete_button);

    deleteButton.setOnClickListener(new View.OnClickListener(){
        @Override
        public void onClick(View v) {
            removeWorkout(id);
            notifyDataSetChanged();
        }
    });


    return theView;
}

private void removeWorkout(int id) {
    SQLiteDatabase workoutDB = this.openOrCreateDatabase("Database.sqlite", MODE_PRIVATE, null);

    workoutDB.execSQL("DELETE FROM table WHERE id = " + id + ";");

}

Answer 1

要访问MODE_PRIVATE和openOrCreateDatabase，您必须使用 Activity 上下文。