devbox
黑客灵魂
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

数据库课程设计python——图书馆管理系统_图书馆数据课设计

作者：黑客灵魂 | 2024-07-21 03:39:05

赞

踩

图书馆数据课设计

对我来说挺大一个工作内容了，用户操作界面的代码是从别人的文章里拿来然后改的，文章有时间我找找会放进来

功能与结构

构建数据库（本地）

用的是SQL server，根据逻辑结构来建表，以及触发器

建表

  1. CREATE DATABASE LibraryManage ON 
  2. PRIMARY
  3. (NAME = xsgl_Data, FILENAME = 'D:\DBF\LibraryManage.mdf', FILEGROWTH = 5)
  4. LOG ON
  5. (NAME = xsgl_Log, FILENAME = 'D:\DBF\LibraryManage.ldf', FILEGROWTH = 5)
  6.  
  7. GO
  8. USE LibraryManage
  9. CREATE TABLE Users
  10. (u_id CHAR(10) PRIMARY KEY,
  11. u_password VARCHAR(20) NOT NULL, 
  12. u_Admin BIT DEFAULT 0,
  13. u_name VARCHAR(20) NOT NULL, 
  14. user_phone CHAR(11), 
  15. user_adress VARCHAR(60),
  16. )
  17.  
  18. CREATE TABLE Books
  19. (book_id CHAR(10) PRIMARY KEY, 
  20. book_name VARCHAR(40), 
  21. author VARCHAR(40),
  22. press VARCHAR(40), 
  23. collocation_num INT, 
  24. lendable INT, 
  25. CONSTRAINT check_lendable CHECK (lendable <= collocation_num)
  26. )
  27.  
  28. CREATE TABLE Records
  29. (Record_id INT IDENTITY(100000,1) PRIMARY KEY, 
  30. u_id CHAR(10) FOREIGN KEY (u_id) REFERENCES Users(u_id),
  31. book_id CHAR(10) FOREIGN KEY (book_id) REFERENCES Books(book_id),
  32. lend_time DATETIME, 
  33. return_time DATETIME
  34. )
  35.  
  36. CREATE TABLE Lending
  37. (Record_id INT, 
  38. u_id CHAR(10), 
  39. book_id CHAR(10), 
  40. lend_time DATETIME
  41. FOREIGN KEY (Record_id) REFERENCES Records(Record_id)
  42. )
  43.  
  44. INSERT INTO Users(u_id, u_password, u_Admin, u_name, user_phone)
  45. VALUES('0000000100','666', 1, '巩啊', '13912345678')
  46.  
  47. INSERT INTO Users(u_id, u_password, u_name, user_phone)
  48. VALUES
  49. ('0000000101','yqowzrxcwe', '李梓萱', '13812345678'),
  50. ('0000000102','mnahsduf', '张婧宸', '13712345678'),
  51. ('0000000103','cxnjmqzp', '赵奕涵', '13612345678'),
  52. ('0000000104','skwopdtnbf', '刘子怡', '13512345678'),
  53. ('0000000105','qweasdzxc', '陈思婷', '13412345678'),
  54. ('0000000106','poiuytrewq', '杨晨阳', '13312345678'),
  55. ('0000000107','ljhgfdsazx', '吴思涵', '18212345678'),
  56. ('0000000108','ytbvfrde', '周俊逸', '18112345678'),
  57. ('0000000109','mnbvcxzlkj', '孙雅菲', '18012345678'),
  58. ('0000000110','qwertyuiop', '郭雨莹', '15912345678'),
  59. ('0000000111','zxcvbnmasd', '唐子涵', '15812345678'),
  60. ('0000000112','asdfghjkl', '罗雨柔', '15712345678'),
  61. ('0000000113','poiuytrewq', '贾子萱', '15612345678'),
  62. ('0000000114','lkjhgfdsa', '尹忆萱', '15512345678'),
  63. ('0000000115','zxcvbnm', '段晨雨', '15412345678'),
  64. ('0000000116','asdfgh', '黄梓涵', '15312345678'),
  65. ('0000000117','qwerty', '董思涵', '15212345678'),
  66. ('0000000118','zxcvbn', '梁婧怡', '15112345678'),
  67. ('0000000119','asdfghj', '叶雨萱', '15012345678'),
  68. ('0000000120','poiuytre', '钟子涵', '14912345678'),
  69. ('0000000121','lkjhgf', '姚雅菲', '14812345678'),
  70. ('0000000122','zxcvbnm', '贺晨雨', '14712345678'),
  71. ('0000000123','qazwsx', '方梓涵', '14612345678'),
  72. ('0000000124','rfvtgb', '石晨阳', '14512345678'),
  73. ('0000000125','edcrfv', '常子萱', '14412345678'),
  74. ('0000000126','tgbnhy', '韩忆萱', '14312345678'),
  75. ('0000000127','ujmik,', '龙晨雨', '14212345678'),
  76. ('0000000128','yhnmju', '毛梓涵', '14112345678'),
  77. ('0000000129','poiuhg', '万雨萱', '14012345678'),
  78. ('0000000130','rewqas', '宋子涵', '13912345678')
  79.  
  80. INSERT INTO Books (book_id, book_name, author, press, collocation_num, lendable)
  81. VALUES
  82. ('1000000000', '骆驼祥子', '老舍', '北京教育出版社', 20, 18),
  83. ('1000000001', '围城', '钱钟书', '人民文学出版社', 30, 28),
  84. ('1000000002', '活着', '余华', '作家出版社', 25, 23),
  85. ('1000000003', '1984', '乔治·奥威尔', '南海出版公司', 15, 12),
  86. ('1000000004', '平凡的世界', '路遥', '人民文学出版社', 40, 37),
  87. ('1000000005', '白夜行', '东野圭吾', '南海出版公司', 18, 15),
  88. ('1000000006', '红楼梦', '曹雪芹', '人民文学出版社', 35, 32),
  89. ('1000000007', '傲慢与偏见', '简·奥斯汀', '外语教学与研究出版社', 22, 19),
  90. ('1000000008', '三体', '刘慈欣', '重庆出版社', 28, 25),
  91. ('1000000009', '追风筝的人', '卡勒德·胡赛尼', '上海人民出版社', 33, 30),
  92. ('1000000010', '小王子', '圣埃克苏佩里', '人民文学出版社', 20, 17),
  93. ('1000000012', '嫌疑人X的献身', '东野圭吾', '南海出版公司', 30, 27),
  94. ('1000000013', '百年孤独', '加西亚·马尔克斯', '南海出版公司', 38, 34),
  95. ('1000000014', '人类简史', '尤瓦尔·赫拉利', '中信出版社', 26, 24),
  96. ('1000000015', '解忧杂货店', '东野圭吾', '南海出版公司', 23, 20),
  97. ('1000000017', '月亮与六便士', '毛姆', '人民文学出版社', 29, 27),
  98. ('1000000018', '白鹿原', '陈忠实', '作家出版社', 27, 24),
  99. ('1000000019', '战争与和平', '列夫·托尔斯泰', '人民文学出版社', 32, 29),
  100. ('1000000020', '偷影子的人', '马克·李维', '北京联合出版公司', 19, 17),
  101. ('1000000021', '囚鸟', '冯内古特', '上海译文出版社', 24, 21),
  102. ('1000000022', '乌合之众', '古斯塔夫·勒庞', '中华书局', 28, 25),
  103. ('1000000023', '基督山伯爵', '大仲马', '上海译文出版社', 32, 29),
  104. ('1000000025', '金字塔原理', '芭芭拉·明托', '机械工业出版社', 20, 17),
  105. ('1000000026', '肖申克的救赎', '斯蒂芬·金', '人民文学出版社', 30, 27),
  106. ('1000000027', '福尔摩斯探案集', '阿瑟·柯南·道尔', '北京联合出版公司', 22, 19),
  107. ('1000000028', '非暴力沟通', '马维·罗森伯格', '中信出版社', 18, 15),
  108. ('1000000030', '霍乱时期的爱情', '加西亚·马尔克斯', '南海出版公司', 34, 30),
  109. ('1000000031', '时间简史', '斯蒂芬·霍金', '湖南科学技术出版社', 20, 17),
  110. ('1000000032', '人间失格', '太宰治', '筑摩书房', 25, 22),
  111. ('1000000033', '飘', '玛格丽特·米切尔', '上海人民出版社', 28, 25),
  112. ('1000000034', '月亮与六便士', '毛姆', '人民文学出版社', 33, 30),
  113. ('1000000035', '杀死一只知更鸟', '哈珀·李', '译林出版社', 24, 21),
  114. ('1000000036', '黄金时代', '王小波', '作家出版社', 27, 24),
  115. ('1000000038', '盗墓笔记', '南派三叔', '民主与建设出版社', 30, 27)

