基于Python的学生成绩管理系统_python学生成绩管理系统

2301_76190672

于 2024-05-01 16:01:03 发布

阅读量759

点赞数 13

分类专栏：程序员文章标签： python microsoft 开发语言

本文链接：https://blog.csdn.net/2301_76190672/article/details/138374459

版权

程序员专栏收录该内容

142 篇文章 0 订阅

订阅专栏

This is a sample Python script.

Press Shift+F10 to execute it or replace it with your code.

Press Double Shift to search everywhere for classes, files, tool windows, actions, and settings.

from tkinter import Tk

from models import check_db
from pages import LoginPage

if name == ‘main’:
check_db()
root = Tk()
root.title(‘学生成绩管理系统’)
LoginPage(root)
root.mainloop()


页面函数 pages.py内容

#!/usr/bin/env python

-- coding:utf-8 --

project : scorems

filename : pages

author : ly_13

date : 2022/10/13

import string
from tkinter import StringVar, Label, Entry, font, W, E, Button, messagebox, Menu
from tkinter.ttk import Frame

from models import session, User
from views import AddFrame, DeleteFrame, EditFrame, SearchFrame, CountFrame, ScoreFrame

class LoginPage(object):
def init(self, master=None):
self.page = None
self.root = master
self.root.geometry(‘%dx%d’ % (480, 320))
self.username = StringVar(value=‘’)
self.password = StringVar(value=‘’)
self.init_page()

def init_page(self):
    self.page = Frame(self.root)  # 创建Frame
    self.page.pack()
    Label(self.page, text="学生成绩管理系统", font=("宋体", 20)).grid(row=0, pady=40, stick=W)
    Label(self.page, text='账户:', font=font.Font(size=12)).grid(row=1, stick=W, pady=10)
    Entry(self.page, textvariable=self.username).grid(row=1, stick=E)
    Label(self.page, text='密码:', font=font.Font(size=12)).grid(row=2, stick=W, pady=10)
    Entry(self.page, textvariable=self.password, show='*').grid(row=2, stick=E)
    Button(self.page, text='登录', command=self.login, font=font.Font(size=12)).grid(row=3, stick=W, pady=30)
    Button(self.page, text='注册', command=self.register, font=font.Font(size=12)).grid(row=3, stick=E, pady=30)

def check_info(self):
    username = self.username.get().strip()
    password = self.password.get().strip()
    if len(username) == 0 or len(password) == 0:
        messagebox.showinfo(title='错误', message='账号密码不能为空')
        return
    if set(username) - set(string.digits + string.ascii_lowercase):
        messagebox.showinfo(title='错误', message=f'账号只能为 {string.digits + string.ascii_lowercase}')
        return
    if set(password) - set(string.digits + string.ascii_letters):
        messagebox.showinfo(title='错误', message=f'密码只能为 {string.digits + string.ascii_letters}')
        return

    return username, password

def login(self):
    username, password = self.check_info()
    res = session.query(User).filter(User.username == username, User.password == password).first()
    if res:
        self.page.destroy()
        MainPage(self.root)
    else:
        messagebox.showinfo(title='错误', message='账号或密码错误！')

def register(self):
    username, password = self.check_info()
    res = session.query(User).filter(User.username == username).first()
    if res:
        messagebox.showinfo(title='结果', message="已存在该用户信息！")
        return

    session.add(User(username=username, password=password))
    session.commit()
    messagebox.showinfo(title='提示', message=f"用户 {username} 注册成功")

class MainPage(object):
def init(self, master=None):
self.root = master
self.add_page = AddFrame(self.root)
self.del_page = DeleteFrame(self.root)
self.edit_page = EditFrame(self.root)
self.search_page = SearchFrame(self.root)
self.count_page = CountFrame(self.root)
self.score_page = ScoreFrame(self.root)
self.root.geometry(‘%dx%d’ % (600, 400))
self.init_page()

