为了实现歌迷用户能够增删参加的演唱会信息的功能，并将其集成到“查看参加的演唱会信息”界面上，我们可以按照以下步骤进行设计： ### 1. **定义增删演唱会的函数** #### a. **增加参加的演唱会** 我们首先创建一个名为 `add_favorite_concert` 的函数，它允许歌迷选择并添加他们想要参加的演唱会。 ```python def add_favorite_concert(parent_window, fan_id): def submit(): selected_concert_id = concert_id_var.get() if not selected_concert_id.strip(): messagebox.showwarning("警告", "请选择一个演唱会") return try: db = connect_db() cur = db.cursor() # Check for duplicate entry cur.execute(""" SELECT COUNT(*) FROM fanconcerts WHERE FanID=%s AND ConcertID=%s """, (fan_id, selected_concert_id)) count = cur.fetchone()[0] if count > 0: messagebox.showwarning("提示", "已经存在该条参加的演唱会记录") return # Insert into fanconcerts table cur.execute(""" INSERT INTO fanconcerts (FanID, ConcertID) VALUES (%s, %s) """, (fan_id, selected_concert_id)) db.commit() messagebox.showinfo("成功", "添加成功") popup.destroy() refresh_concerts_list() except pymysql.Error as e: messagebox.showerror("错误", f"添加失败: {str(e)}") db.rollback() finally: db.close() # Create popup window popup = Toplevel(parent_window) popup.title("增加参加的演唱会") popup.geometry("400x200") Label(popup, text="请选择您想添加的演唱会").pack(pady=10) concert_id_var = StringVar() # Get all concert IDs for combobox options all_concert_ids = [str(concert[0]) for concert in get_all_concerts()] concert_combobox = Combobox(popup, values=all_concert_ids, textvariable=concert_id_var) concert_combobox.pack(pady=10) btn_submit = Button(popup, text="提交", command=submit) btn_submit.pack(pady=10) popup.wait_window() # Wait for the window to be closed ``` #### b. **删除参加的演唱会** 接下来，我们创建一个名为 `delete_favorite_concert` 的函数，它允许歌迷从已参加的演唱会列表中删除某项。 ```python def delete_favorite_concert(listbox_widget): selected_index = listbox_widget.curselection() if len(selected_index) == 0: messagebox.showwarning("警告", "请选择一条记录") return item = listbox_widget.get(selected_index) concert_id = item.split('|')[0].strip() try: db = connect_db() cur = db.cursor() # Delete from fanconcerts table cur.execute(""" DELETE FROM fanconcerts WHERE FanID=%s AND ConcertID=%s """, (fan_id, concert_id)) db.commit() messagebox.showinfo("成功", "删除成功") # Refresh the listbox content after deletion refresh_concerts_list() except pymysql.Error as e: messagebox.showerror("错误", f"删除失败: {str(e)}") db.rollback() finally: db.close() ``` #### c. **刷新演唱会列表** 我们需要一个辅助函数 `refresh_concerts_list()` 来重新加载并显示最新的演唱会信息。 ```python def refresh_concerts_list(): fanconcerts_listbox.delete(0, END) rels = get_fanconcerts_info() for idx, rel in enumerate(rels, start=1): fanconcerts_listbox.insert(END, f"{rel[0]} | {rel[2]} | {rel[3]} | {rel[4]}") fanconcerts_listbox.update() ``` ### 2. **修改 `show_fanconcerts_window` 函数以集成上述功能** 现在我们将这些新增和删除按钮集成到现有的 `show_fanconcerts_window` 函数中： ```python def show_fanconcerts_window(win): global fanconcerts_listbox # Define as global variable root = Toplevel(win) root.title("歌迷参加的演唱会信息") root.geometry("600x500") listbox_frame = Frame(root) listbox_frame.pack(side="top", fill="both", expand=True) title_label = Label(listbox_frame, text="演唱会 ID 演唱会名称 举办日期 地点", font=("Arial", 12), anchor='w') title_label.pack(side="top", fill="x") scrollbar = Scrollbar(listbox_frame) scrollbar.pack(side="right", fill="y") fanconcerts_listbox = Listbox(listbox_frame, selectmode=SINGLE, yscrollcommand=scrollbar.set) fanconcerts_listbox.pack(side="left", fill="both", expand=True) scrollbar.config(command=fanconcerts_listbox.yview) rels = get_fanconcerts_info() for idx, rel in enumerate(rels, start=1): fanconcerts_listbox.insert(END, f"{rel[0]} | {rel[2]} | {rel[3]} | {rel[4]}") fanconcerts_listbox.update() btn_add = Button(root, text="增加参加的演唱会", command=lambda: add_favorite_concert(root, fan_id)) btn_add.pack(side="left", padx=10, pady=10) btn_delete = Button(root, text="删除参加的演唱会", command=lambda: delete_favorite_concert(fanconcerts_listbox)) btn_delete.pack(side="right", padx=10, pady=10) root.protocol("WM_DELETE_WINDOW", lambda: (root.destroy(), refresh_concerts_list())) ``` 通过以上代码，我们现在有了完整的逻辑来让歌迷用户管理他们所参加的演唱会信息，并且可以通过图形界面直观地进行增删操作。