触发器

借书还书操作通过触发器来设计的，借阅记录表是Records、储存当前借出的书籍的表是Lending

当用户借书时，

• 借阅记录中增加一条记录
• 并且将记录也添加到当前借阅的书
• 更新书籍信息，可借数量减少一本

当用户还书时，

• 更新借阅记录之中的还书时间
• 从当前借阅的书中删除相应记录，
• 更新书籍信息，可借数量增加一本 

  1. GO
  2. CREATE TRIGGER when_lend ON Records
  3. 	INSTEAD OF INSERT 
  4. AS 
  5. DECLARE @insertUID char(10),@insertBID char(10),@rest INT,
  6. 		@time datetime
  7. SELECT @insertUID=u_id,@insertBID=book_id
  8. FROM inserted
  9. SELECT @rest=lendable
  10. FROM Books
  11. WHERE book_id=@insertBID
  12. IF @rest<=0
  13. BEGIN
  14. PRINT('该书不足')
  15. END
  16. ELSE
  17. BEGIN
  18. SET	@time=getdate()
  19. INSERT INTO Records(u_id,book_id,lend_time)
  20. SELECT	u_id,book_id,@time
  21. FROM inserted
  22. DECLARE @RID INT
  23. SET @RID = SCOPE_IDENTITY()
  24. INSERT INTO Lending
  25. VALUES (@RID,@insertUID,@insertBID,@time)
  26. UPDATE Books
  27. SET lendable=lendable-1
  28. WHERE book_id=@insertBID
  29. END
  30.  
  31. GO
  32. CREATE TRIGGER when_return ON Lending
  33. 	AFTER DELETE
  34. AS 
  35. DECLARE @UID char(10),@BID char(10),@RID INT,
  36. 		@time datetime
  37. SELECT @RID=Record_id,@UID=u_id,@BID=book_id
  38. FROM deleted
  39. BEGIN
  40. SET	@time=getdate()
  41. UPDATE Records
  42. SET return_time=@time
  43. WHERE Record_id=@RID
  44. UPDATE Books
  45. SET lendable=lendable+1
  46. WHERE book_id=@BID
  47. END

操作与用户界面python

首页

  1. import pymssql
  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.  
  8. class StartPage:
  9.     def __init__(self, parent_window):
  10.         parent_window.destroy() # 销毁子界面
  11.  
  12.         self.window = tk.Tk()  # 初始框的声明
  13.         self.window.title('图书借阅管理系统')
  14.         self.window.geometry('600x400') # 这里的乘是小x
  15.  
  16.         label = Label(self.window, text="图书借阅管理系统", font=("Verdana", 20))
  17.         label.pack(pady=80) # 界面的长度
  18.  
  19.         Button(self.window, text="用户登陆", font=tkFont.Font(size=16), command = lambda: UserLogin(self.window), width=30,\
  20.                 height=2,fg='white', bg='gray', activebackground='black', activeforeground='white').pack()
  21.         Button(self.window, text="注册", font=tkFont.Font(size=16), command = lambda: Register(), width=30, height=2,\
  22.                 fg='white', bg='gray', activebackground='black', activeforeground='white').pack()
  23.         Button(self.window, text='退出系统', height=2, font=tkFont.Font(size=16), width=30, command=self.window.destroy,\
  24.                fg='white', bg='gray', activebackground='black', activeforeground='white').pack()
  25.  
  26.         self.window.mainloop() # 主消息循环