def init_page(self):
    self.add_page.pack()  # 默认显示数据录入界面
    menubar = Menu(self.root)
    menubar.add_command(label='添加', command=self.change_page())
    menubar.add_command(label='删除', command=self.change_page('del_page'))
    menubar.add_command(label='修改', command=self.change_page('edit_page'))
    menubar.add_command(label='查找', command=self.change_page('search_page'))
    menubar.add_command(label='成绩排行', command=self.change_page('score_page'))
    menubar.add_command(label='班级统计', command=self.change_page('count_page'))
    self.root['menu'] = menubar  # 设置菜单栏

def change_page(self, active='add_page'):
    def change():
        getattr(self, active).pack()
        pages = ['add_page', 'del_page', 'edit_page', 'search_page', 'count_page', 'score_page']
        for page in set(pages) - {active}:
            getattr(self, page).pack_forget()

    return change


视图函数 views.py内容

#!/usr/bin/env python

-- coding:utf-8 --

project : scorems

filename : views

author : ly_13

date : 2022/10/13

import datetime
from tkinter import StringVar, Label, Entry, font, W, E, Button, messagebox, IntVar, ttk, Scrollbar
from tkinter.ttk import Frame

import matplotlib.pyplot as plt
import xlwt

from models import session, Score

columns = {
‘index’: ‘排名’,
‘username’: ‘学号’,
‘nickname’: ‘姓名’,
‘chinese’: ‘语文’,
‘math’: ‘数学’,
‘english’: ‘英语’,
‘politics’: ‘政治’,
‘score’: ‘总分’
}

class AddFrame(Frame):
def init(self, master=None):
super().init(master)
self.root = master
self.username = StringVar()
self.nickname = StringVar()
self.chinese = IntVar()
self.math = IntVar()
self.english = IntVar()
self.politics = IntVar()
self.show()

def check(self):
    data = {
        'username': self.username.get().strip(),
        'nickname': self.nickname.get().strip(),
    }
    try:
        data['chinese'] = self.chinese.get()
        data['math'] = self.math.get()
        data['english'] = self.english.get()
        data['politics'] = self.politics.get()
        data['score'] = sum([data['chinese'], data['math'], data['english'], data['politics']])
    except Exception as e:
        print(e)
        messagebox.showinfo(title='结果', message="输入有误，请检查")
        return {}
    if data['username'] and data['nickname']:
        return data
    return {}

def click(self):
    data = self.check()
    if data:
        res = session.query(Score).filter(Score.username == data.get('username')).first()
        if res:
            messagebox.showinfo(title='结果', message="已存在该学生科目信息！")
            return
        session.add(Score(**data))
        session.commit()
        messagebox.showinfo(title='结果', message="成绩信息添加成功！")
    else:
        messagebox.showinfo(title='提示', message="输入有误，请检查")

def username_input(self):
    Label(self, text='学号: ').grid(row=1, stick=W, pady=10)
    Entry(self, textvariable=self.username).grid(row=1, column=1, stick=E)

def show(self):
    Label(self).grid(row=0, stick=W, pady=10)

    self.username_input()

    index = 2
    for key, label in columns.items():
        if key in ['index', 'username', 'score']: continue
        Label(self, text=f'{label}: ').grid(row=index, stick=W, pady=10)
        Entry(self, textvariable=getattr(self, key)).grid(row=index, column=1, stick=E)
        index += 1

    Button(self, text='录入', command=self.click).grid(row=7, column=1, stick=E, pady=10)

class EditFrame(AddFrame):
def init(self, master=None):
super().init(master)

def click(self):
    data = self.check()
    if data:
        res = session.query(Score).filter(Score.username == data['username'])
        if res and res.first():
            del data['username']
            res.update(data)
            session.commit()
            messagebox.showinfo(title='结果', message="成绩信息修改成功！")
        else:
            messagebox.showinfo(title='结果', message="查询信息不存在！")
            return
    else:
        messagebox.showinfo(title='提示', message="输入有误，请检查")

def username_input(self):
    Label(self, text='学号: ').grid(row=1, stick=W, pady=10)
    Entry(self, textvariable=self.username).grid(row=1, column=1, stick=E)
    Button(self, text='查询', font=font.Font(size=12), command=self.search).grid(row=1, stick=E, column=2, pady=10)

