devbox
凡人多烦事01
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

基于mysql+python tkinter实现电影院售票系统_数据库实践作业网上订票系统(python可视化界面)

作者：凡人多烦事01 | 2024-02-21 15:51:14

赞

踩

数据库实践作业网上订票系统(python可视化界面)

电影院售票系统可作为电影院网上售票平台，对于电影院的管理员，可以为该电影院引入添加新上映的电影，也可以对该电影院的电影进行排片，即安排播放时间、放映厅、票价、电影等等，也可以对用户的订单进行增加，删除，查找，修改操作。对于用户，可以进行注册，登录，查看排片信息、订单信息和购票功能。

  1. import mysql.connector
  2. from tkinter import ttk
  3. import tkinter as tk
  4. import tkinter.font as tkFont
  5. from tkinter import *  # 图形界面库
  6. import tkinter.messagebox as messagebox
  7. import  pymysql
  8.  
  9. class beginpage :
  10.     def __init__(self,p):
  11.         p.destroy()
  12.         self.window = tk.Tk()  # 初始框的声明
  13.         self.window.title('电影院网上售票系统')
  14.         self.window.geometry('600x600')  # 这里的乘是小x
  15.         self.window.geometry('+330+0')
  16.         label = Label(self.window, text="电影院网上售票系统", font=("Verdana", 50),fg="red",bg='green')
  17.         label.pack(pady=0)
  18.         Button(self.window, text="电影院管理员登陆", font=tkFont.Font(size=20), command=lambda: adminpage(self.window), width=60,
  19.                height=2,fg='white', bg='gray').pack()
  20.         Button(self.window, text="用户登陆", font=tkFont.Font(size=20), command=lambda: UserPage(self.window), width=60,
  21.                height=2, fg='white', bg='gray').pack()
  22.         Button(self.window, text="用户注册", font=tkFont.Font(size=20), command=lambda: UserSign(self.window), width=60,
  23.                height=2, fg='white', bg='gray').pack()
  24.         Button(self.window, text='退出系统', height=2, font=tkFont.Font(size=20), width=60, command=self.window.destroy,
  25.                fg='white', bg='gray').pack()
  26.         self.window.mainloop()  # 主消息循环
  27.  
  28. class adminpage :
  29.     def __init__(self,p):
  30.         p.destroy()
  31.         self.window = tk.Tk()  # 初始框的声明
  32.         self.window.title('管理员登录界面')
  33.         self.window.geometry('600x600')  # 这里的乘是小x
  34.         self.window.geometry('+330+0')
  35.  
  36.         label = tk.Label(self.window, text='管理员登陆', bg='green', font=('Verdana', 30), width=40, height=3)
  37.         label.pack()
  38.         Label(self.window, text='管理员账号：', font=tkFont.Font(size=20)).pack(pady=25)
  39.         self.admin_username = tk.Entry(self.window, width=30, font=tkFont.Font(size=20), bg='Ivory')
  40.         self.admin_username.pack()
  41.  
  42.         Label(self.window, text='管理员密码：', font=tkFont.Font(size=20)).pack(pady=25)
  43.         self.admin_pass = tk.Entry(self.window, width=30, font=tkFont.Font(size=20), bg='Ivory', show='*')
  44.         self.admin_pass.pack()
  45.         Button(self.window, text="登陆", width=10, font=tkFont.Font(size=15), command=self.login).pack(pady=40)
  46.         self.window.protocol("WM_DELETE_WINDOW", self.back)
  47.         self.window.mainloop()  # 进入消息循环
  48.  
  49.     def login(self):
  50.         # 从界面获取的数据
  51.         print(str(self.admin_username.get()))
  52.         print(str(self.admin_pass.get()))
  53.         admin_pass = None
  54.  
  55.         # 数据库操作 查询管理员表
  56.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  57.                               charset='utf8')  # 打开数据库连接
  58.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  59.         sql = "SELECT * FROM 管理员信息 WHERE 管理员账号 = '%s'" % (self.admin_username.get())  # SQL 查询语句
  60.         try:
  61.             # 执行SQL语句
  62.             cursor.execute(sql)
  63.             # 获取所有记录列表
  64.             results = cursor.fetchall()
  65.             for row in results:
  66.                 admin_id = row[0]
  67.                 admin_pass = row[1]
  68.                 # 打印结果
  69.                 print("admin_id=%s,admin_pass=%s" % (admin_id, admin_pass))
  70.         except:
  71.             print("Error: unable to fecth data")
  72.             messagebox.showinfo('警告！', '用户名或密码不正确！')
  73.         con.close()  # 关闭数据库连接
  74.  
  75.         print("正在登陆管理员管理界面")
  76.         # 从界面获取的数据
  77.         print("self", self.admin_pass)
  78.         # 数据库里的数据
  79.         print("local", admin_pass)
  80.  
  81.         # 判断密码，正确则进入管理员操作界面
  82.         if self.admin_pass.get() == admin_pass:
  83.             adminMessage(self.window)
  84.         else:
  85.             messagebox.showinfo('警告！', '用户名或密码不正确！')
  86.  
  87.     def back(self):
  88.         beginpage(self.window)  # 显示主窗口 销毁本窗口
  89.  
  90. class adminMessage:
  91.     def __init__(self, parent_window):
  92.         parent_window.update()
  93.         parent_window.destroy()  # 销毁子界面
  94.  
  95.         self.window = tk.Tk()  # 初始框的声明
  96.         self.window.title('首页')
  97.         self.window.geometry('600x600')  # 这里的乘是小
  98.         self.window.geometry('+330+0')
  99.  
  100.         label = Label(self.window, text="电影操作", font=("Verdana", 20))
  101.         label.pack(pady=50)  # pady=100 界面的长度
  102.  
  103.         Button(self.window, text="查看订单信息", font=tkFont.Font(size=30), command=lambda: adlook(self.window), width=30,
  104.                height=2,
  105.                fg='white', bg='gray', activebackground='black', activeforeground='white').pack()
  106.         Button(self.window, text="查看电影信息", font=tkFont.Font(size=30), command=lambda: lookmovie(self.window), width=30,
  107.                height=2, fg='white', bg='gray', activebackground='black', activeforeground='white').pack()
  108.         Button(self.window, text="查看排片信息", font=tkFont.Font(size=30), command=lambda: adpai(self.window), width=30,
  109.                height=2, fg='white', bg='gray', activebackground='black', activeforeground='white').pack()
  110.         Button(self.window, text="退出登录", font=tkFont.Font(size=30), command=lambda: beginpage(self.window), width=30,
  111.                height=2, fg='white', bg='gray', activebackground='black', activeforeground='white').pack()
  112.  
  113.         self.window.mainloop()  # 主消息循环
  114.  
  115. class UserPage:
  116.     def __init__(self, parent_window):
  117.         parent_window.destroy()  # 销毁主界面
  118.         self.window = tk.Tk()  # 初始框的声明
  119.         self.window.title('用户登陆')
  120.         self.window.geometry('600x600')  # 这里的乘是小x
  121.         self.window.geometry('+330+0')
  122.         label = tk.Label(self.window, text='用户登陆', bg='green', font=('Verdana', 30), width=40, height=3)
  123.         label.pack()
  124.         Label(self.window, text='用户账号：', font=tkFont.Font(size=20)).pack(pady=25)
  125.         self.user_id = tk.Entry(self.window, width=30, font=tkFont.Font(size=20), bg='Ivory')
  126.         self.user_id.pack()
  127.         Label(self.window, text='用户密码：', font=tkFont.Font(size=20)).pack(pady=25)
  128.         self.user_pass = tk.Entry(self.window, width=30, font=tkFont.Font(size=20), bg='Ivory', show='*')
  129.         self.user_pass.pack()
  130.  
  131.         Button(self.window, text="登陆", width=10, font=tkFont.Font(size=15), command=self.login).pack(pady=40)
  132.         Button(self.window, text="返回", width=10, font=tkFont.Font(size=15), command=self.back).pack()
  133.  
  134.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击
  135.         self.window.mainloop()  # 进入消息循环
  136.  
  137.     def login(self):
  138.         print(str(self.user_id.get()))
  139.         print(str(self.user_pass.get()))
  140.         tou_pass = None
  141.  
  142.         # 数据库操作 查询管理员表
  143.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  144.                               charset='utf8')  # 打开数据库连接
  145.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  146.         sql = "SELECT * FROM 用户信息 WHERE 用户账号 = '%s'" % (self.user_id.get())  # SQL 查询语句
  147.         try:
  148.             # 执行SQL语句
  149.             cursor.execute(sql)
  150.             # 获取所有记录列表
  151.             results = cursor.fetchall()
  152.             for row in results:
  153.                 tou_id = row[0]
  154.                 tou_pass = row[4]
  155.                 idd=row[1]
  156.                 # 打印结果
  157.                 print("tou_id=%s,tou_pass=%s" % (tou_id, tou_pass))
  158.         except:
  159.             print("Error: unable to fecth data")
  160.             messagebox.showinfo('警告！', '用户名或密码不正确！')
  161.         con.close()  # 关闭数据库连接
  162.  
  163.         print("正在登陆.....")
  164.         print("self", self.user_pass.get())
  165.         print("local", tou_pass)
  166.  
  167.         # 进入门票信息查看界面
  168.         if self.user_pass.get() == tou_pass:
  169.             userindex(self.window)
  170.         else:
  171.             messagebox.showinfo('警告！', '用户名或密码不正确！')
  172.  
  173.     def back(self):
  174.         beginpage(self.window)
  175.  
  176. class userindex:
  177.     def __init__(self, parent_window):
  178.         parent_window.destroy()  # 销毁主界面
  179.  
  180.         self.window = tk.Tk()  # 初始框的声明
  181.         self.window.title('首页')
  182.         self.window.geometry('600x600')  # 这里的乘是小x
  183.         self.window.geometry('+330+0')
  184.  
  185.         label = tk.Label(self.window, text='欢迎光临豪大大电影院', bg='green', font=('Verdana', 30), width=40, height=3)
  186.         label.pack()
  187.  
  188.         Button(self.window, text="查看全部排片", font=tkFont.Font(size=30), command=lambda: Showmovie(self.window), width=30,
  189.                height=2,
  190.                fg='white', bg='gray', activebackground='black', activeforeground='white').pack()
  191.         Button(self.window, text="购票", font=tkFont.Font(size=30), command=lambda: Buy(self.window),
  192.                width=30,
  193.                height=2, fg='white', bg='gray', activebackground='black', activeforeground='white').pack()
  194.         Button(self.window, text="查看订单", font=tkFont.Font(size=30), command=lambda: Look(self.window), width=30,
  195.                height=2, fg='white', bg='gray', activebackground='black', activeforeground='white').pack()
  196.         Button(self.window, text="退出登录", font=tkFont.Font(size=30), command=lambda: beginpage(self.window), width=30,
  197.                height=2, fg='white', bg='gray', activebackground='black', activeforeground='white').pack()
  198.  
  199.         self.window.mainloop()  # 主消息循环
  200.  
  201. class Showmovie:
  202.     def __init__(self, parent_window):
  203.         parent_window.destroy()  # 自动销毁上一个界面
  204.         self.window = Tk()  # 初始框的声明
  205.         self.window.title('管理员操作界面')
  206.         self.window.geometry("600x600+300+0")  # 初始窗口在屏幕中的位置
  207.  
  208.         self.frame_center = tk.Frame(width=600, height=400)
  209.         self.frame_bottom = tk.Frame(width=650, height=70)
  210.  
  211.         self.columns = ("排片编号", "电影名字", "放映厅", "放映时间", "价格")
  212.         self.tree = ttk.Treeview(self.frame_center, show="headings", height=30, columns=self.columns)
  213.         # 添加竖直滚动条
  214.         self.vbar = ttk.Scrollbar(self.frame_center, orient=VERTICAL, command=self.tree.yview)
  215.         # 定义树形结构与滚动条
  216.         self.tree.configure(yscrollcommand=self.vbar.set)
  217.         self.vbar.config(command=self.tree.yview())
  218.  
  219.         # 定义id1为修改id时的暂存变量，这个是为了更新信息而设计的
  220.         self.id1 = 0
  221.         self.tree.column("排片编号", width=120, anchor='center')  # 表示列,不显示
  222.         self.tree.column("电影名字", width=120, anchor='center')
  223.         self.tree.column("放映厅", width=120, anchor='center')
  224.         self.tree.column("放映时间", width=120, anchor='center')
  225.         self.tree.column("价格", width=120, anchor='center')
  226.  
  227.         # grid方法将tree和vbar进行布局
  228.         self.tree.grid(row=0, column=0, sticky=NSEW)
  229.         self.vbar.grid(row=0, column=1, sticky=NS)
  230.  
  231.         self.schedule_id=[]
  232.         self.schedule_movie=[]
  233.         self.hall_id=[]
  234.         self.schedule_time=[]
  235.         self.schedule_price=[]
  236.  
  237.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy', charset='utf8')
  238.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  239.         # sql = "SELECT * FROM 游客信息 WHERE 游客账号 = '%s'" % (self.var_identityid.get())  # SQL 查询语句
  240.         sql = "SELECT * FROM table_schedule"
  241.         try:
  242.             # 执行SQL语句
  243.             cursor.execute(sql)
  244.             # 获取所有记录列表
  245.             results = cursor.fetchall()
  246.             for row in results:
  247.                 self.schedule_id.append(row[0])
  248.                 self.schedule_time.append(row[2])
  249.                 self.schedule_price.append(row[1])
  250.                 self.hall_id.append(row[4])
  251.                 self.schedule_movie.append(row[5])
  252.  
  253.  
  254.         except:
  255.             print("Error: unable to fetch data")
  256.             messagebox.showinfo('警告！', '数据库连接失败！')
  257.  
  258.         con.close()  # 关闭数据库连接
  259.         print("test***********************")
  260.         for i in range(min(len(self.schedule_id), len(self.schedule_movie), len(self.hall_id), len(self.schedule_time), len(self.schedule_price))):  # 写入数据
  261.             self.tree.insert('', i, values=(
  262.                 self.schedule_id[i], self.schedule_movie[i], self.hall_id[i], self.schedule_time[i], self.schedule_price[i]))
  263.         for col in self.columns:  # 绑定函数，使表头可排序
  264.             self.tree.heading(col, text=col, command=lambda _col=col: self.tree_sort_column(self.tree, _col, False))
  265.  
  266.         #下方
  267.         self.var_schedule_id = StringVar()  # 声明订票编号
  268.         self.var_movie_mane = StringVar()  # 声明游客账号
  269.         self.var_hall_id = StringVar()  # 声明身份证号
  270.         self.var_schedule_time = StringVar()  # 声明联系电话
  271.         self.var_schedule_price = StringVar()  # 声明订票数量
  272.  
  273.         # 定义下方区域，查询功能块
  274.         self.chaxun = StringVar()
  275.         self.right_bottom_gender_entry = Entry(self.frame_bottom, textvariable=self.chaxun, font=('Verdana', 15))
  276.         self.right_bottom_button = ttk.Button(self.frame_bottom, text='查询电影', width=20, command=self.put_data)
  277.         self.right_bottom_button.grid(row=0, column=0, padx=20, pady=20)  # 位置设置
  278.         self.right_bottom_gender_entry.grid(row=0, column=1)
  279.  
  280.         # 整体区域定位，利用了Frame和grid进行布局
  281.         self.frame_center.grid(row=0, column=0, columnspan=2, padx=4, pady=5)
  282.         self.frame_bottom.grid(row=1, column=0, columnspan=2)
  283.  
  284.         # 设置固定组件，(0)就是将组件进行了固定
  285.         self.frame_center.grid_propagate(0)
  286.         self.frame_bottom.grid_propagate(0)
  287.  
  288.          # 开始显示主菜单
  289.         self.frame_center.tkraise()  # 开始显示主菜单
  290.         self.frame_bottom.tkraise()  # 开始显示主菜单
  291.  
  292.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击，执行back方法
  293.         self.window.mainloop()  # 进入消息循环
  294.  
  295.  
  296.     def put_data(self):
  297.         self.delButton()
  298.         print(self.chaxun.get())	# 输入框内的内容
  299.         # 打开数据库连接，准备查找指定的信息
  300.         # 再次进行初始化，进行首行数据的插入
  301.  
  302.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy', charset='utf8')
  303.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  304.         # sql = "use EMIS   exec proc_cha '%s'"  % (self.chaxun.get())
  305.         sql = "SELECT * FROM table_schedule WHERE schedule_movie = '%s' " % (self.chaxun.get())
  306.         try:
  307.             # 执行SQL语句2
  308.             cursor.execute(sql)
  309.             # 获取所有记录列表
  310.             results = cursor.fetchall()
  311.  
  312.  
  313.             self.schedule_id = []  # 订票编号
  314.             self.schedule_movie = []  # 游客账号
  315.             self.hall_id = []  # 身份证号
  316.             self.schedule_time = []  # 联系电话
  317.             self.schedule_price = []  # 订票数量
  318.  
  319.             for row in results:
  320.                 self.schedule_id.append(row[0])
  321.                 self.schedule_time.append(row[2])
  322.                 self.schedule_price.append(row[1])
  323.                 self.hall_id.append(row[4])
  324.                 self.schedule_movie.append(row[5])
  325.  
  326.         except:
  327.             print("Error: unable to fetch data")
  328.             messagebox.showinfo('警告！', '数据库连接失败！')
  329.             con.close()  # 关闭数据库连接
  330.  
  331.         print("进行数据的插入")
  332.  
  333.         for i in range(min(len(self.schedule_id), len(self.schedule_movie), len(self.hall_id), len(self.schedule_time), len(self.schedule_price))):  # 写入数据
  334.             self.tree.insert('', i, values=(
  335.             self.schedule_id[i], self.schedule_movie[i], self.hall_id[i], self.schedule_time[i], self.schedule_price[i]))
  336.         for col in self.columns:  # 绑定函数，使表头可排序
  337.             self.tree.heading(col, text=col, command=lambda _col=col: self.tree_sort_column(self.tree, _col, False))
  338.  
  339.     def delButton(self):
  340.         x = self.tree.get_children()
  341.         for item in x:
  342.             self.tree.delete(item)
  343.  
  344.     def tree_sort_column(self, tv, col, reverse):  # Treeview、列名、排列方式
  345.         l = [(tv.set(k, col), k) for k in tv.get_children('')]
  346.         l.sort(reverse=reverse)  # 排序方式
  347.         for index, (val, k) in enumerate(l):  # 根据排序后索引移动
  348.             tv.move(k, '', index)
  349.         tv.heading(col, command=lambda: self.tree_sort_column(tv, col, not reverse))  # 重写标题，使之成为再点倒序的标题
  350.  
  351.     def back(self):
  352.         userindex(self.window)
  353.  
  354. class Buy:
  355.     def __init__(self, parent_window):
  356.         parent_window.destroy()  # 销毁主界面
  357.         self.window = tk.Tk()  # 初始框的声明
  358.         self.window.title('购票')
  359.         self.window.geometry('600x700')  # 这里的乘是小x
  360.         self.window.geometry('+330+0')
  361.         label = tk.Label(self.window, text='购票', bg='green', font=('Verdana', 20), width=40, height=3)
  362.         label.pack()
  363.         Label(self.window, text='取票号：', font=tkFont.Font(size=15)).pack(pady=25)
  364.         self.userbuy_id = tk.Entry(self.window, width=30, font=tkFont.Font(size=15), bg='Ivory')
  365.         self.userbuy_id.pack()
  366.         Label(self.window, text='用户编号：', font=tkFont.Font(size=15)).pack(pady=25)
  367.         self.user_id = tk.Entry(self.window, width=30, font=tkFont.Font(size=15), bg='Ivory')
  368.         self.user_id.pack()
  369.         Label(self.window, text='排片编号：', font=tkFont.Font(size=15)).pack(pady=25)
  370.         self.schedule_id = tk.Entry(self.window, width=30, font=tkFont.Font(size=15), bg='Ivory')
  371.         self.schedule_id.pack()
  372.         Label(self.window, text='座位号：', font=tkFont.Font(size=15)).pack(pady=25)
  373.         self.seat_id = tk.Entry(self.window, width=30, font=tkFont.Font(size=15), bg='Ivory')
  374.         self.seat_id.pack()
  375.  
  376.         Button(self.window, text="购买", width=10, font=tkFont.Font(size=15), command=self.login).pack(pady=40)
  377.         Button(self.window, text="返回", width=10, font=tkFont.Font(size=15), command=self.back).pack()
  378.  
  379.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击
  380.         self.window.mainloop()  # 进入消息循环
  381.  
  382.     def login(self):
  383.         print(str(self.schedule_id.get()))
  384.         print(str(self.seat_id.get()))
  385.         tou_pass = None
  386.         # 数据库操作 查询管理员表
  387.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  388.                               charset='utf8')  # 打开数据库连接
  389.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  390.         sql = "SELECT hall_id FROM table_schedule WHERE schedule_id = '%s'" % (self.schedule_id.get())  # SQL 查询语句
  391.         try:
  392.             # 执行SQL语句
  393.             cursor.execute(sql)
  394.  
  395.             # 获取所有记录列表
  396.             results = cursor.fetchall()
  397.             print(results)
  398.             for row in results:
  399.                 self.hall_id = row[0]
  400.  
  401.                 # 打印结果
  402.                 print("tou_id=%s" % (self.hall_id))
  403.         except:
  404.             print("Error: unable to fecth data")
  405.             messagebox.showinfo('警告！', '用户名！')
  406.         con.close()  # 关闭数据库连接
  407.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  408.                               charset='utf8')  # 打开数据库连接
  409.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  410.         sql1 = "SELECT hall_sets FROM table_hall WHERE hall_id = '%s'" % (self.hall_id)
  411.         try:
  412.             # 执行SQL语句
  413.             cursor.execute(sql1)
  414.             # 获取所有记录列表
  415.             results = cursor.fetchall()
  416.  
  417.             for row in results:
  418.                 hall_seats = row[0]
  419.                 print(hall_seats)
  420.  
  421.         except:
  422.             print("Error: unable to fecth data")
  423.             messagebox.showinfo('警告！')
  424.         con.close()  # 关闭数据库连接
  425.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  426.                               charset='utf8')  # 打开数据库连接
  427.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  428.         sql1 = "INSERT INTO table_userbuy(userbuy_id,schedule_id,user_id,set_id) \
  429.         				       VALUES ('%s', '%s', '%s', '%s')" % \
  430.                (self.userbuy_id.get(), self.schedule_id.get(), self.user_id.get(), self.seat_id.get())  # SQL 插入语句
  431.         try:
  432.             cursor.execute(sql1)  # 执行sql语句
  433.             print("yes")
  434.             con.commit()  # 提交到数据库执行
  435.         except:
  436.             con.rollback()  # 发生错误时回滚
  437.             messagebox.showinfo('警告！', '数据库连接失败！')
  438.         con.close()  # 关闭数据库连接
  439.        # 购买结果
  440.         if float(self.seat_id.get())<float(hall_seats):
  441.  
  442.             messagebox.showinfo('购买成功！')
  443.         else:
  444.             messagebox.showinfo('没有该座位号！')
  445.  
  446.     def back(self):
  447.         userindex(self.window)  # 显示主窗口 销毁本窗口
  448.  
  449. class Look:
  450.     def __init__(self, parent_window):
  451.         parent_window.destroy()  # 自动销毁上一个界面
  452.         self.window = Tk()  # 初始框的声明
  453.         self.window.title('查看订单界面')
  454.         self.window.geometry("600x600+300+0")  # 初始窗口在屏幕中的位置
  455.  
  456.         self.frame_center = tk.Frame(width=600, height=400)
  457.         self.frame_bottom = tk.Frame(width=650, height=70)
  458.  
  459.         self.columns = ( "电影名字", "放映厅", "放映时间", "价格","座位号")
  460.         self.tree = ttk.Treeview(self.frame_center, show="headings", height=30, columns=self.columns)
  461.         # 添加竖直滚动条
  462.         self.vbar = ttk.Scrollbar(self.frame_center, orient=VERTICAL, command=self.tree.yview)
  463.         # 定义树形结构与滚动条
  464.         self.tree.configure(yscrollcommand=self.vbar.set)
  465.         self.vbar.config(command=self.tree.yview())
  466.  
  467.         # 定义id1为修改id时的暂存变量，这个是为了更新信息而设计的
  468.         self.id1 = 0
  469.          # 表示列,不显示
  470.         self.tree.column("电影名字", width=120, anchor='center')
  471.         self.tree.column("放映厅", width=120, anchor='center')
  472.         self.tree.column("放映时间", width=120, anchor='center')
  473.         self.tree.column("价格", width=120, anchor='center')
  474.         self.tree.column("座位号", width=120, anchor='center')
  475.         # grid方法将tree和vbar进行布局
  476.         self.tree.grid(row=0, column=0, sticky=NSEW)
  477.         self.vbar.grid(row=0, column=1, sticky=NS)
  478.  
  479.         #下方
  480.  
  481.         self.var_movie_mane = StringVar()  # 声明游客账号
  482.         self.var_hall_id = StringVar()  # 声明身份证号
  483.         self.var_schedule_time = StringVar()  # 声明联系电话
  484.         self.var_schedule_price = StringVar()  # 声明订票数量
  485.         self.var_set_id=StringVar()
  486.  
  487.         # 定义下方区域，查询功能块
  488.         self.chaxun = StringVar()
  489.         self.right_bottom_gender_entry = Entry(self.frame_bottom, textvariable=self.chaxun, font=('Verdana', 15))
  490.         self.right_bottom_button = ttk.Button(self.frame_bottom, text='查询订单', width=20, command=self.put_data)
  491.         self.right_bottom_button.grid(row=0, column=0, padx=20, pady=20)  # 位置设置
  492.         self.right_bottom_gender_entry.grid(row=0, column=1)
  493.  
  494.         # 整体区域定位，利用了Frame和grid进行布局
  495.         self.frame_center.grid(row=0, column=0, columnspan=2, padx=4, pady=5)
  496.         self.frame_bottom.grid(row=1, column=0, columnspan=2)
  497.  
  498.         # 设置固定组件，(0)就是将组件进行了固定
  499.         self.frame_center.grid_propagate(0)
  500.         self.frame_bottom.grid_propagate(0)
  501.  
  502.          # 开始显示主菜单
  503.         self.frame_center.tkraise()  # 开始显示主菜单
  504.         self.frame_bottom.tkraise()  # 开始显示主菜单
  505.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击，执行back方法
  506.         self.window.mainloop()  # 进入消息循环
  507.  
  508.     def put_data(self):
  509.         self.delButton()
  510.         print(self.chaxun.get())	# 输入框内的内容
  511.         # 打开数据库连接，准备查找指定的信息
  512.         # 再次进行初始化，进行首行数据的插入
  513.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy', charset='utf8')
  514.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  515.         # sql = "use EMIS   exec proc_cha '%s'"  % (self.chaxun.get())
  516.         sql = "SELECT * FROM table_userbuy WHERE user_id = '%s' " % (self.chaxun.get())
  517.         try:
  518.             # 执行SQL语句2
  519.             cursor.execute(sql)
  520.             # 获取所有记录列表
  521.             results = cursor.fetchall()
  522.             self.set_id = []
  523.             for r in results:
  524.                 self.schedule_id=r[1]
  525.                 self.set_id.append(r[3])
  526.  
  527.             print(self.schedule_id)
  528.             print(self.set_id)
  529.  
  530.         except:
  531.             print("Error: unable to fetch data")
  532.             messagebox.showinfo('警告！', '数据库连接失败！')
  533.             con.close()  # 关闭数据库连接
  534.  
  535.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy', charset='utf8')
  536.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  537.         # sql = "use EMIS   exec proc_cha '%s'"  % (self.chaxun.get())
  538.         sql1 = "SELECT * FROM table_schedule WHERE schedule_id = '%s' " % (self.schedule_id)
  539.         try:
  540.             # 执行SQL语句2
  541.             cursor.execute(sql1)
  542.             # 获取所有记录列表
  543.             results = cursor.fetchall()
  544.             self.schedule_movie = []  # 游客账号
  545.             self.hall_id = []  # 身份证号
  546.             self.schedule_time = []  # 联系电话
  547.             self.schedule_price = []  # 订票数量
  548.  
  549.             for row in results:
  550.                 self.schedule_time.append(row[2])
  551.                 self.schedule_price.append(row[1])
  552.                 self.hall_id.append(row[4])
  553.                 self.schedule_movie.append(row[5])
  554.  
  555.         except:
  556.             print("Error: unable to fetch data")
  557.             messagebox.showinfo('警告！', '数据库连接失败！')
  558.             con.close()  # 关闭数据库连接
  559.  
  560.  
  561.         print("进行数据的插入")
  562.  
  563.         for i in range(min(len(self.schedule_movie), len(self.hall_id), len(self.schedule_time), len(self.schedule_price),len(self.set_id))):  # 写入数据
  564.             self.tree.insert('', i, values=(
  565.             self.schedule_movie[i], self.hall_id[i], self.schedule_time[i], self.schedule_price[i],self.set_id[i]))
  566.         for col in self.columns:  # 绑定函数，使表头可排序
  567.             self.tree.heading(col, text=col, command=lambda _col=col: self.tree_sort_column(self.tree, _col, False))
  568.  
  569.     def delButton(self):
  570.         x = self.tree.get_children()
  571.         for item in x:
  572.             self.tree.delete(item)
  573.  
  574.     def tree_sort_column(self, tv, col, reverse):  # Treeview、列名、排列方式
  575.         l = [(tv.set(k, col), k) for k in tv.get_children('')]
  576.         l.sort(reverse=reverse)  # 排序方式
  577.         for index, (val, k) in enumerate(l):  # 根据排序后索引移动
  578.             tv.move(k, '', index)
  579.         tv.heading(col, command=lambda: self.tree_sort_column(tv, col, not reverse))  # 重写标题，使之成为再点倒序的标题
  580.  
  581.     def back(self):
  582.         userindex(self.window)
  583.  
  584. class UserSign:
  585.     def __init__(self, parent_window):
  586.         parent_window.destroy()  # 销毁主界面
  587.  
  588.         self.window = tk.Tk()  # 初始框的声明
  589.         self.window.title('用户注册页面')
  590.         self.window.geometry('600x600')  # 这里的乘是小x
  591.         self.window.geometry('+330+0')
  592.  
  593.         self.admin_userid = []  # 账号
  594.         self.admin_pass = []  # 密码
  595.         self.admin_name = []  # 姓名
  596.         self.admin_birth = []  # sr
  597.         self.admin_phone = []  # 电话
  598.  
  599.         # 打开数据库连接
  600.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy', charset='utf8')
  601.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  602.         sql = "SELECT * FROM 用户信息"  # SQL 查询语句
  603.         try:
  604.             # 执行SQL语句
  605.             cursor.execute(sql)
  606.             # 获取所有记录列表
  607.             results = cursor.fetchall()
  608.             for row in results:
  609.                 self.admin_userid.append(row[0])
  610.                 self.admin_pass.append(row[4])
  611.                 self.admin_name.append(row[1])
  612.                 self.admin_birth.append(row[3])
  613.                 self.admin_phone.append(row[2])
  614.  
  615.         except:
  616.             print("Error: unable to fetch data")
  617.             messagebox.showinfo('警告！', '数据库连接失败！')
  618.         con.close()  # 关闭数据库连接
  619.  
  620.         self.var_userid = StringVar()  # 声明管理员账号
  621.         self.var_pass = StringVar()  # 声明管理员密码
  622.         self.var_name = StringVar()  # 声明管理员姓名
  623.         self.var_birth = StringVar()  # 声明管理员sr
  624.         self.var_phone = StringVar()  # 声明管理员电话
  625.  
  626.         label = tk.Label(self.window, text='用户注册', bg='green', font=('Verdana', 30), width=40, height=3)
  627.         label.pack()
  628.  
  629.         Label(self.window, text='账号：', font=tkFont.Font(size=15)).pack(pady=10, anchor='w')
  630.         self.var_userid = tk.Entry(self.window, width=40, font=tkFont.Font(size=20), bg='Ivory')
  631.         self.var_userid.pack(anchor='nw')
  632.  
  633.         Label(self.window, text='密码：', font=tkFont.Font(size=15)).pack(pady=10, anchor='w')
  634.         self.var_pass = tk.Entry(self.window, width=40, font=tkFont.Font(size=20), bg='Ivory', show='*')
  635.         self.var_pass.pack(anchor='nw')
  636.  
  637.         Label(self.window, text='姓名：', font=tkFont.Font(size=15)).pack(pady=10, anchor='w')
  638.         self.var_name = tk.Entry(self.window, width=40, font=tkFont.Font(size=20), bg='Ivory')
  639.         self.var_name.pack(anchor='nw')
  640.  
  641.         Label(self.window, text='生日：', font=tkFont.Font(size=15)).pack(pady=10, anchor='w')
  642.         self.var_birth = tk.Entry(self.window, width=40, font=tkFont.Font(size=20), bg='Ivory')
  643.         self.var_birth.pack(anchor='nw')
  644.  
  645.         Label(self.window, text='联系电话：', font=tkFont.Font(size=15)).pack(pady=10, anchor='w')
  646.         self.var_phone = tk.Entry(self.window, width=40, font=tkFont.Font(size=20), bg='Ivory')
  647.         self.var_phone.pack(anchor='nw')
  648.  
  649.         Button(self.window, text="注册", width=20, font=tkFont.Font(size=15), command=self.new_row).pack(pady=20)
  650.         Button(self.window, text="返回首页", width=20, font=tkFont.Font(size=15), command=self.back).pack(pady=20)
  651.  
  652.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击
  653.         self.window.mainloop()  # 进入消息循环
  654.  
  655.     def new_row(self):
  656.  
  657.         # 从界面获取的数据
  658.         print(self.var_userid.get())
  659.         print(self.admin_userid)
  660.  
  661.         if str(self.var_userid.get()) in self.admin_userid:
  662.             messagebox.showinfo('警告！', '该用户已存在！')
  663.         elif (len(str(self.var_phone.get())) > 15) or (len(str(self.var_phone.get())) < 7):
  664.             messagebox.showinfo('警告！', '请输入正确的电话号码！')
  665.         else:
  666.             if self.var_userid.get() != '' and self.var_pass.get() != '' and self.var_name.get() != '' and self.var_birth.get() != '' and self.var_phone.get() != '':
  667.                 # 打开数据库连接
  668.                 con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  669.                                       charset='utf8')
  670.                 cursor = con.cursor()  # 使用cursor()方法获取操作游标
  671.                 sql = "INSERT INTO 用户信息(用户账号,用户密码,用户名,生日,手机号码) \
  672. 				       VALUES ('%s', '%s', '%s', '%s', '%s')" % \
  673.                       (self.var_userid.get(), self.var_pass.get(), self.var_name.get(), self.var_birth.get(),
  674.                        self.var_phone.get())  # SQL 插入语句
  675.                 try:
  676.                     cursor.execute(sql)  # 执行sql语句
  677.                     con.commit()  # 提交到数据库执行
  678.                 except:
  679.                     con.rollback()  # 发生错误时回滚
  680.                     messagebox.showinfo('警告！', '数据库连接失败！')
  681.                 con.close()  # 关闭数据库连接
  682.  
  683.                 self.admin_userid.append(self.var_userid.get())
  684.                 self.admin_pass.append(self.var_pass.get())
  685.                 self.admin_name.append(self.var_name.get())
  686.                 self.admin_birth.append(self.var_birth.get())
  687.                 self.admin_phone.append(self.var_phone.get())
  688.  
  689.                 messagebox.showinfo('提示！', '注册成功！')
  690.             else:
  691.                 messagebox.showinfo('警告！', '请填写正确的信息')
  692.  
  693.     def back(self):
  694.         beginpage(self.window)  # 显示主窗口 销毁本窗口
  695.  
  696. class lookmovie:
  697.     def __init__(self, parent_window):
  698.         parent_window.destroy()  # 销毁主界面
  699.  
  700.         self.window = Tk()  # 初始框的声明
  701.         self.window.title('管理员操作界面')
  702.  
  703.         self.frame_left_top = tk.Frame(width=300, height=200)
  704.         self.frame_right_top = tk.Frame(width=200, height=200)
  705.         self.frame_center = tk.Frame(width=500, height=400)
  706.         self.frame_bottom = tk.Frame(width=650, height=50)
  707.  
  708.         # 定义下方中心列表区域
  709.         self.columns = ("电影编号", "电影名字", "主演", "导演","简介")
  710.         self.tree = ttk.Treeview(self.frame_center, show="headings", height=18, columns=self.columns)
  711.         self.vbar = ttk.Scrollbar(self.frame_center, orient=VERTICAL, command=self.tree.yview)
  712.         # 定义树形结构与滚动条
  713.         self.tree.configure(yscrollcommand=self.vbar.set)
  714.  
  715.         # 表格的标题
  716.         self.tree.column("电影编号", width=100, anchor='center')  # 表示列,不显示
  717.         self.tree.column("电影名字", width=100, anchor='center')
  718.         self.tree.column("主演", width=100, anchor='center')
  719.         self.tree.column("导演", width=100, anchor='center')
  720.         self.tree.column("简介", width=100, anchor='center')
  721.  
  722.         # 调用方法获取表格内容插入
  723.         self.tree.grid(row=0, column=0, sticky=NSEW)
  724.         self.vbar.grid(row=0, column=1, sticky=NS)
  725.  
  726.         self.id = []
  727.         self.name = []
  728.         self.zhuyan = []
  729.         self.daoyan = []
  730.         self.jianjie=[]
  731.         # 打开数据库连接
  732.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  733.                               charset='utf8')
  734.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  735.         sql = "SELECT * FROM table_movie"  # SQL 查询语句
  736.         try:
  737.             # 执行SQL语句
  738.             cursor.execute(sql)
  739.             # 获取所有记录列表
  740.             results = cursor.fetchall()
  741.             for row in results:
  742.                 self.id.append(row[0])
  743.                 self.name.append(row[1])
  744.                 self.zhuyan.append(row[2])
  745.                 self.daoyan.append(row[3])
  746.                 self.jianjie.append(row[4])
  747.         except:
  748.             print("Error: unable to fetch data")
  749.             messagebox.showinfo('警告！', '数据库连接失败！')
  750.         con.close()  # 关闭数据库连接
  751.  
  752.         print("test***********************")
  753.         for i in range(min(len(self.id), len(self.name), len(self.zhuyan), len(self.daoyan),len(self.jianjie))):  # 写入数据
  754.             self.tree.insert('', i, values=(self.id[i], self.name[i], self.zhuyan[i], self.daoyan[i],self.jianjie[i]))
  755.  
  756.         for col in self.columns:  # 绑定函数，使表头可排序
  757.             self.tree.heading(col, text=col,
  758.                               command=lambda _col=col: self.tree_sort_column(self.tree, _col, False))
  759.  
  760.         # 定义顶部区域
  761.         # 定义左上方区域
  762.         self.top_title = Label(self.frame_left_top, text="电影信息:", font=('Verdana', 20))
  763.         self.top_title.grid(row=0, column=0, columnspan=2, sticky=NSEW, padx=50, pady=0)
  764.  
  765.         self.left_top_frame = tk.Frame(self.frame_left_top)
  766.         self.var_id = StringVar()  # 声明dy号
  767.         self.var_name = StringVar()  # 声明dy名
  768.         self.var_zhuyan = StringVar()  # 声明zy
  769.         self.var_daoyan = StringVar()  # 声明dyan
  770.         self.var_jianjie=StringVar()
  771.         # dy号
  772.         self.right_top_id_label = Label(self.frame_left_top, text="电影编号：", font=('Verdana', 15))
  773.         self.right_top_id_entry = Entry(self.frame_left_top, textvariable=self.var_id, font=('Verdana', 15))
  774.         self.right_top_id_label.grid(row=1, column=0)  # 位置设置
  775.         self.right_top_id_entry.grid(row=1, column=1)
  776.         # 姓名
  777.         self.right_top_name_label = Label(self.frame_left_top, text="电影名字：", font=('Verdana', 15))
  778.         self.right_top_name_entry = Entry(self.frame_left_top, textvariable=self.var_name, font=('Verdana', 15))
  779.         self.right_top_name_label.grid(row=2, column=0)  # 位置设置
  780.         self.right_top_name_entry.grid(row=2, column=1)
  781.         # 性别
  782.         self.right_top_gender_label = Label(self.frame_left_top, text="主演：", font=('Verdana', 15))
  783.         self.right_top_gender_entry = Entry(self.frame_left_top, textvariable=self.var_zhuyan,
  784.                                             font=('Verdana', 15))
  785.         self.right_top_gender_label.grid(row=3, column=0)  # 位置设置
  786.         self.right_top_gender_entry.grid(row=3, column=1)
  787.         # 年龄
  788.         self.right_top_gender_label = Label(self.frame_left_top, text="导演：", font=('Verdana', 15))
  789.         self.right_top_gender_entry = Entry(self.frame_left_top, textvariable=self.var_daoyan,
  790.                                             font=('Verdana', 15))
  791.         self.right_top_gender_label.grid(row=4, column=0)  # 位置设置
  792.         self.right_top_gender_entry.grid(row=4, column=1)
  793.         # 年龄
  794.         self.right_top_gender_label = Label(self.frame_left_top, text="简介：", font=('Verdana', 15))
  795.         self.right_top_gender_entry = Entry(self.frame_left_top, textvariable=self.var_jianjie,
  796.                                             font=('Verdana', 15))
  797.         self.right_top_gender_label.grid(row=5, column=0)  # 位置设置
  798.         self.right_top_gender_entry.grid(row=5, column=1)
  799.  
  800.         # 定义右上方区域
  801.         self.right_top_title = Label(self.frame_right_top, text="操作：", font=('Verdana', 20))
  802.  
  803.         self.tree.bind('<Button-1>', self.click)  # 左键获取位置
  804.         self.right_top_button1 = ttk.Button(self.frame_right_top, text='新建电影信息', width=20, command=self.new_row)
  805.         self.right_top_button2 = ttk.Button(self.frame_right_top, text='更新选中电影信息', width=20,
  806.                                             command=self.updata_row)
  807.         self.right_top_button3 = ttk.Button(self.frame_right_top, text='删除选中电影信息', width=20,
  808.                                             command=self.del_row)
  809.  
  810.         # 位置设置
  811.         self.right_top_title.grid(row=1, column=0, pady=10)
  812.         self.right_top_button1.grid(row=2, column=0, padx=20, pady=10)
  813.         self.right_top_button2.grid(row=3, column=0, padx=20, pady=10)
  814.         self.right_top_button3.grid(row=4, column=0, padx=20, pady=10)
  815.  
  816.         # 整体区域定位
  817.         self.frame_left_top.grid(row=0, column=0, padx=2, pady=5)
  818.         self.frame_right_top.grid(row=0, column=1, padx=30, pady=30)
  819.         self.frame_center.grid(row=1, column=0, columnspan=2, padx=4, pady=5)
  820.         self.frame_bottom.grid(row=2, column=0, columnspan=2)
  821.  
  822.         self.frame_left_top.grid_propagate(0)
  823.         self.frame_right_top.grid_propagate(0)
  824.         self.frame_center.grid_propagate(0)
  825.         self.frame_bottom.grid_propagate(0)
  826.  
  827.         self.frame_left_top.tkraise()  # 开始显示主菜单
  828.         self.frame_right_top.tkraise()  # 开始显示主菜单
  829.         self.frame_center.tkraise()  # 开始显示主菜单
  830.         self.frame_bottom.tkraise()  # 开始显示主菜单
  831.  
  832.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击
  833.         self.window.mainloop()  # 进入消息循环
  834.  
  835.     def back(self):
  836.         adminMessage(self.window)  # 显示主窗口 销毁本窗口
  837.  
  838.     def click(self, event):
  839.         self.col = self.tree.identify_column(event.x)  # 列
  840.         self.row = self.tree.identify_row(event.y)  # 行
  841.  
  842.         print(self.col)
  843.         print(self.row)
  844.         self.row_info = self.tree.item(self.row, "values")
  845.         self.var_id.set(self.row_info[0])
  846.         self.var_name.set(self.row_info[1])
  847.         self.var_zhuyan.set(self.row_info[2])
  848.         self.var_daoyan.set(self.row_info[3])
  849.         self.var_jianjie.set(self.row_info[4])
  850.         self.right_top_id_entry = Entry(self.frame_left_top, state='disabled', textvariable=self.var_id,
  851.                                         font=('Verdana', 15))
  852.  
  853.         print('')
  854.  
  855.     def tree_sort_column(self, tv, col, reverse):  # Treeview、列名、排列方式
  856.         l = [(tv.set(k, col), k) for k in tv.get_children('')]
  857.         l.sort(reverse=reverse)  # 排序方式
  858.         # rearrange items in sorted positions
  859.         for index, (val, k) in enumerate(l):  # 根据排序后索引移动
  860.             tv.move(k, '', index)
  861.         tv.heading(col, command=lambda: self.tree_sort_column(tv, col, not reverse))  # 重写标题，使之成为再点倒序的标题
  862.  
  863.     def new_row(self):
  864.         print('123')
  865.         print(self.var_id.get())
  866.         print(self.id)
  867.         if str(self.var_id.get()) in self.id:
  868.             messagebox.showinfo('警告！', '该电影已存在！')
  869.         else:
  870.             if self.var_id.get() != '' and self.var_name.get() != '' and self.var_zhuyan.get() != '' and self.var_daoyan.get() != ''and self.var_jianjie.get() !='':
  871.                 # 打开数据库连接
  872.                 con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  873.                                       charset='utf8')
  874.                 cursor = con.cursor()  # 使用cursor()方法获取操作游标
  875.                 sql = "INSERT INTO table_movie(movie_id, movie_name, movie_zhuyan, movie_daoyan,movie_jianjie) \
  876.     				       VALUES ('%s', '%s', '%s', '%s','%s')" % \
  877.                       (self.var_id.get(), self.var_name.get(), self.var_zhuyan.get(), self.var_daoyan.get(),self.var_jianjie.get())  # SQL 插入语句
  878.                 try:
  879.                     cursor.execute(sql)  # 执行sql语句
  880.                     con.commit()  # 提交到数据库执行
  881.                 except:
  882.                     con.rollback()  # 发生错误时回滚
  883.                     messagebox.showinfo('警告！', '数据库连接失败！')
  884.                 con.close()  # 关闭数据库连接
  885.  
  886.                 self.id.append(self.var_id.get())
  887.                 self.name.append(self.var_name.get())
  888.                 self.zhuyan.append(self.var_zhuyan.get())
  889.                 self.daoyan.append(self.var_daoyan.get())
  890.                 self.jianjie.append(self.var_jianjie.get())
  891.                 self.tree.insert('', len(self.id) - 1, values=(
  892.                     self.id[len(self.id) - 1], self.name[len(self.id) - 1], self.zhuyan[len(self.id) - 1],
  893.                     self.daoyan[len(self.id) - 1],self.jianjie[len(self.id)-1]))
  894.                 self.tree.update()
  895.                 messagebox.showinfo('提示！', '插入成功！')
  896.             else:
  897.                 messagebox.showinfo('警告！', '请填写订单数据')
  898.  
  899.     def updata_row(self):
  900.         res = messagebox.askyesnocancel('警告！', '是否更新所填数据？')
  901.         if res == True:
  902.             if self.var_id.get() == self.row_info[0]:  # 如果所填学号 与 所选学号一致
  903.                 # 打开数据库连接
  904.                 con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  905.                                       charset='utf8')
  906.                 cursor = con.cursor()  # 使用cursor()方法获取操作游标
  907.                 sql = "UPDATE table_movie SET movie_name = '%s', movie_zhuyan = '%s', movie_daoyan = '%s',moive_jianjie ='%s' \
  908.     				 WHERE movie_id = '%s'" % (
  909.                 self.var_name.get(), self.var_zhuyan.get(), self.var_daoyan.get(), self.var_jianjie.get(),self.var_id.get())  # SQL 插入语句
  910.                 try:
  911.                     cursor.execute(sql)  # 执行sql语句
  912.                     con.commit()  # 提交到数据库执行
  913.                     messagebox.showinfo('提示！', '更新成功！')
  914.                 except:
  915.                     con.rollback()  # 发生错误时回滚
  916.  
  917.                 con.close()  # 关闭数据库连接
  918.  
  919.                 id_index = self.id.index(self.row_info[0])
  920.                 self.name[id_index] = self.var_name.get()
  921.                 self.zhuyan[id_index] = self.var_zhuyan.get()
  922.                 self.daoyan[id_index] = self.var_daoyan.get()
  923.                 self.jianjie[id_index]=self.var_jianjie.get()
  924.  
  925.                 self.tree.item(self.tree.selection()[0], values=(
  926.                     self.var_id.get(), self.var_name.get(), self.var_zhuyan.get(),
  927.                     self.var_daoyan.get(),self.var_jianjie.get()))  # 修改对于行信息
  928.             else:
  929.                 messagebox.showinfo('警告！', '不能修改订单号！')
  930.  
  931.     def del_row(self):
  932.         res = messagebox.askyesnocancel('警告！', '是否删除所选数据？')
  933.         if res == True:
  934.             print(self.row_info[0])  # 鼠标选中的学号
  935.             print(self.tree.selection()[0])  # 行号
  936.             print(self.tree.get_children())  # 所有行
  937.             # 打开数据库连接
  938.             con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  939.                                   charset='utf8')
  940.             cursor = con.cursor()  # 使用cursor()方法获取操作游标
  941.             sql = "DELETE FROM table_movie WHERE movie_id = '%s'" % (self.row_info[0])  # SQL 插入语句
  942.             try:
  943.                 cursor.execute(sql)  # 执行sql语句
  944.                 con.commit()  # 提交到数据库执行
  945.                 messagebox.showinfo('提示！', '删除成功！')
  946.             except:
  947.                 con.rollback()  # 发生错误时回滚
  948.                 messagebox.showinfo('警告！', '删除失败，数据库连接失败！')
  949.             con.close()  # 关闭数据库连接
  950.  
  951.             id_index = self.id.index(self.row_info[0])
  952.             print(id_index)
  953.             del self.id[id_index]
  954.             del self.name[id_index]
  955.             del self.zhuyan[id_index]
  956.             del self.daoyan[id_index]
  957.             del self.jianjie[id_index]
  958.             print(self.id)
  959.             self.tree.delete(self.tree.selection()[0])  # 删除所选行
  960.             print(self.tree.get_children())
  961.  
  962. class adlook:
  963.     def __init__(self, parent_window):
  964.         parent_window.destroy()  # 销毁主界面
  965.  
  966.         self.window = Tk()  # 初始框的声明
  967.         self.window.title('管理员操作界面')
  968.  
  969.         self.frame_left_top = tk.Frame(width=300, height=200)
  970.         self.frame_right_top = tk.Frame(width=200, height=200)
  971.         self.frame_center = tk.Frame(width=500, height=400)
  972.         self.frame_bottom = tk.Frame(width=650, height=50)
  973.  
  974.         # 定义下方中心列表区域
  975.         self.columns = ("订单号", "排片编号", "用户账号", "座位号")
  976.         self.tree = ttk.Treeview(self.frame_center, show="headings", height=18, columns=self.columns)
  977.         self.vbar = ttk.Scrollbar(self.frame_center, orient=VERTICAL, command=self.tree.yview)
  978.         # 定义树形结构与滚动条
  979.         self.tree.configure(yscrollcommand=self.vbar.set)
  980.  
  981.         # 表格的标题
  982.         self.tree.column("订单号", width=150, anchor='center')  # 表示列,不显示
  983.         self.tree.column("排片编号", width=150, anchor='center')
  984.         self.tree.column("用户账号", width=100, anchor='center')
  985.         self.tree.column("座位号", width=100, anchor='center')
  986.  
  987.         # 调用方法获取表格内容插入
  988.         self.tree.grid(row=0, column=0, sticky=NSEW)
  989.         self.vbar.grid(row=0, column=1, sticky=NS)
  990.  
  991.         self.id = []
  992.         self.name = []
  993.         self.gender = []
  994.         self.age = []
  995.         # 打开数据库连接
  996.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  997.                               charset='utf8')
  998.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  999.         sql = "SELECT * FROM table_userbuy"  # SQL 查询语句
  1000.         try:
  1001.             # 执行SQL语句
  1002.             cursor.execute(sql)
  1003.             # 获取所有记录列表
  1004.             results = cursor.fetchall()
  1005.             for row in results:
  1006.                 self.id.append(row[0])
  1007.                 self.name.append(row[1])
  1008.                 self.gender.append(row[2])
  1009.                 self.age.append(row[3])
  1010.             # print(self.id)
  1011.             # print(self.name)
  1012.             # print(self.gender)
  1013.             # print(self.age)
  1014.         except:
  1015.             print("Error: unable to fetch data")
  1016.             messagebox.showinfo('警告！', '数据库连接失败！')
  1017.         con.close()  # 关闭数据库连接
  1018.  
  1019.         print("test***********************")
  1020.         for i in range(min(len(self.id), len(self.name), len(self.gender), len(self.age))):  # 写入数据
  1021.             self.tree.insert('', i, values=(self.id[i], self.name[i], self.gender[i], self.age[i]))
  1022.  
  1023.         for col in self.columns:  # 绑定函数，使表头可排序
  1024.             self.tree.heading(col, text=col,
  1025.                               command=lambda _col=col: self.tree_sort_column(self.tree, _col, False))
  1026.  
  1027.         # 定义顶部区域
  1028.         # 定义左上方区域
  1029.         self.top_title = Label(self.frame_left_top, text="订单信息:", font=('Verdana', 20))
  1030.         self.top_title.grid(row=0, column=0, columnspan=2, sticky=NSEW, padx=50, pady=10)
  1031.  
  1032.         self.left_top_frame = tk.Frame(self.frame_left_top)
  1033.         self.var_id = StringVar()  # 声明学号
  1034.         self.var_name = StringVar()  # 声明姓名
  1035.         self.var_gender = StringVar()  # 声明性别
  1036.         self.var_age = StringVar()  # 声明年龄
  1037.         # 学号
  1038.         self.right_top_id_label = Label(self.frame_left_top, text="订单号：", font=('Verdana', 15))
  1039.         self.right_top_id_entry = Entry(self.frame_left_top, textvariable=self.var_id, font=('Verdana', 15))
  1040.         self.right_top_id_label.grid(row=1, column=0)  # 位置设置
  1041.         self.right_top_id_entry.grid(row=1, column=1)
  1042.         # 姓名
  1043.         self.right_top_name_label = Label(self.frame_left_top, text="排片编号：", font=('Verdana', 15))
  1044.         self.right_top_name_entry = Entry(self.frame_left_top, textvariable=self.var_name, font=('Verdana', 15))
  1045.         self.right_top_name_label.grid(row=2, column=0)  # 位置设置
  1046.         self.right_top_name_entry.grid(row=2, column=1)
  1047.         # 性别
  1048.         self.right_top_gender_label = Label(self.frame_left_top, text="用户账号：", font=('Verdana', 15))
  1049.         self.right_top_gender_entry = Entry(self.frame_left_top, textvariable=self.var_gender,
  1050.                                             font=('Verdana', 15))
  1051.         self.right_top_gender_label.grid(row=3, column=0)  # 位置设置
  1052.         self.right_top_gender_entry.grid(row=3, column=1)
  1053.         # 年龄
  1054.         self.right_top_gender_label = Label(self.frame_left_top, text="座位号：", font=('Verdana', 15))
  1055.         self.right_top_gender_entry = Entry(self.frame_left_top, textvariable=self.var_age,
  1056.                                             font=('Verdana', 15))
  1057.         self.right_top_gender_label.grid(row=4, column=0)  # 位置设置
  1058.         self.right_top_gender_entry.grid(row=4, column=1)
  1059.  
  1060.         # 定义右上方区域
  1061.         self.right_top_title = Label(self.frame_right_top, text="操作：", font=('Verdana', 20))
  1062.  
  1063.         self.tree.bind('<Button-1>', self.click)  # 左键获取位置
  1064.         self.right_top_button1 = ttk.Button(self.frame_right_top, text='新建电影信息', width=20, command=self.new_row)
  1065.         self.right_top_button2 = ttk.Button(self.frame_right_top, text='更新选中电影信息', width=20,
  1066.                                             command=self.updata_row)
  1067.         self.right_top_button3 = ttk.Button(self.frame_right_top, text='删除选中电影信息', width=20,
  1068.                                             command=self.del_row)
  1069.  
  1070.         # 位置设置
  1071.         self.right_top_title.grid(row=1, column=0, pady=10)
  1072.         self.right_top_button1.grid(row=2, column=0, padx=20, pady=10)
  1073.         self.right_top_button2.grid(row=3, column=0, padx=20, pady=10)
  1074.         self.right_top_button3.grid(row=4, column=0, padx=20, pady=10)
  1075.  
  1076.         # 整体区域定位
  1077.         self.frame_left_top.grid(row=0, column=0, padx=2, pady=5)
  1078.         self.frame_right_top.grid(row=0, column=1, padx=30, pady=30)
  1079.         self.frame_center.grid(row=1, column=0, columnspan=2, padx=4, pady=5)
  1080.         self.frame_bottom.grid(row=2, column=0, columnspan=2)
  1081.  
  1082.         self.frame_left_top.grid_propagate(0)
  1083.         self.frame_right_top.grid_propagate(0)
  1084.         self.frame_center.grid_propagate(0)
  1085.         self.frame_bottom.grid_propagate(0)
  1086.  
  1087.         self.frame_left_top.tkraise()  # 开始显示主菜单
  1088.         self.frame_right_top.tkraise()  # 开始显示主菜单
  1089.         self.frame_center.tkraise()  # 开始显示主菜单
  1090.         self.frame_bottom.tkraise()  # 开始显示主菜单
  1091.  
  1092.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击
  1093.         self.window.mainloop()  # 进入消息循环
  1094.  
  1095.     def back(self):
  1096.         adminMessage(self.window)  # 显示主窗口 销毁本窗口
  1097.  
  1098.     def click(self, event):
  1099.         self.col = self.tree.identify_column(event.x)  # 列
  1100.         self.row = self.tree.identify_row(event.y)  # 行
  1101.  
  1102.         print(self.col)
  1103.         print(self.row)
  1104.         self.row_info = self.tree.item(self.row, "values")
  1105.         self.var_id.set(self.row_info[0])
  1106.         self.var_name.set(self.row_info[1])
  1107.         self.var_gender.set(self.row_info[2])
  1108.         self.var_age.set(self.row_info[3])
  1109.         self.right_top_id_entry = Entry(self.frame_left_top, state='disabled', textvariable=self.var_id,
  1110.                                         font=('Verdana', 15))
  1111.  
  1112.         print('')
  1113.  
  1114.     def tree_sort_column(self, tv, col, reverse):  # Treeview、列名、排列方式
  1115.         l = [(tv.set(k, col), k) for k in tv.get_children('')]
  1116.         l.sort(reverse=reverse)  # 排序方式
  1117.         # rearrange items in sorted positions
  1118.         for index, (val, k) in enumerate(l):  # 根据排序后索引移动
  1119.             tv.move(k, '', index)
  1120.         tv.heading(col, command=lambda: self.tree_sort_column(tv, col, not reverse))  # 重写标题，使之成为再点倒序的标题
  1121.  
  1122.     def new_row(self):
  1123.         print('123')
  1124.         print(self.var_id.get())
  1125.         print(self.id)
  1126.         if str(self.var_id.get()) in self.id:
  1127.             messagebox.showinfo('警告！', '该订单已存在！')
  1128.         else:
  1129.             if self.var_id.get() != '' and self.var_name.get() != '' and self.var_gender.get() != '' and self.var_age.get() != '':
  1130.                 # 打开数据库连接
  1131.                 con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  1132.                                       charset='utf8')
  1133.                 cursor = con.cursor()  # 使用cursor()方法获取操作游标
  1134.                 sql = "INSERT INTO table_userbuy(userbuy_id, schedule_id, user_id, set_id) \
  1135.     				       VALUES ('%s', '%s', '%s', '%s')" % \
  1136.                       (self.var_id.get(), self.var_name.get(), self.var_gender.get(), self.var_age.get())  # SQL 插入语句
  1137.                 try:
  1138.                     cursor.execute(sql)  # 执行sql语句
  1139.                     con.commit()  # 提交到数据库执行
  1140.                 except:
  1141.                     con.rollback()  # 发生错误时回滚
  1142.                     messagebox.showinfo('警告！', '数据库连接失败！')
  1143.                 con.close()  # 关闭数据库连接
  1144.  
  1145.                 self.id.append(self.var_id.get())
  1146.                 self.name.append(self.var_name.get())
  1147.                 self.gender.append(self.var_gender.get())
  1148.                 self.age.append(self.var_age.get())
  1149.                 self.tree.insert('', len(self.id) - 1, values=(
  1150.                     self.id[len(self.id) - 1], self.name[len(self.id) - 1], self.gender[len(self.id) - 1],
  1151.                     self.age[len(self.id) - 1]))
  1152.                 self.tree.update()
  1153.                 messagebox.showinfo('提示！', '插入成功！')
  1154.             else:
  1155.                 messagebox.showinfo('警告！', '请填写订单数据')
  1156.  
  1157.     def updata_row(self):
  1158.         res = messagebox.askyesnocancel('警告！', '是否更新所填数据？')
  1159.         if res == True:
  1160.             if self.var_id.get() == self.row_info[0]:  # 如果所填学号 与 所选学号一致
  1161.                 # 打开数据库连接
  1162.                 con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  1163.                                       charset='utf8')
  1164.                 cursor = con.cursor()  # 使用cursor()方法获取操作游标
  1165.                 sql = "UPDATE table_userbuy SET schedule_id = '%s', user_id = '%s', set_id = '%s' \
  1166.     				 WHERE userbuy_id = '%s'" % (
  1167.                 self.var_name.get(), self.var_gender.get(), self.var_age.get(), self.var_id.get())  # SQL 插入语句
  1168.                 try:
  1169.                     cursor.execute(sql)  # 执行sql语句
  1170.                     con.commit()  # 提交到数据库执行
  1171.                     messagebox.showinfo('提示！', '更新成功！')
  1172.                 except:
  1173.                     con.rollback()  # 发生错误时回滚
  1174.                     messagebox.showinfo('警告！', '更新失败，数据库连接失败！')
  1175.                 con.close()  # 关闭数据库连接
  1176.  
  1177.                 id_index = self.id.index(self.row_info[0])
  1178.                 self.name[id_index] = self.var_name.get()
  1179.                 self.gender[id_index] = self.var_gender.get()
  1180.                 self.age[id_index] = self.var_age.get()
  1181.  
  1182.                 self.tree.item(self.tree.selection()[0], values=(
  1183.                     self.var_id.get(), self.var_name.get(), self.var_gender.get(),
  1184.                     self.var_age.get()))  # 修改对于行信息
  1185.             else:
  1186.                 messagebox.showinfo('警告！', '不能修改订单号！')
  1187.  
  1188.     def del_row(self):
  1189.         res = messagebox.askyesnocancel('警告！', '是否删除所选数据？')
  1190.         if res == True:
  1191.             print(self.row_info[0])  # 鼠标选中的学号
  1192.             print(self.tree.selection()[0])  # 行号
  1193.             print(self.tree.get_children())  # 所有行
  1194.             # 打开数据库连接
  1195.             con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  1196.                                   charset='utf8')
  1197.             cursor = con.cursor()  # 使用cursor()方法获取操作游标
  1198.             sql = "DELETE FROM table_userbuy WHERE userbuy_id = '%s'" % (self.row_info[0])  # SQL 插入语句
  1199.             try:
  1200.                 cursor.execute(sql)  # 执行sql语句
  1201.                 con.commit()  # 提交到数据库执行
  1202.                 messagebox.showinfo('提示！', '删除成功！')
  1203.             except:
  1204.                 con.rollback()  # 发生错误时回滚
  1205.                 messagebox.showinfo('警告！', '删除失败，数据库连接失败！')
  1206.             con.close()  # 关闭数据库连接
  1207.  
  1208.             id_index = self.id.index(self.row_info[0])
  1209.             print(id_index)
  1210.             del self.id[id_index]
  1211.             del self.name[id_index]
  1212.             del self.gender[id_index]
  1213.             del self.age[id_index]
  1214.             print(self.id)
  1215.             self.tree.delete(self.tree.selection()[0])  # 删除所选行
  1216.             print(self.tree.get_children())
  1217.  
  1218. class adpai:
  1219.     def __init__(self, parent_window):
  1220.         parent_window.destroy()  # 销毁主界面
  1221.  
  1222.         self.window = Tk()  # 初始框的声明
  1223.         self.window.title('排片操作界面')
  1224.  
  1225.         self.frame_left_top = tk.Frame(width=300, height=200)
  1226.         self.frame_right_top = tk.Frame(width=200, height=200)
  1227.         self.frame_center = tk.Frame(width=500, height=400)
  1228.         self.frame_bottom = tk.Frame(width=650, height=50)
  1229.  
  1230.         # 定义下方中心列表区域
  1231.         self.columns = ("排片编号", "电影名字", "价格", "时间","放映厅")
  1232.         self.tree = ttk.Treeview(self.frame_center, show="headings", height=18, columns=self.columns)
  1233.         self.vbar = ttk.Scrollbar(self.frame_center, orient=VERTICAL, command=self.tree.yview)
  1234.         # 定义树形结构与滚动条
  1235.         self.tree.configure(yscrollcommand=self.vbar.set)
  1236.  
  1237.         # 表格的标题
  1238.         self.tree.column("排片编号", width=100, anchor='center')  # 表示列,不显示
  1239.         self.tree.column("电影名字", width=100, anchor='center')
  1240.         self.tree.column("价格", width=100, anchor='center')
  1241.         self.tree.column("时间", width=100, anchor='center')
  1242.         self.tree.column("放映厅", width=100, anchor='center')
  1243.  
  1244.         # 调用方法获取表格内容插入
  1245.         self.tree.grid(row=0, column=0, sticky=NSEW)
  1246.         self.vbar.grid(row=0, column=1, sticky=NS)
  1247.  
  1248.         self.id = []
  1249.         self.name = []
  1250.         self.zhuyan = []
  1251.         self.daoyan = []
  1252.         self.jianjie=[]
  1253.         # 打开数据库连接
  1254.         con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  1255.                               charset='utf8')
  1256.         cursor = con.cursor()  # 使用cursor()方法获取操作游标
  1257.         sql = "SELECT * FROM table_schedule"  # SQL 查询语句
  1258.         try:
  1259.             # 执行SQL语句
  1260.             cursor.execute(sql)
  1261.             # 获取所有记录列表
  1262.             results = cursor.fetchall()
  1263.             for row in results:
  1264.                 self.id.append(row[0])
  1265.                 self.name.append(row[5])
  1266.                 self.zhuyan.append(row[1])
  1267.                 self.daoyan.append(row[2])
  1268.                 self.jianjie.append(row[4])
  1269.         except:
  1270.             print("Error: unable to fetch data")
  1271.             messagebox.showinfo('警告！', '数据库连接失败！')
  1272.         con.close()  # 关闭数据库连接
  1273.  
  1274.         print("test***********************")
  1275.         for i in range(min(len(self.id), len(self.name), len(self.zhuyan), len(self.daoyan),len(self.jianjie))):  # 写入数据
  1276.             self.tree.insert('', i, values=(self.id[i], self.name[i], self.zhuyan[i], self.daoyan[i],self.jianjie[i]))
  1277.  
  1278.         for col in self.columns:  # 绑定函数，使表头可排序
  1279.             self.tree.heading(col, text=col,
  1280.                               command=lambda _col=col: self.tree_sort_column(self.tree, _col, False))
  1281.  
  1282.         # 定义顶部区域
  1283.         # 定义左上方区域
  1284.         self.top_title = Label(self.frame_left_top, text="排片信息:", font=('Verdana', 20))
  1285.         self.top_title.grid(row=0, column=0, columnspan=2, sticky=NSEW, padx=50, pady=0)
  1286.  
  1287.         self.left_top_frame = tk.Frame(self.frame_left_top)
  1288.         self.var_id = StringVar()  # 声明dy号
  1289.         self.var_name = StringVar()  # 声明dy名
  1290.         self.var_zhuyan = StringVar()  # 声明zy
  1291.         self.var_daoyan = StringVar()  # 声明dyan
  1292.         self.var_jianjie=StringVar()
  1293.         # dy号
  1294.         self.right_top_id_label = Label(self.frame_left_top, text="排片编号：", font=('Verdana', 15))
  1295.         self.right_top_id_entry = Entry(self.frame_left_top, textvariable=self.var_id, font=('Verdana', 15))
  1296.         self.right_top_id_label.grid(row=1, column=0)  # 位置设置
  1297.         self.right_top_id_entry.grid(row=1, column=1)
  1298.         # 姓名
  1299.         self.right_top_name_label = Label(self.frame_left_top, text="电影名字：", font=('Verdana', 15))
  1300.         self.right_top_name_entry = Entry(self.frame_left_top, textvariable=self.var_name, font=('Verdana', 15))
  1301.         self.right_top_name_label.grid(row=2, column=0)  # 位置设置
  1302.         self.right_top_name_entry.grid(row=2, column=1)
  1303.         # 性别
  1304.         self.right_top_gender_label = Label(self.frame_left_top, text="价格：", font=('Verdana', 15))
  1305.         self.right_top_gender_entry = Entry(self.frame_left_top, textvariable=self.var_zhuyan,
  1306.                                             font=('Verdana', 15))
  1307.         self.right_top_gender_label.grid(row=3, column=0)  # 位置设置
  1308.         self.right_top_gender_entry.grid(row=3, column=1)
  1309.         # 年龄
  1310.         self.right_top_gender_label = Label(self.frame_left_top, text="时间：", font=('Verdana', 15))
  1311.         self.right_top_gender_entry = Entry(self.frame_left_top, textvariable=self.var_daoyan,
  1312.                                             font=('Verdana', 15))
  1313.         self.right_top_gender_label.grid(row=4, column=0)  # 位置设置
  1314.         self.right_top_gender_entry.grid(row=4, column=1)
  1315.         # 年龄
  1316.         self.right_top_gender_label = Label(self.frame_left_top, text="放映厅：", font=('Verdana', 15))
  1317.         self.right_top_gender_entry = Entry(self.frame_left_top, textvariable=self.var_jianjie,
  1318.                                             font=('Verdana', 15))
  1319.         self.right_top_gender_label.grid(row=5, column=0)  # 位置设置
  1320.         self.right_top_gender_entry.grid(row=5, column=1)
  1321.  
  1322.         # 定义右上方区域
  1323.         self.right_top_title = Label(self.frame_right_top, text="操作：", font=('Verdana', 20))
  1324.  
  1325.         self.tree.bind('<Button-1>', self.click)  # 左键获取位置
  1326.         self.right_top_button1 = ttk.Button(self.frame_right_top, text='新建排片信息', width=20, command=self.new_row)
  1327.         self.right_top_button2 = ttk.Button(self.frame_right_top, text='更新选中排片信息', width=20,
  1328.                                             command=self.updata_row)
  1329.         self.right_top_button3 = ttk.Button(self.frame_right_top, text='删除选中排片信息', width=20,
  1330.                                             command=self.del_row)
  1331.  
  1332.         # 位置设置
  1333.         self.right_top_title.grid(row=1, column=0, pady=10)
  1334.         self.right_top_button1.grid(row=2, column=0, padx=20, pady=10)
  1335.         self.right_top_button2.grid(row=3, column=0, padx=20, pady=10)
  1336.         self.right_top_button3.grid(row=4, column=0, padx=20, pady=10)
  1337.  
  1338.         # 整体区域定位
  1339.         self.frame_left_top.grid(row=0, column=0, padx=2, pady=5)
  1340.         self.frame_right_top.grid(row=0, column=1, padx=30, pady=30)
  1341.         self.frame_center.grid(row=1, column=0, columnspan=2, padx=4, pady=5)
  1342.         self.frame_bottom.grid(row=2, column=0, columnspan=2)
  1343.  
  1344.         self.frame_left_top.grid_propagate(0)
  1345.         self.frame_right_top.grid_propagate(0)
  1346.         self.frame_center.grid_propagate(0)
  1347.         self.frame_bottom.grid_propagate(0)
  1348.  
  1349.         self.frame_left_top.tkraise()  # 开始显示主菜单
  1350.         self.frame_right_top.tkraise()  # 开始显示主菜单
  1351.         self.frame_center.tkraise()  # 开始显示主菜单
  1352.         self.frame_bottom.tkraise()  # 开始显示主菜单
  1353.  
  1354.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击
  1355.         self.window.mainloop()  # 进入消息循环
  1356.  
  1357.     def back(self):
  1358.         adminMessage(self.window)  # 显示主窗口 销毁本窗口
  1359.  
  1360.     def click(self, event):
  1361.         self.col = self.tree.identify_column(event.x)  # 列
  1362.         self.row = self.tree.identify_row(event.y)  # 行
  1363.  
  1364.         print(self.col)
  1365.         print(self.row)
  1366.         self.row_info = self.tree.item(self.row, "values")
  1367.         self.var_id.set(self.row_info[0])
  1368.         self.var_name.set(self.row_info[1])
  1369.         self.var_zhuyan.set(self.row_info[2])
  1370.         self.var_daoyan.set(self.row_info[3])
  1371.         self.var_jianjie.set(self.row_info[4])
  1372.         self.right_top_id_entry = Entry(self.frame_left_top, state='disabled', textvariable=self.var_id,
  1373.                                         font=('Verdana', 15))
  1374.  
  1375.         print('')
  1376.  
  1377.     def tree_sort_column(self, tv, col, reverse):  # Treeview、列名、排列方式
  1378.         l = [(tv.set(k, col), k) for k in tv.get_children('')]
  1379.         l.sort(reverse=reverse)  # 排序方式
  1380.         # rearrange items in sorted positions
  1381.         for index, (val, k) in enumerate(l):  # 根据排序后索引移动
  1382.             tv.move(k, '', index)
  1383.         tv.heading(col, command=lambda: self.tree_sort_column(tv, col, not reverse))  # 重写标题，使之成为再点倒序的标题
  1384.  
  1385.     def new_row(self):
  1386.         print('123')
  1387.         print(self.var_id.get())
  1388.         print(self.id)
  1389.         if str(self.var_id.get()) in self.id:
  1390.             messagebox.showinfo('警告！', '该电影已存在！')
  1391.         else:
  1392.             if self.var_id.get() != '' and self.var_name.get() != '' and self.var_zhuyan.get() != '' and self.var_daoyan.get() != ''and self.var_jianjie.get() !='':
  1393.                 # 打开数据库连接
  1394.                 con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  1395.                                       charset='utf8')
  1396.                 cursor = con.cursor()  # 使用cursor()方法获取操作游标
  1397.                 sql = "SELECT * FROM table_movie WHERE movie_name = '%s'" % (self.var_name.get())  # SQL 查询语句
  1398.                 try:
  1399.                     # 执行SQL语句
  1400.                     cursor.execute(sql)
  1401.                     # 获取所有记录列表
  1402.                     results = cursor.fetchall()
  1403.                     for row in results:
  1404.                        self.movie_id=row[0]
  1405.                     print(self.movie_id)
  1406.                 except:
  1407.                     print("Error: unable to fetch data")
  1408.                     messagebox.showinfo('警告！', '数据库连接失败！')
  1409.                 con.close()  # 关闭数据库连接
  1410.  
  1411.                 con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  1412.                                       charset='utf8')
  1413.                 cursor = con.cursor()  # 使用cursor()方法获取操作游标
  1414.                 sql1 = "INSERT INTO table_schedule(schedule_id, schedule_price,schedule_time,movie_id,hall_id,schedule_movie) \
  1415.     				       VALUES ('%s', '%s', '%s', '%s','%s','%s')" % \
  1416.                       (self.var_id.get(), self.var_daoyan.get(),  self.var_zhuyan.get(),self.movie_id,self.var_jianjie.get(),self.var_name.get())  # SQL 插入语句
  1417.                 try:
  1418.                     cursor.execute(sql1)  # 执行sql语句
  1419.                     con.commit()  # 提交到数据库执行
  1420.                 except:
  1421.                     con.rollback()  # 发生错误时回滚
  1422.                     messagebox.showinfo('警告！', '数据库连接失败！')
  1423.                 con.close()  # 关闭数据库连接
  1424.  
  1425.                 self.id.append(self.var_id.get())
  1426.                 self.name.append(self.var_name.get())
  1427.                 self.zhuyan.append(self.var_zhuyan.get())
  1428.                 self.daoyan.append(self.var_daoyan.get())
  1429.                 self.jianjie.append(self.var_jianjie.get())
  1430.                 self.tree.insert('', len(self.id) - 1, values=(
  1431.                     self.id[len(self.id) - 1], self.name[len(self.id) - 1], self.zhuyan[len(self.id) - 1],
  1432.                     self.daoyan[len(self.id) - 1],self.jianjie[len(self.id)-1]))
  1433.                 self.tree.update()
  1434.                 messagebox.showinfo('提示！', '插入成功！')
  1435.             else:
  1436.                 messagebox.showinfo('警告！', '请填写排片数据')
  1437.  
  1438.     def updata_row(self):
  1439.         res = messagebox.askyesnocancel('警告！', '是否更新所填数据？')
  1440.         if res == True:
  1441.             if self.var_id.get() == self.row_info[0]:  # 如果所填学号 与 所选学号一致
  1442.                 # 打开数据库连接
  1443.                 con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  1444.                                       charset='utf8')
  1445.                 cursor = con.cursor()  # 使用cursor()方法获取操作游标
  1446.                 sql = "UPDATE table_schedule SET schedule_price = '%s', schedule_time = '%s', movie_id = '%s',hall_id ='%s',schedule_movie ='%s' \
  1447.     				 WHERE movie_id = '%s'" % (
  1448.                 self.var_daoyan.get(), self.var_zhuyan.get(), self.movie_id, self.var_jianjie.get(),self.var_name.get(),self.var_id.get())  # SQL 插入语句
  1449.                 try:
  1450.                     cursor.execute(sql)  # 执行sql语句
  1451.                     con.commit()  # 提交到数据库执行
  1452.                     messagebox.showinfo('提示！', '更新成功！')
  1453.                 except:
  1454.                     con.rollback()  # 发生错误时回滚
  1455.                     messagebox.showinfo('警告！', '更新失败，数据库连接失败！')
  1456.                 con.close()  # 关闭数据库连接
  1457.  
  1458.                 id_index = self.id.index(self.row_info[0])
  1459.                 self.name[id_index] = self.var_name.get()
  1460.                 self.zhuyan[id_index] = self.var_zhuyan.get()
  1461.                 self.daoyan[id_index] = self.var_daoyan.get()
  1462.                 self.jianjie[id_index]=self.var_jianjie.get()
  1463.  
  1464.                 self.tree.item(self.tree.selection()[0], values=(
  1465.                     self.var_id.get(), self.var_name.get(), self.var_zhuyan.get(),
  1466.                     self.var_daoyan.get(),self.var_jianjie.get()))  # 修改对于行信息
  1467.             else:
  1468.                 messagebox.showinfo('警告！', '不能修改订单号！')
  1469.  
  1470.     def del_row(self):
  1471.         res = messagebox.askyesnocancel('警告！', '是否删除所选数据？')
  1472.         if res == True:
  1473.             print(self.row_info[0])  # 鼠标选中的学号
  1474.             print(self.tree.selection()[0])  # 行号
  1475.             print(self.tree.get_children())  # 所有行
  1476.             # 打开数据库连接
  1477.             con = pymysql.connect(host='localhost', port=3306, user='root', passwd='112233', db='dyy',
  1478.                                   charset='utf8')
  1479.             cursor = con.cursor()  # 使用cursor()方法获取操作游标
  1480.             sql = "DELETE FROM table_schedule WHERE schedule_id = '%s'" % (self.row_info[0])  # SQL 插入语句
  1481.             try:
  1482.                 cursor.execute(sql)  # 执行sql语句
  1483.                 con.commit()  # 提交到数据库执行
  1484.                 messagebox.showinfo('提示！', '删除成功！')
  1485.             except:
  1486.                 con.rollback()  # 发生错误时回滚
  1487.                 messagebox.showinfo('警告！', '删除失败，数据库连接失败！')
  1488.             con.close()  # 关闭数据库连接
  1489.  
  1490.             id_index = self.id.index(self.row_info[0])
  1491.             print(id_index)
  1492.             del self.id[id_index]
  1493.             del self.name[id_index]
  1494.             del self.zhuyan[id_index]
  1495.             del self.daoyan[id_index]
  1496.             del self.jianjie[id_index]
  1497.             del self.movie_id[id_index]
  1498.             print(self.id)
  1499.             self.tree.delete(self.tree.selection()[0])  # 删除所选行
  1500.             print(self.tree.get_children())
  1501.  
  1502.  
  1503.  
  1504.  
  1505. win = tk.Tk()
  1506. beginpage(win)

 

 

 

 

 

 

 

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/凡人多烦事01/article/detail/124853
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号