注册界面

  1. class Register:
  2.     def __init__(self):
  3.         self.window = tk.Tk()
  4.         self.window.title('注册')
  5.         self.window.geometry('300x450')
  6.         
  7.         label = tk.Label(self.window, text='用户注册', bg='green', font=('Verdana', 20), width=30, height=2)
  8.         label.pack()
  9.                 
  10.         Label(self.window, text='请输入账号(长度为10)', font=tkFont.Font(size=14)).pack(pady=10)
  11.         self.u_id = tk.Entry(self.window, width=30, font=tkFont.Font(size=14), bg='Ivory')
  12.         self.u_id.pack()
  13.         
  14.         Label(self.window, text='请设置密码：', font=tkFont.Font(size=14)).pack(pady=10)
  15.         self.u_password = tk.Entry(self.window, width=30, font=tkFont.Font(size=14), bg='Ivory')
  16.         self.u_password.pack()
  17.         
  18.         Label(self.window, text='请输入姓名：', font=tkFont.Font(size=14)).pack(pady=10)
  19.         self.u_name = tk.Entry(self.window, width=30, font=tkFont.Font(size=14), bg='Ivory')
  20.         self.u_name.pack()
  21.         
  22.         Label(self.window, text='请输入电话：', font=tkFont.Font(size=14)).pack(pady=10)
  23.         self.u_phone = tk.Entry(self.window, width=30, font=tkFont.Font(size=14), bg='Ivory')
  24.         self.u_phone.pack()
  25.         
  26.         Button(self.window, text="注册", width=8, font=tkFont.Font(size=12), command=self.register).pack(pady=40)
  27.         self.window.mainloop()  # 进入消息循环
  28.         
  29.     def register(self):
  30.         db = pymssql.connect(server="localhost",database="LibraryManage", charset='utf8')  # 打开数据库连接
  31.         cursor = db.cursor()  # 使用cursor()方法获取操作游标
  32.         sql = "SELECT * FROM Users WHERE u_id = '%s'" % (self.u_id.get())  # SQL 查询语句
  33.         cursor.execute(sql)
  34.         results = cursor.fetchall()
  35.         if len(self.u_id.get()) != 10:
  36.             messagebox.showinfo('警告！', '请输入十位数字')
  37.             return None
  38.         if len(list(results)) != 0:
  39.             messagebox.showinfo('警告！', '账号已被注册')
  40.             return None
  41.         try:
  42.             sql = "INSERT INTO Users(u_id, u_password, u_name, user_phone) VALUES('%s','%s','%s','%s')" \
  43.             %(self.u_id.get(), self.u_password.get(), self.u_name.get(), self.u_phone.get())
  44.             cursor.execute(sql)
  45.             db.commit()
  46.             messagebox.showinfo('提示！', '注册成功！')
  47.             self.window.destroy()
  48.         except:
  49.             messagebox.showinfo('警告！', '出错了')

登录界面

  1. #登陆页面
  2. class UserLogin:
  3.     def __init__(self, parent_window):
  4.         parent_window.destroy() # 销毁主界面
  5.  
  6.         self.window = tk.Tk()  # 初始框的声明
  7.         self.window.title('学生登陆')
  8.         self.window.geometry('300x450')  # 这里的乘是小x
  9.  
  10.         label = tk.Label(self.window, text='学生登陆', bg='green', font=('Verdana', 20), width=30, height=2)
  11.         label.pack()
  12.  
  13.         Label(self.window, text='账号：', font=tkFont.Font(size=14)).pack(pady=25)
  14.         self.u_id = tk.Entry(self.window, width=30, font=tkFont.Font(size=14), bg='Ivory')
  15.         self.u_id.pack()
  16.  
  17.         Label(self.window, text='密码：', font=tkFont.Font(size=14)).pack(pady=25)
  18.         self.u_password = tk.Entry(self.window, width=30, font=tkFont.Font(size=14), bg='Ivory', show='*')
  19.         self.u_password.pack()
  20.  
  21.         Button(self.window, text="登陆", width=8, font=tkFont.Font(size=12), command=self.login).pack(pady=40)
  22.         Button(self.window, text="返回首页", width=8, font=tkFont.Font(size=12), command=self.back).pack()
  23.  
  24.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击
  25.         self.window.mainloop()  # 进入消息循环
  26.  
  27.     def login(self):
  28.         stu_pass = None
  29.  
  30.         # 数据库操作 查询管理员表
  31.         db = pymssql.connect(server="localhost",database="LibraryManage", charset='utf8')  # 打开数据库连接
  32.         cursor = db.cursor()  # 使用cursor()方法获取操作游标
  33.         sql = "SELECT * FROM Users WHERE u_id = '%s'" % (self.u_id.get())  # SQL 查询语句
  34.         try:
  35.             # 执行SQL语句
  36.             cursor.execute(sql)
  37.             # 获取所有记录列表
  38.             u_password = None
  39.             results = cursor.fetchall()
  40.             for row in results:
  41.                 u_id = row[0]
  42.                 u_password = row[1]
  43.                 u_Admin = row[2]
  44.                 u_name = row[3].encode("l1").decode("GBK")
  45.         except:
  46.             messagebox.showinfo('警告！', '用户名或密码不正确！')
  47.         db.close()  # 关闭数据库连接
  48.  
  49.         if self.u_password.get() == u_password:
  50.             UserMenu(self.window, u_id, u_name,u_Admin) # 进入学生信息查看界面
  51.         else:
  52.             messagebox.showinfo('警告！', '用户名或密码不正确！')
  53.  
  54.     def back(self):
  55.         StartPage(self.window)  # 显示主窗口 销毁本窗口

