✅作者简介：大家好我是hacker707,大家可以叫我hacker，新星计划第三季python赛道Top1
个人主页：hacker707的csdn博客
系列专栏：python
推荐一款模拟面试、刷题神器点击跳转进入网站
学生成绩管理系统
- 学生成绩管理系统简介
- 源代码
- students.txt
- main.py
- Login.py
- db.py
- MenuPage.py
- view.py
- 结束语
学生成绩管理系统简介
一个带有登录界面具有增减改查功能的学生成绩管理系统(面向对象思想，利用tkinter库进行制作，利用.txt文件进行存储数据)
源代码
✅仅供学习参考，最好还是自己多敲多练习(实践是检验真理的唯一标准)
students.txt
用于存储数据
main.py
from tkinter import *from Login import *import tkinter as tkroot = tk.Tk()root.title('欢迎进入学生成绩管理系统')LoginPage(root)root.mainloop()Login.py
from tkinter import *from tkinter.messagebox import *from MenuPage import *class LoginPage(object):def __init__(self, master=None):self.root = master# 定义内部变量rootself.root.geometry('%dx%d' % (300, 180))# 设置窗口大小self.username = StringVar()self.password = StringVar()self.createPage()def createPage(self):self.page = Frame(self.root)# 创建Frameself.page.pack()Label(self.page).grid(row=0, stick=W)Label(self.page, text='账户: ').grid(row=1, stick=W, pady=10)Entry(self.page, textvariable=self.username).grid(row=1, column=1, stick=E)Label(self.page, text='密码: ').grid(row=2, stick=W, pady=10)Entry(self.page, textvariable=self.password, show='*').grid(row=2, column=1, stick=E)Button(self.page, text='登陆', command=self.loginCheck).grid(row=3, stick=W, pady=10)Button(self.page, text='退出', command=self.page.quit).grid(row=3, column=1, stick=E)def loginCheck(self):name = self.username.get()password = self.password.get()if name == 'hacker707' and password == 'admin':self.page.destroy()MenuPage(self.root)else:showinfo(title='错误', message='账号或密码错误！')db.py
import jsonclass StudentDB(object):def __init__(self):self.students = []self._load_students_data()def insert(self, student):self.students.append(student)print(self.students)def all(self):return self.studentsdef delete_by_name(self, name):# 删除数据for student in self.students:if name == student["name"]:self.students.remove(student)breakelse:return Falsereturn True# 查询def search_by_name(self, name):for student in self.students:if name == student["name"]:return student# 姓名+成绩else:return False# 修改def update(self, stu):# 修改数据name = stu["name"]for student in self.students:if name == student["name"]:student.update(stu)return Trueelse:return False# 加载文件def _load_students_data(self):with open("students.txt", "r", encoding="utf-8") as f:text = f.read()if text:self.students = json.loads(text)# 保存数据def save_data(self):with open("students.txt", 'w', encoding="utf-8") as f:text = json.dumps(self.students, ensure_ascii=False)f.write(text)db = StudentDB()MenuPage.py
import tkinter as tkfrom view import *class MenuPage(object):def __init__(self, master=None):self.root = masterself.root.geometry('%dx%d' % (600, 400))self.create_page()self.input_page = InputFrame(self.root)self.query_page = QuerryFrame(self.root)self.delete_page = DeleteFrame(self.root)self.update_page = UpdateFrame(self.root)self.about_page = AboutFrame(self.root)self.input_page.pack()def create_page(self):# 创建菜单对象menubar = tk.Menu(self.root)# add_command 添加menubar.add_command(label="录入", command=self.input_data)# labelmenubar.add_command(label="查询", command=self.query_data)# labelmenubar.add_command(label="删除", command=self.delete_data)# labelmenubar.add_command(label="修改", command=self.update_data)# labelmenubar.add_command(label="关于", command=self.about_data)# label# 设置菜单栏self.root.config(menu=menubar)# 切换界面def input_data(self):self.input_page.pack()self.update_page.pack_forget()self.delete_page.pack_forget()self.about_page.pack_forget()self.query_page.pack_forget()def query_data(self):self.input_page.pack_forget()self.query_page.pack()self.update_page.pack_forget()self.delete_page.pack_forget()self.about_page.pack_forget()def update_data(self):self.input_page.pack_forget()self.update_page.pack()self.delete_page.pack_forget()self.about_page.pack_forget()self.query_page.pack_forget()def delete_data(self):self.input_page.pack_forget()self.update_page.pack_forget()self.delete_page.pack()self.about_page.pack_forget()self.query_page.pack_forget()def about_data(self):self.input_page.pack_forget()self.update_page.pack_forget()self.delete_page.pack_forget()self.about_page.pack()self.query_page.pack_forget()view.py
import tkinter as tkfrom db import dbfrom tkinter import ttk# 录入类class InputFrame(tk.Frame):def __init__(self, master=None):super().__init__(master)self.root = masterself.name = tk.StringVar()self.math = tk.StringVar()self.chinese = tk.StringVar()self.english = tk.StringVar()self.status = tk.StringVar()self.create_page()def create_page(self):tk.Label(self).grid(row=0, stick=tk.W, pady=10)tk.Label(self, text="姓名:").grid(row=1, stick=tk.W, pady=10)# 单行文本框 entry，textvariable绑定变量tk.Entry(self, textvariable=self.name).grid(row=1, column=1, stick=tk.E)tk.Label(self, text="数学:").grid(row=2, stick=tk.W, pady=10)# 单行文本框 entry，textvariable绑定变量tk.Entry(self, textvariable=self.math).grid(row=2, column=1, stick=tk.E)tk.Label(self, text="语文:").grid(row=3, stick=tk.W, pady=10)# 单行文本框 entry，textvariable绑定变量tk.Entry(self, textvariable=self.chinese).grid(row=3, column=1, stick=tk.E)tk.Label(self, text="英语:").grid(row=4, stick=tk.W, pady=10)# 单行文本框 entry，textvariable绑定变量tk.Entry(self, textvariable=self.english).grid(row=4, column=1, stick=tk.E)tk.Button(self, text="录入", command=self.recode_student).grid(row=5, column=1, stick=tk.E, pady=10)tk.Label(self, textvariable=self.status).grid(row=6, column=1, stick=tk.E, pady=10)# 录入成绩def recode_student(self):student = {"name": self.name.get(),"math": self.math.get(),"chinese": self.chinese.get(),"english": self.english.get(),}# 一个学生的成绩db.insert(student)# get()得到值# set()设置值self.status.set("插入数据成功！")self._clear_data()db.save_data()# 清空文本数据def _clear_data(self):self.name.set("")self.math.set("")self.chinese.set("")self.english.set("")# 查询类class QuerryFrame(tk.Frame):def __init__(self, master=None):super().__init__(master)self.root = masterself.create_page()# 创建查询界面def create_page(self):self.create_tree_view()self.show_data_frame()# grid()tk.Button(self, text="刷新数据", command=self.show_data_frame).pack(anchor=tk.E, pady=5)# Treeviewdef create_tree_view(self):# 表头columns = ("name", "chinese", "math", "english")self.tree_view = ttk.Treeview(self, show='headings', columns=columns)self.tree_view.column("name", width=80, anchor='center')self.tree_view.column("chinese", width=80, anchor='center')self.tree_view.column("math", width=80, anchor='center')self.tree_view.column("english", width=80, anchor='center')self.tree_view.heading("name", text='姓名')self.tree_view.heading("chinese", text='语文')self.tree_view.heading("math", text='数学')self.tree_view.heading("english", text='英语')self.tree_view.pack()# 显示数据def show_data_frame(self):# 删除原节点 map(int,值）for i in map(self.tree_view.delete, self.tree_view.get_children("")):pass# 拿到列表里面所有值、students[]students = db.all()# 同时拿到索引跟value值for index, stu in enumerate(students):self.tree_view.insert('', index, values=(stu["name"], stu["chinese"], stu["math"], stu["english"]))class DeleteFrame(tk.Frame):def __init__(self, master=None):super().__init__(master)tk.Label(self, text='删除数据').pack()self.status = tk.StringVar()self.de_name = tk.StringVar()# 获取删除学生的姓名self.create_page()# 创建界面def create_page(self):tk.Label(self, text="根据姓名删除信息").pack(anchor=tk.W, padx=20)e1 = tk.Entry(self, textvariable=self.de_name)e1.pack(side=tk.LEFT, padx=20, pady=5)tk.Button(self, text='删除', command=self._delete).pack(side=tk.RIGHT)tk.Label(self, textvariable=self.status).pack()# 删除def _delete(self):name = self.de_name.get()print(name)result = db.delete_by_name(name)if result:self.status.set(f'{name}已经被删')self.de_name.set("")else:self.status.set(f'{name}不存在')class UpdateFrame(tk.Frame):def __init__(self, master=None):super().__init__(master)self.root = mastertk.Label(self, text='修改界面').pack()self.change_frame = tk.Frame(self)self.change_frame.pack()self.name = tk.StringVar()self.math = tk.StringVar()self.chinese = tk.StringVar()self.english = tk.StringVar()self.status = tk.StringVar()self.create_page()def create_page(self):tk.Label(self.change_frame).grid(row=0, stick=tk.W, pady=10)tk.Label(self.change_frame, text="姓名:").grid(row=1, stick=tk.W, pady=10)# 单行文本框 entry，textvariable绑定变量tk.Entry(self.change_frame, textvariable=self.name).grid(row=1, column=1, stick=tk.E)tk.Label(self.change_frame, text="数学:").grid(row=2, stick=tk.W, pady=10)# 单行文本框 entry，textvariable绑定变量tk.Entry(self.change_frame, textvariable=self.math).grid(row=2, column=1, stick=tk.E)tk.Label(self.change_frame, text="语文:").grid(row=3, stick=tk.W, pady=10)# 单行文本框 entry，textvariable绑定变量tk.Entry(self.change_frame, textvariable=self.chinese).grid(row=3, column=1, stick=tk.E)tk.Label(self.change_frame, text="英语:").grid(row=4, stick=tk.W, pady=10)# 单行文本框 entry，textvariable绑定变量tk.Entry(self.change_frame, textvariable=self.english).grid(row=4, column=1, stick=tk.E)# 按钮tk.Button(self.change_frame, text='查询', command=self._search).grid(row=6, column=0, stick=tk.W, pady=10)tk.Button(self.change_frame, text='修改', command=self._change).grid(row=6, column=1, stick=tk.E, pady=10)tk.Label(self.change_frame, textvariable=self.status).grid(row=7, column=1, stick=tk.E, pady=10)# 查询def _search(self):name = self.name.get()student = db.search_by_name(name)if student:self.math.set(student["math"])self.chinese.set(student["chinese"])self.english.set(student["english"])self.status.set(f'查询到{name}同学的信息')else:self.status.set(f'没有查询到{name}同学的信息')#更改成绩def _change(self):name = self.name.get()math = self.math.get()chinese = self.chinese.get()english = self.english.get()stu = {"name": name,"math": math,"chinese": chinese,"english": english,}r = db.update(stu)if r:self.status.set(f"{name}同学的信息更新完毕")else:self.status.set(f"{name}同学的信息更新失败")class AboutFrame(tk.Frame):def __init__(self, master=None):super().__init__(master)self.root = masterself.create_page()def create_page(self):tk.Label(self, text="关于本作品(人生苦短，我用python)").pack(anchor=tk.W)结束语
推荐一款模拟面试、刷题神器网站
点击链接注册即可
1、算法篇（398题）：面试必刷100题、算法入门、面试高频榜单
2、SQL篇（82题）：快速入门、SQL必知必会、SQL进阶挑战、面试真题
3、大厂笔试真题：字节跳动、美团、百度、腾讯…
