如何更新android sqlite数据库中勾选的自定义listview记录？

// 创建数据库表
public class MyDatabaseHelper extends SQLiteOpenHelper {
    // 定义表名和列名
    private static final String TABLE_NAME = "my_table";
    private static final String COLUMN_ID = "id";
    private static final String COLUMN_NAME = "name";
    private static final String COLUMN_DESCRIPTION = "description";

    // 构造函数
    public MyDatabaseHelper(Context context) {
        super(context, "my_database", null, 1);
    }

    // 创建表
    @Override
    public void onCreate(SQLiteDatabase db) {
        String createTableQuery = "CREATE TABLE " + TABLE_NAME + " (" +
                COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                COLUMN_NAME + " TEXT, " +
                COLUMN_DESCRIPTION + " TEXT)";
        db.execSQL(createTableQuery);
    }

    // 更新表
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 如果需要更新表结构，可以在这里进行操作
    }
}

// 在Activity中使用ListView和复选框
public class MainActivity extends AppCompatActivity {
    private ListView listView;
    private MyAdapter adapter;
    private ArrayList<Integer> selectedItems;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        listView = findViewById(R.id.listView);
        selectedItems = new ArrayList<>();

        // 设置ListView的适配器
        adapter = new MyAdapter(this);
        listView.setAdapter(adapter);

        // 设置ListView的复选框监听器
        listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            @Override
            public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
                CheckBox checkBox = view.findViewById(R.id.checkBox);
                if (checkBox.isChecked()) {
                    checkBox.setChecked(false);
                    selectedItems.remove(Integer.valueOf(position));
                } else {
                    checkBox.setChecked(true);
                    selectedItems.add(position);
                }
            }
        });

        // 更新数据库按钮的点击事件
        Button updateButton = findViewById(R.id.updateButton);
        updateButton.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                updateSelectedItems();
            }
        });
    }

    // 更新选中的记录到数据库
    private void updateSelectedItems() {
        MyDatabaseHelper dbHelper = new MyDatabaseHelper(this);
        SQLiteDatabase db = dbHelper.getWritableDatabase();

        ContentValues values = new ContentValues();
        values.put(COLUMN_DESCRIPTION, "Updated description");

        for (int position : selectedItems) {
            String selection = COLUMN_ID + " = ?";
            String[] selectionArgs = {String.valueOf(position + 1)};

            db.update(TABLE_NAME, values, selection, selectionArgs);
        }

        db.close();
    }
}

// 自定义适配器
public class MyAdapter extends BaseAdapter {
    private Context context;

    public MyAdapter(Context context) {
        this.context = context;
    }

    @Override
    public int getCount() {
        return 10; // 假设有10个记录
    }

    @Override
    public Object getItem(int position) {
        return null;
    }

    @Override
    public long getItemId(int position) {
        return 0;
    }

    @Override
    public View getView(int position, View convertView, ViewGroup parent) {
        if (convertView == null) {
            convertView = LayoutInflater.from(context).inflate(R.layout.list_item, parent, false);
        }

        CheckBox checkBox = convertView.findViewById(R.id.checkBox);
        checkBox.setChecked(false);

        return convertView;
    }
}