用户界面

  1. #学生界面
  2. class UserMenu:
  3.     def __init__(self, parent_window, u_id, u_name, Admin = 0):
  4.         parent_window.destroy() # 销毁主界面
  5.         self.u_id = u_id
  6.         self.u_name = u_name
  7.         self.Admin = Admin
  8.         self.window = Tk()  # 初始框的声明
  9.         self.window.title('用户操作界面')
  10.         #———————————————————————————————————————————————————————————中心列表区域———————————————————————————————————————————
  11.         self.frame_center = tk.Frame(width=800, height=400)
  12.         # 定义下方中心列表区域
  13.         self.center_title = Label(self.frame_center, text="借阅的书", font=('Verdana', 20))
  14.         self.center_title.grid(row = 0)  # 位置设置 
  15.         self.columns = ("图书编号", "书名", "作者", "出版社", "借阅时间")
  16.         self.tree = ttk.Treeview(self.frame_center, show="headings", height=18, columns=self.columns)
  17.         self.vbar = ttk.Scrollbar(self.frame_center, orient=VERTICAL, command=self.tree.yview)
  18.         # 定义树形结构与滚动条
  19.         self.tree.configure(yscrollcommand=self.vbar.set)
  20.         # 表格的标题
  21.         self.tree.column("图书编号", width=100, anchor='center')  # 表示列,不显示
  22.         self.tree.column("书名", width=200, anchor='center')
  23.         self.tree.column("作者", width=100, anchor='center')
  24.         self.tree.column("出版社", width=100, anchor='center')
  25.         self.tree.column("借阅时间", width=200, anchor='center')
  26.         # 调用方法获取表格内容插入
  27.         self.tree.grid(row=1, column=0, sticky=NSEW)
  28.         self.vbar.grid(row=1, column=1, sticky=NS)
  29.  
  30.         self.book_id = []
  31.         self.book_name = []
  32.         self.auther = []
  33.         self.press = []
  34.         self.lend_time = []
  35.         # 打开数据库连接
  36.         try:
  37.             db = pymssql.connect(server="localhost",database="LibraryManage")
  38.             cursor = db.cursor()  # 使用cursor()方法获取操作游标
  39.             
  40.             sql = """
  41.             SELECT Books.book_id, book_name, author, press, lend_time
  42.             FROM Books, Lending
  43.             WHERE u_id = %s AND
  44.             Lending.book_id = Books.book_id
  45.             """%(self.u_id)
  46.             
  47.             cursor.execute(sql)
  48.  
  49.             results = cursor.fetchall()
  50.             self.lendable = len(results)
  51.             for row in results:
  52.                 self.book_id.append(row[0])
  53.                 self.book_name.append(row[1].encode("l1").decode("GBK"))
  54.                 self.auther.append(row[2].encode("l1").decode("GBK"))
  55.                 self.press.append(row[3].encode("l1").decode("GBK"))
  56.                 self.lend_time.append(row[4])
  57.             db.close()# 关闭数据库连接
  58.         except:
  59.             messagebox.showinfo('警告！', '数据库连接失败！')
  60.             
  61.         # 写入数据   
  62.         n = len(self.book_id)
  63.         for i in range(n): 
  64.             self.tree.insert('', i, values=(self.book_id[i], self.book_name[i], self.auther[i], self.press[i], self.lend_time[i]))
  65.  
  66.         for col in self.columns:  # 绑定函数，使表头可排序
  67.             self.tree.heading(col, text=col,\
  68.                               command=lambda _col=col: self.tree_sort_column(self.tree, _col, False))       
  69.         self.tree.bind('<Button-1>', self.click)
  70.         
  71.         
  72.         self.frame_center.grid(row=1, column=0, columnspan=2, padx=4, pady=5)
  73.         self.frame_center.grid_propagate(0)
  74.         self.frame_center.tkraise() # 开始显示主菜单
  75.         #————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
  76.         
  77.         
  78.         #——————————————————————————————————————————————————————————左侧借书区域—————————————————————————————————————————————————————
  79.         self.frame_left_top = tk.Frame(width=300, height=200)
  80.         
  81.         self.top_title = Label(self.frame_left_top, text="用户信息:", font=('Verdana', 20))
  82.         self.top_title.grid(row=0, columnspan=2, sticky=NSEW, padx=50, pady=10)
  83.         
  84.         # u_id
  85.         self.left_top_u_id = Label(self.frame_left_top, text="用户编号:" + self.u_id, font=('Verdana', 15))
  86.         self.left_top_u_id.grid(row=1)  # 位置设置
  87.         
  88.         # u_name
  89.         self.left_top_u_name = Label(self.frame_left_top, text="姓名：" +self.u_name , font=('Verdana', 15))
  90.         self.left_top_u_name.grid(row=2)  # 位置设置
  91.         
  92.         # button
  93.         self.left_top_button = ttk.Button(self.frame_left_top, text='借书', width=20, \
  94.                                           command=lambda: Borrow(self.window, self.u_id, self.u_name, self.lendable, self.Admin))
  95.         self.left_top_button.grid(row=3, padx=20, pady=10)
  96.         
  97.         self.frame_left_top.grid(row=0, padx=2, pady=5)
  98.         self.frame_left_top.grid_propagate(0)
  99.         self.frame_left_top.tkraise() # 开始显示主菜单
  100.         #——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
  101.         
  102.         
  103.         #————————————————————————————————————————————————————————右侧还书区域—————————————————————————————————————————————————————————
  104.         self.frame_right_top = tk.Frame(width=400, height=200)
  105.         self.var_id = StringVar()  # 声明书号
  106.         self.var_name = StringVar()
  107.         
  108.         # 书编号
  109.         self.right_top_bid_label = Label(self.frame_right_top, text="书编号：", font=('Verdana', 15))
  110.         self.right_top_bid_entry = Entry(self.frame_right_top, textvariable=self.var_id, font=('Verdana', 15))
  111.         self.right_top_bid_label.grid(row=0, column=0)  # 位置设置
  112.         self.right_top_bid_entry.grid(row=0, column=1)
  113.         
  114.         # 书名
  115.         self.right_top_bname_label = Label(self.frame_right_top, text="书名：", font=('Verdana', 15))
  116.         self.right_top_bname_entry = Entry(self.frame_right_top, textvariable=self.var_name, font=('Verdana', 15))
  117.         self.right_top_bname_label.grid(row=1, column=0)  # 位置设置
  118.         self.right_top_bname_entry.grid(row=1, column=1)
  119.         
  120.         #还书操作
  121.         self.right_top_button = ttk.Button(self.frame_right_top, text='还书', width=20, command = self.delete)
  122.         self.right_top_button.grid(row=2, padx=20, pady=10)
  123.         
  124.         if Admin:
  125.             self.right_top_button = ttk.Button(self.frame_right_top, text='管理用户', width=20, command = lambda:Users(self.window))
  126.             self.right_top_button.grid(row=3, padx=20, pady=10)
  127.             
  128.             self.right_top_button = ttk.Button(self.frame_right_top, text='查询记录', width=20, command = lambda:Records(self.window))
  129.             self.right_top_button.grid(row=3,column = 1, padx=20, pady=10)
  130.         
  131.         self.frame_right_top.grid(row=0, column=1, padx=30, pady=30)
  132.         self.frame_right_top.grid_propagate(0)
  133.         self.frame_right_top.tkraise() # 开始显示主菜单
  134.         #——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
  135.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击
  136.         self.window.mainloop()  # 进入消息循环
  137.         
  138.         
  139.     def click(self, event):
  140.         self.col = self.tree.identify_column(event.x)  # 列
  141.         self.row = self.tree.identify_row(event.y)  # 行
  142.         self.row_info = self.tree.item(self.row, "values")
  143.         self.var_id.set(self.row_info[0])
  144.         self.var_name.set(self.row_info[1])
  145.         self.right_top_bid_entry = Entry(self.frame_right_top, textvariable=self.var_id, font=('Verdana', 15))
  146.         self.right_top_bname_entry = Entry(self.frame_right_top, textvariable=self.var_name, font=('Verdana', 15))
  147.     def back(self):
  148.         StartPage(self.window) # 显示主窗口 销毁本窗口
  149.         
  150.     def delete(self):
  151.         res = messagebox.askyesnocancel('确认还书', "是否归还此书：《%s》 ？" %(self.var_name.get()))
  152.         if res == True:
  153.             try:
  154.                 db = pymssql.connect(server="localhost",database="LibraryManage", charset='utf8')  # 打开数据库连接
  155.                 cursor = db.cursor()  # 使用cursor()方法获取操作游标
  156.                 sql = "DELETE FROM Lending WHERE u_id = '%s' AND book_id = '%s'" %(self.u_id, self.var_id.get())  # SQL DELETE语句
  157.             
  158.                 cursor.execute(sql)  # 执行sql语句
  159.                 db.commit()  # 提交到数据库执行
  160.                 messagebox.showinfo('提示！', '归还成功！')
  161.                 db.close()  # 关闭数据库连接
  162.                 UserMenu(self.window, self.u_id, self.u_name, self.Admin)
  163.             except:
  164.                 messagebox.showinfo('警告！', '更新失败，数据库连接失败！')