def search(self):
    username = self.username.get().strip()
    if username:
        res = session.query(Score).filter(Score.username == username).first()
        if res:
            for key in columns.keys():
                if key in ['index', 'score', 'math']:
                    continue
                print(key, getattr(res, key))
                getattr(self, key).set(getattr(res, key))
        else:
            messagebox.showinfo(title='提示', message="查询信息不存在")
    else:
        messagebox.showinfo(title='提示', message="输入项为空")

class DeleteFrame(Frame):
def init(self, master=None):
Frame.init(self, master)
self.root = master
self.username = StringVar()
self.nickname = StringVar()
self.show()

def do_action(self, res):
    res.delete()
    session.commit()
    messagebox.showinfo(title='提示', message="删除成功")

def click(self):
    username = self.username.get().strip()
    nickname = self.nickname.get().strip()
    if username or nickname:
        res = session.query(Score)
        if username:
            res = res.filter(Score.username == username)
        if nickname:
            res = res.filter(Score.nickname == nickname)
        if res and res.first():
            self.do_action(res)
            return
        else:
            messagebox.showinfo(title='提示', message="查询信息不存在")
    else:
        messagebox.showinfo(title='提示', message="输入项为空")

def show_button(self):
    Button(self, text='删除', command=self.click).grid(row=6, column=1, stick=E, pady=10)

def show(self):
    Label(self).grid(row=0, stick=W, pady=10)

    Label(self, text='学号: ').grid(row=1, stick=W, pady=10)
    Entry(self, textvariable=self.username).grid(row=1, column=1, stick=E)

    Label(self, text='姓名: ').grid(row=2, stick=W, pady=10)
    Entry(self, textvariable=self.nickname).grid(row=2, column=1, stick=E)
    self.show_button()

class SearchFrame(DeleteFrame):
def init(self, master=None):
super().init(master)

def do_action(self, res):
    message = ''
    for key, value in columns.items():
        if key == 'index':
            continue
        message += f'{value}:{getattr(res.first(), key, "")}\n'
    messagebox.showinfo(title='结果',
                        message=message)

def show_button(self):
    Button(self, text='查找', command=self.click).grid(row=6, column=1, stick=E, pady=10)

class ScoreFrame(Frame):

def __init__(self, master=None):
    super().__init__(master)
    self.ysb = None
    self.tree = None
    Label(self, text="成绩排行榜", font=("宋体", 20)).pack(pady=10)
    Button(self, text='导出成绩', command=write_easy_excel).pack(pady=10)

def pack_forget(self) -> None:
    super().pack_forget()
    if self.tree:
        self.tree.destroy()
    if self.ysb:
        self.ysb.destroy()

def pack(self, *args, **kwargs):
    super().pack(*args, **kwargs)
    self.tree = ttk.Treeview(self, show='headings', columns=list(columns.keys()))
    xsb = Scrollbar(self, orient="horizontal", command=self.tree.xview())  # x滚动条
    self.ysb = Scrollbar(self, orient="vertical", command=self.tree.yview())  # y滚动条
    self.tree.configure(yscrollcommand=self.ysb.set, xscrollcommand=xsb.set)  # y滚动条关联
    self.ysb.pack(side="right", fill="y")
    result = session.query(Score).order_by(Score.score.desc()).all()
    for column, label in columns.items():
        width = 40
        if column in ['username', 'nickname']:
            width = 80
        self.tree.column(column, width=width)
        self.tree.heading(column, text=label)
    index = 1
    for res in result:
        res.index = index
        self.tree.insert("", index, values=[getattr(res, x) for x in columns.keys()])
        index += 1
    self.tree.pack(pady=30)

class CountFrame(Frame):
def init(self, master=None):
Frame.init(self, master)
self.root = master
self.result = session.query(Score).all()
self.show()

def pack(self):
    super().pack()
    self.result = session.query(Score).all()

def show(self):
    Label(self, text="查看表格", font=("宋体", 20)).grid(row=0, pady=40, stick=W)

在这里插入图片描述