为了实现歌迷用户增删喜欢的乐队信息的功能，我们需要定义两个主要函数：一个用于添加新的喜欢的乐队（`add_favorite_band`），另一个用于删除已有的喜欢的乐队（`remove_favorite_band`）。这两个功能都将与数据库中的`fanbands`表进行交互。以下是具体的实现： ### 1. 函数定义 #### a. 添加喜欢的乐队 (`add_favorite_band`) 该函数接收歌迷ID (`fan_id`) 和乐队ID (`band_id`) 作为参数，并向`fanbands`表中插入一条新记录。 ```python def add_favorite_band(fan_id, band_id): try: db = connect_db() cur = db.cursor() # Check if the combination already exists sql_check = "SELECT COUNT(*) FROM fanbands WHERE FanID=%s AND BandID=%s" cur.execute(sql_check, (fan_id, band_id)) count = cur.fetchone()[0] if count > 0: messagebox.showwarning("警告", "您已经喜欢这个乐队") return # Insert into fanbands sql_insert = "INSERT INTO fanbands (FanID, BandID) VALUES (%s, %s)" cur.execute(sql_insert, (fan_id, band_id)) db.commit() messagebox.showinfo("成功", "添加成功") except pymysql.Error as e: messagebox.showerror("错误", f"添加失败: {str(e)}") db.rollback() finally: db.close() ``` #### b. 删除喜欢的乐队 (`remove_favorite_band`) 该函数同样接收歌迷ID (`fan_id`) 和乐队ID (`band_id`) 作为参数，并从`fanbands`表中删除对应的记录。 ```python def remove_favorite_band(fan_id, band_id): try: db = connect_db() cur = db.cursor() # Delete from fanbands sql_delete = "DELETE FROM fanbands WHERE FanID=%s AND BandID=%s" affected_rows = cur.execute(sql_delete, (fan_id, band_id)) if affected_rows > 0: db.commit() messagebox.showinfo("成功", "删除成功") else: messagebox.showwarning("警告", "未找到相关记录") except pymysql.Error as e: messagebox.showerror("错误", f"删除失败: {str(e)}") db.rollback() finally: db.close() ``` ### 2. UI 界面集成 接下来，需要为上述两个功能创建图形用户界面（GUI）以便于歌迷使用。我们可以为每个功能分别创建一个小窗体，让用户选择或输入相关的乐队ID。 #### a. 添加喜欢的乐队 GUI (`add_favorite_band_window`) ```python def add_favorite_band_window(win): add_win = Toplevel(win) add_win.title("添加喜欢的乐队") add_win.geometry("400x200") Label(add_win, text="添加喜欢的乐队", font="微软雅黑 14").pack(pady=10) Label(add_win, text="请选择乐队 ID", font="微软雅黑 12").pack(pady=5) band_id_combobox = Combobox(add_win, values=get_band_ids(), width=30) band_id_combobox.set("请选择乐队 ID") band_id_combobox.pack(pady=10) Button(add_win, text="确认添加", command=lambda: add_favorite_band(fan_id, band_id_combobox.get())).pack(pady=10) def get_band_ids(): try: db = connect_db() cur = db.cursor() cur.execute("SELECT BandID FROM bands") results = [row[0] for row in cur.fetchall()] return results except pymysql.Error as e: print(f"获取乐队 ID 失败: {str(e)}") return [] finally: db.close() ``` #### b. 删除喜欢的乐队 GUI (`remove_favorite_band_