借书界面

  1. class Borrow:
  2.     def __init__(self,parent_window, u_id, u_name, num, Admin):
  3.         parent_window.destroy() # 销毁主界面
  4.         self.num = num
  5.         self.u_id = u_id
  6.         self.u_name = u_name
  7.         self.Admin = Admin
  8.         self.window = Tk()  # 初始框的声明
  9.         self.window.title('借书')
  10.         #———————————————————————————————————————————————————————————中心列表区域———————————————————————————————————————————
  11.         self.frame_center = tk.Frame(width=800, height=400)
  12.         # 定义下方中心列表区域
  13.         self.center_title = Label(self.frame_center, text="选择图书", font=('Verdana', 20))
  14.         self.center_title.grid(row = 0)  # 位置设置 
  15.         
  16.         self.columns = ("图书编号", "书名", "作者", "出版社", "剩余数量")
  17.         self.tree = ttk.Treeview(self.frame_center, show="headings", height=18, columns=self.columns)
  18.         self.vbar = ttk.Scrollbar(self.frame_center, orient=VERTICAL, command=self.tree.yview)
  19.         # 定义树形结构与滚动条
  20.         self.tree.configure(yscrollcommand=self.vbar.set)
  21.         # 表格的标题
  22.         self.tree.column("图书编号", width=100, anchor='center')  # 表示列,不显示
  23.         self.tree.column("书名", width=200, anchor='center')
  24.         self.tree.column("作者", width=100, anchor='center')
  25.         self.tree.column("出版社", width=100, anchor='center')
  26.         self.tree.column("剩余数量", width=100, anchor='center')
  27.         # 调用方法获取表格内容插入
  28.         self.tree.grid(row=1, column=0, sticky=NSEW)
  29.         self.vbar.grid(row=1, column=1, sticky=NS)
  30.  
  31.         self.book_id = []
  32.         self.book_name = []
  33.         self.auther = []
  34.         self.press = []
  35.         self.lendable = []
  36.         # 打开数据库连接
  37.         try:
  38.             db = pymssql.connect(server="localhost",database="LibraryManage")
  39.             cursor = db.cursor()  # 使用cursor()方法获取操作游标
  40.             
  41.             sql = 'SELECT book_id, book_name, author, press, lendable FROM Books'
  42.             cursor.execute(sql)
  43.             results = cursor.fetchall()
  44.             for row in results:
  45.                 self.book_id.append(row[0])
  46.                 self.book_name.append(row[1].encode("l1").decode("GBK"))
  47.                 self.auther.append(row[2].encode("l1").decode("GBK"))
  48.                 self.press.append(row[3].encode("l1").decode("GBK"))
  49.                 self.lendable.append(row[4])
  50.             db.close()# 关闭数据库连接
  51.         except:
  52.             print("Error: unable to fetch data")
  53.             messagebox.showinfo('警告！', '数据库连接失败！')
  54.             
  55.         # 写入数据   
  56.         n = len(self.book_id)
  57.         for i in range(n): 
  58.             self.tree.insert('', i, values=(self.book_id[i], self.book_name[i], self.auther[i], self.press[i], self.lendable[i]))
  59.  
  60.         for col in self.columns:  # 绑定函数，使表头可排序
  61.             self.tree.heading(col, text=col,\
  62.                               command=lambda _col=col: self.tree_sort_column(self.tree, _col, False))       
  63.         self.tree.bind('<Button-1>', self.click)
  64.         
  65.         
  66.         self.frame_center.grid(row=1, column=0, columnspan=2, padx=4, pady=5)
  67.         self.frame_center.grid_propagate(0)
  68.         self.frame_center.tkraise() # 开始显示主菜单
  69.         #————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
  70.         
  71.         
  72.         #——————————————————————————————————————————————————————————左侧借书区域—————————————————————————————————————————————————————
  73.         self.frame_left_top = tk.Frame(width=300, height=200)
  74.         
  75.         self.top_title = Label(self.frame_left_top, text="用户信息:", font=('Verdana', 20))
  76.         self.top_title.grid(row=0, columnspan=2, sticky=NSEW, padx=50, pady=10)
  77.         
  78.         # u_id
  79.         self.left_top_u_id = Label(self.frame_left_top, text="用户编号:" + self.u_id, font=('Verdana', 15))
  80.         self.left_top_u_id.grid(row=1)  # 位置设置
  81.         
  82.         # u_name
  83.         self.left_top_u_name = Label(self.frame_left_top, text="姓名：" +self.u_name , font=('Verdana', 15))
  84.         self.left_top_u_name.grid(row=2)  # 位置设置
  85.         
  86.         # 可借数量
  87.         self.left_top_u_name = Label(self.frame_left_top, text="当前借阅数： %s / 5" %(num) , font=('Verdana', 20))
  88.         self.left_top_u_name.grid(row=3)  # 位置设置
  89.         
  90.         self.frame_left_top.grid(row=0, padx=2, pady=5)
  91.         self.frame_left_top.grid_propagate(0)
  92.         self.frame_left_top.tkraise() # 开始显示主菜单
  93.         #——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
  94.         
  95.         
  96.         #————————————————————————————————————————————————————————右侧借书区域—————————————————————————————————————————————————————————
  97.         self.frame_right_top = tk.Frame(width=400, height=200)
  98.         self.var_id = StringVar()  # 声明书号
  99.         self.var_name = StringVar()
  100.         self.lendable_book = StringVar()
  101.         
  102.         # 书编号
  103.         self.right_top_bid_label = Label(self.frame_right_top, text="书编号：", font=('Verdana', 15))
  104.         self.right_top_bid_entry = Entry(self.frame_right_top, textvariable=self.var_id, font=('Verdana', 15))
  105.         self.right_top_bid_label.grid(row=0, column=0)  # 位置设置
  106.         self.right_top_bid_entry.grid(row=0, column=1)
  107.         
  108.         # 书名
  109.         self.right_top_bname_label = Label(self.frame_right_top, text="书名：", font=('Verdana', 15))
  110.         self.right_top_bname_entry = Entry(self.frame_right_top, textvariable=self.var_name, font=('Verdana', 15))
  111.         self.right_top_bname_label.grid(row=1, column=0)  # 位置设置
  112.         self.right_top_bname_entry.grid(row=1, column=1)
  113.         
  114.         #借书操作
  115.         self.right_top_button = ttk.Button(self.frame_right_top, text='借书', width=20, command = self.insert)
  116.         self.right_top_button.grid(row=2, padx=20, pady=10)
  117.         
  118.         self.frame_right_top.grid(row=0, column=1, padx=30, pady=30)
  119.         self.frame_right_top.grid_propagate(0)
  120.         self.frame_right_top.tkraise() # 开始显示主菜单
  121.         #——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
  122.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击
  123.         self.window.mainloop()  # 进入消息循环
  124.         
  125.         
  126.     def click(self, event):
  127.         self.col = self.tree.identify_column(event.x)  # 列
  128.         self.row = self.tree.identify_row(event.y)  # 行
  129.         self.row_info = self.tree.item(self.row, "values")
  130.         self.var_id.set(self.row_info[0])
  131.         self.var_name.set(self.row_info[1])
  132.         self.lendable_book.set(self.row_info[4])
  133.         self.right_top_bid_entry = Entry(self.frame_right_top, textvariable=self.var_id, font=('Verdana', 15))
  134.         self.right_top_bname_entry = Entry(self.frame_right_top, textvariable=self.var_name, font=('Verdana', 15))
  135.         
  136.     def insert(self):
  137.         if self.num >= 5:
  138.             messagebox.showinfo('提示！', '达到最大借阅数量，请先归还书籍。')
  139.             UserMenu(self.window, self.u_id, self.u_name)
  140.             return None
  141.         if int(self.lendable_book.get()) <= 0:
  142.             messagebox.showinfo('提示！', '该书数量不足，换一本书吧！')
  143.             return None
  144.         res = messagebox.askyesnocancel('确认借书', "是借阅此书：《%s》 ？" %(self.var_name.get()))
  145.         
  146.         if res == True:
  147.             try:
  148.                 db = pymssql.connect(server="localhost",database="LibraryManage", charset='utf8')  # 打开数据库连接
  149.                 cursor = db.cursor()  # 使用cursor()方法获取操作游标
  150.                 sql = "INSERT INTO Records(u_id,book_id) VALUES('%s', '%s')" %(self.u_id, self.var_id.get())  # SQL INSERT语句
  151.             
  152.                 cursor.execute(sql)  # 执行sql语句
  153.                 db.commit()  # 提交到数据库执行
  154.                 messagebox.showinfo('提示！', '借阅成功！')
  155.                 db.close()  # 关闭数据库连接
  156.                 UserMenu(self.window, self.u_id, self.u_name, self.Admin)
  157.             except:
  158.                 db.rollback()  # 发生错误时回滚
  159.                 messagebox.showinfo('警告！', '更新失败，数据库连接失败！')
  160.                 
  161.     def back(self):
  162.         UserMenu(self.window, self.u_id, self.u_name, self.Admin)

 管理用户

  1. class Users:
  2.     def __init__(self,parent_Window):
  3.         parent_Window.destroy()
  4.         self.window = Tk()  # 初始框的声明
  5.         self.window.title('管理界面')
  6.         
  7.      #———————————————————————————————————————————————————————————中心列表区域———————————————————————————————————————————
  8.         self.frame_center = tk.Frame(width=800, height=400)
  9.         # 定义下方中心列表区域
  10.         self.center_title = Label(self.frame_center, text="用户信息", font=('Verdana', 20))
  11.         self.center_title.grid(row = 0)  # 位置设置 
  12.         self.columns = ("用户ID", "姓名", "密码", "电话", "地址", "管理权限")
  13.         self.tree = ttk.Treeview(self.frame_center, show="headings", height=18, columns=self.columns)
  14.         self.vbar = ttk.Scrollbar(self.frame_center, orient=VERTICAL, command=self.tree.yview)
  15.         # 定义树形结构与滚动条
  16.         self.tree.configure(yscrollcommand=self.vbar.set)
  17.         # 表格的标题
  18.         self.tree.column("用户ID", width=100, anchor='center')  # 表示列,不显示
  19.         self.tree.column("姓名", width=100, anchor='center')
  20.         self.tree.column("密码", width=100, anchor='center')
  21.         self.tree.column("电话", width=100, anchor='center')
  22.         self.tree.column("地址", width=300, anchor='center')
  23.         self.tree.column("管理权限", width=100, anchor='center')
  24.         # 调用方法获取表格内容插入
  25.         self.tree.grid(row=1, column=0, sticky=NSEW)
  26.         self.vbar.grid(row=1, column=1, sticky=NS)
  27.  
  28.         self.u_id = []
  29.         self.u_name = []
  30.         self.u_password = []
  31.         self.user_phone = []
  32.         self.user_adress = []
  33.         self.u_Admin = []
  34.         # 打开数据库连接
  35.         try:
  36.             db = pymssql.connect(server="localhost",database="LibraryManage")
  37.             cursor = db.cursor()  # 使用cursor()方法获取操作游标
  38.             
  39.             sql = 'SELECT u_id, u_password, u_name, user_phone, user_adress, u_Admin FROM Users'
  40.             cursor.execute(sql)
  41.             results = cursor.fetchall()
  42.             for row in results:
  43.                 self.u_id.append(row[0])
  44.                 self.u_password.append(row[1].encode("l1").decode("GBK"))
  45.                 self.u_name.append(row[2].encode("l1").decode("GBK"))
  46.                 self.user_phone.append(row[3].encode("l1").decode("GBK"))
  47.                 self.user_adress.append(row[4])
  48.                 if row[5]:
  49.                     self.u_Admin.append('管理员')
  50.                 else:
  51.                     self.u_Admin.append('')
  52.             db.close()# 关闭数据库连接
  53.         except:
  54.             print("Error: unable to fetch data")
  55.             messagebox.showinfo('警告！', '数据库连接失败！')
  56.             
  57.         # 写入数据   
  58.         n = len(self.u_id)
  59.         for i in range(n): 
  60.             self.tree.insert('', i, values=(self.u_id[i], self.u_name[i], self.u_password[i], self.user_phone[i], \
  61.                                             self.user_adress[i], self.u_Admin[i]))
  62.  
  63.         for col in self.columns:  # 绑定函数，使表头可排序
  64.             self.tree.heading(col, text=col,\
  65.                               command=lambda _col=col: self.tree_sort_column(self.tree, _col, False))       
  66.         self.tree.bind('<Button-1>', self.click)
  67.         
  68.         
  69.         self.frame_center.grid(row=1, column=0, columnspan=2, padx=4, pady=5)
  70.         self.frame_center.grid_propagate(0)
  71.         self.frame_center.tkraise() # 开始显示主菜单
  72.         #————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
  73.         
  74.         #————————————————————————————————————————————————————————右侧还书区域—————————————————————————————————————————————————————————
  75.         self.frame_right_top = tk.Frame(width=600, height=100)
  76.         self.var_id = StringVar()  # 声明书号
  77.         self.var_name = StringVar()
  78.         
  79.         # 书编号
  80.         self.right_top_bid_label = Label(self.frame_right_top, text="用户ID：", font=('Verdana', 15))
  81.         self.right_top_bid_entry = Entry(self.frame_right_top, textvariable=self.var_id, font=('Verdana', 15))
  82.         self.right_top_bid_label.grid(row=0, column=0)  # 位置设置
  83.         self.right_top_bid_entry.grid(row=0, column=1)
  84.         
  85.         # 书名
  86.         self.right_top_bname_label = Label(self.frame_right_top, text="姓名：", font=('Verdana', 15))
  87.         self.right_top_bname_entry = Entry(self.frame_right_top, textvariable=self.var_name, font=('Verdana', 15))
  88.         self.right_top_bname_label.grid(row=1, column=0)  # 位置设置
  89.         self.right_top_bname_entry.grid(row=1, column=1)
  90.         
  91.         #还书操作
  92.         self.right_top_button = ttk.Button(self.frame_right_top, text='修改信息', width=20, command = self.update)
  93.         self.right_top_button.grid(row=1, column=4, padx=20, pady=10)
  94.         
  95.         self.frame_right_top.grid(row=0, padx=30, pady=30)
  96.         self.frame_right_top.grid_propagate(0)
  97.         self.frame_right_top.tkraise() # 开始显示主菜单
  98.         #——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
  99.                 
  100.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击    
  101.         self.window.mainloop()  # 进入消息循环
  102.         
  103.     def click(self, event):
  104.         self.col = self.tree.identify_column(event.x)  # 列
  105.         self.row = self.tree.identify_row(event.y)  # 行
  106.         self.row_info = self.tree.item(self.row, "values")
  107.         self.var_id.set(self.row_info[0])
  108.         self.var_name.set(self.row_info[1])
  109.         self.right_top_bid_entry = Entry(self.frame_right_top, textvariable=self.var_id, font=('Verdana', 15))
  110.         self.right_top_bname_entry = Entry(self.frame_right_top, textvariable=self.var_name, font=('Verdana', 15))
  111.         
  112.     def update(self):
  113.         self.update_window = tk.Tk()
  114.         self.update_window.title('修改')
  115.         self.update_window.geometry('600x150')
  116.         
  117.         Label(self.update_window, text='设置密码', font=tkFont.Font(size=14)).grid(row = 0, column = 0)
  118.         self.new_password = tk.Entry(self.update_window, width=30, font=tkFont.Font(size=14), bg='Ivory')
  119.         self.new_password.grid(row = 0, column = 1)
  120.         
  121.         Label(self.update_window, text='设置电话', font=tkFont.Font(size=14)).grid(row = 1, column = 0)
  122.         self.new_phone = tk.Entry(self.update_window, width=30, font=tkFont.Font(size=14), bg='Ivory')
  123.         self.new_phone.grid(row = 1, column = 1)
  124.         
  125.         Label(self.update_window, text='设置地址', font=tkFont.Font(size=14)).grid(row = 2, column = 0)
  126.         self.new_adress = tk.Entry(self.update_window, width=30, font=tkFont.Font(size=14), bg='Ivory')
  127.         self.new_adress.grid(row = 2, column = 1)
  128.         
  129.         Label(self.update_window, text='是否设为管理员（0或1）', font=tkFont.Font(size=14)).grid(row = 3, column = 0)
  130.         self.new_Admin = tk.Entry(self.update_window, width=30, font=tkFont.Font(size=14), bg='Ivory')
  131.         self.new_Admin.grid(row = 3, column = 1)
  132.         
  133.         Button(self.update_window, text="修改", width=40, font=tkFont.Font(size=15), \
  134.                command=self.comfirm).grid(row = 4, column = 0, columnspan = 2)
  135.         self.update_window.mainloop()
  136.         
  137.     def comfirm(self):
  138.         res = messagebox.askyesnocancel('确认修改', "确认修改 ？")
  139.         if res:
  140.             db = pymssql.connect(server="localhost",database="LibraryManage")
  141.             cursor = db.cursor()  # 使用cursor()方法获取操作游标
  142.             if self.new_password.get() != '':
  143.                 sql = "UPDATE Users SET u_password = '%s' WHERE u_id = '%s'" %(self.new_password.get(), self.var_id.get())
  144.                 cursor.execute(sql)  # 执行sql语句
  145.                 db.commit()  # 提交到数据库执行
  146.                 
  147.             if self.new_phone.get() != '':
  148.                 sql = "UPDATE Users SET user_phone = '%s' WHERE u_id = '%s'" %(self.new_phone.get(), self.var_id.get())
  149.                 cursor.execute(sql)  # 执行sql语句
  150.                 db.commit()  # 提交到数据库执行
  151.                 
  152.             if self.new_adress.get() != '':
  153.                 sql = "UPDATE Users SET user_adress = '%s' WHERE u_id = '%s'" %(self.new_adress.get(), self.var_id.get())
  154.                 cursor.execute(sql)  # 执行sql语句
  155.                 db.commit()  # 提交到数据库执行
  156.             
  157.             if self.new_Admin.get() != '':
  158.                 sql = "UPDATE Users SET u_Admin = '%s' WHERE u_id = '%s'" %(self.new_Admin.get(), self.var_id.get())
  159.                 cursor.execute(sql)  # 执行sql语句
  160.                 db.commit()  # 提交到数据库执行
  161.   
  162.             messagebox.showinfo('提示！', '修改成功！')
  163.             self.update_window.destroy()
  164.             Users(self.window)
  165.             
  166.     def back(self):
  167.         StartPage(self.window)

 查询记录

  1. class Records:
  2.     def __init__(self,parent_window):
  3.         parent_window.destroy()
  4.         self.window = Tk()  # 初始框的声明
  5.         self.window.title('借阅记录')
  6.         
  7.      #———————————————————————————————————————————————————————————中心列表区域———————————————————————————————————————————
  8.         self.frame_center = tk.Frame(width=900, height=400)
  9.         # 定义下方中心列表区域
  10.         self.center_title = Label(self.frame_center, text="借阅记录", font=('Verdana', 20))
  11.         self.center_title.grid(row = 0)  # 位置设置 
  12.         self.columns = ("记录ID", "用户ID", "姓名", "书ID", "书名", "借阅日期", "还书日期")
  13.         self.tree = ttk.Treeview(self.frame_center, show="headings", height=18, columns=self.columns)
  14.         self.vbar = ttk.Scrollbar(self.frame_center, orient=VERTICAL, command=self.tree.yview)
  15.         # 定义树形结构与滚动条
  16.         self.tree.configure(yscrollcommand=self.vbar.set)
  17.         # 表格的标题
  18.         self.tree.column("记录ID", width=100, anchor='center')
  19.         self.tree.column("用户ID", width=100, anchor='center')  # 表示列,不显示
  20.         self.tree.column("姓名", width=100, anchor='center')
  21.         self.tree.column("书ID", width=100, anchor='center')
  22.         self.tree.column("书名", width=100, anchor='center')
  23.         self.tree.column("借阅日期", width=200, anchor='center')
  24.         self.tree.column("还书日期", width=200, anchor='center')
  25.         # 调用方法获取表格内容插入
  26.         self.tree.grid(row=1, column=0, sticky=NSEW)
  27.         self.vbar.grid(row=1, column=1, sticky=NS)
  28.  
  29.         self.u_id = []
  30.         self.u_name = []
  31.         self.book_id = []
  32.         self.book_name = []
  33.         self.Record_id = []
  34.         self.lend_time = []
  35.         self.return_time = []
  36.         # 打开数据库连接
  37.         try:
  38.             db = pymssql.connect(server="localhost",database="LibraryManage")
  39.             cursor = db.cursor()  # 使用cursor()方法获取操作游标
  40.             
  41.             sql = """
  42.                 SELECT Record_id, Users.u_id, u_name, Books.book_id, book_name, lend_time, return_time
  43.                 FROM Records,Users,Books
  44.                 WHERE Records.u_id = Users.u_id AND
  45.                 Books.book_id = Records.book_id
  46.                 """
  47.             cursor.execute(sql)
  48.             results = cursor.fetchall()
  49.             for row in results:
  50.                 self.Record_id.append(row[0])
  51.                 self.u_id.append(row[1])
  52.                 self.u_name.append(row[2].encode("l1").decode("GBK"))
  53.                 self.book_id.append(row[3])
  54.                 self.book_name.append(row[4].encode("l1").decode("GBK"))
  55.                 self.lend_time.append(row[5])
  56.                 self.return_time.append(row[6])
  57.             db.close()# 关闭数据库连接
  58.         except:
  59.             print("Error: unable to fetch data")
  60.             messagebox.showinfo('警告！', '数据库连接失败！')
  61.             
  62.         # 写入数据   
  63.         n = len(self.u_id)
  64.         for i in range(n): 
  65.             self.tree.insert('', i, values=(self.Record_id[i], self.u_id[i], self.u_name[i], self.book_id[i], \
  66.                                             self.book_name[i], self.lend_time[i],self.return_time[i]))
  67.  
  68.         for col in self.columns:  # 绑定函数，使表头可排序
  69.             self.tree.heading(col, text=col,\
  70.                               command=lambda _col=col: self.tree_sort_column(self.tree, _col, False))       
  71.         
  72.         
  73.         self.frame_center.grid(row=1, column=0, columnspan=2, padx=4, pady=5)
  74.         self.frame_center.grid_propagate(0)
  75.         self.frame_center.tkraise() # 开始显示主菜单
  76.         self.window.protocol("WM_DELETE_WINDOW", self.back)  # 捕捉右上角关闭点击
  77.         self.window.mainloop()  # 进入消息循环
  78.         
  79.     def back(self):
  80.         StartPage(self.window) # 显示主窗口 销毁本窗口
  81.  
  82. if __name__ == '__main__':
  83.     window = tk.Tk()
  84.     StartPage(window)

 总体就是这样，将以上所有的python代码全放到一起就可以运行，想要运行首先要构建数据库，并打开，还要安装包，需要全部内容的例如PPT，可以加我QQ1486426078

补充：直接去网盘下载吧，过了两年了我已经忘完了，安装运行什么的自己研究吧，嘿嘿。链接: https://pan.baidu.com/s/1k-heOKsYFUg2H0CeNIsVPQ?pwd=1234 提取码: 1234 复制这段内容后打开百度网盘手机App，操作更方便哦

本文内容由网友自发贡献，转载请注明出处：https://www.wpsshop.cn/w/黑客灵魂/article/detail/859514
推荐阅读
相关标签

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

  

闽ICP备14008679号