如何在使用ListView时删除SQLite中的重复项

// 步骤1：连接SQLite数据库
SQLiteOpenHelper dbHelper = new SQLiteOpenHelper(context, "mydb", null, 1) {
    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建数据库表
        db.execSQL("CREATE TABLE IF NOT EXISTS mytable (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 升级数据库表
        db.execSQL("DROP TABLE IF EXISTS mytable");
        onCreate(db);
    }
};

// 步骤2：查询数据库获取数据
SQLiteDatabase db = dbHelper.getReadableDatabase();
String[] columns = {"_id", "name"};
Cursor cursor = db.query("mytable", columns, null, null, null, null, null);

// 步骤3：去除重复项
Set<String> uniqueNames = new HashSet<>();
while (cursor.moveToNext()) {
    String name = cursor.getString(cursor.getColumnIndex("name"));
    if (uniqueNames.contains(name)) {
        // 删除重复项
        db.delete("mytable", "name = ?", new String[]{name});
    } else {
        uniqueNames.add(name);
    }
}

// 步骤4：更新ListView
CursorAdapter adapter = new SimpleCursorAdapter(context, android.R.layout.simple_list_item_1, cursor, columns, new int[]{android.R.id.text1}, 0);
ListView listView = findViewById(R.id.listView);
listView.setAdapter(adapter);
adapter.notifyDataSetChanged();