课程大作业-基于tkinter的学生成绩管理系统python源码.zip

import tkinter as tk from tkinter import ttk from custom_widget import spacex, spacey, message_box, multipleList import pymysql import json try: config_file = open('config.json') except: print('未找到数据库配置文件，请先运行config.py') print('python config.py') exit() config = json.load(config_file) config_file.close() db = pymysql.connect( host=config['host'], user=config['user'], password=config['password'], database=config['database']) cursor = db.cursor() pwd_admin = '123' #管理员密码 def isnum(s): l = s.split('.') if len(l) > 2: return 0 elif len(l) == 1: if l[0].isdigit(): return 1 else: return 0 elif len(l) == 2: if l[0].isdigit() and l[1].isdigit(): return 2 else: return 0 def sql(s): global cursor cursor.execute(s) try: data = cursor.fetchall() result = [] for item in data: result.append(list(item)) for i in range(len(result)): for j in range(len(result[i])): if isinstance(result[i][j], str): result[i][j] = result[i][j].rstrip() return result except Exception: return class help_page: def __init__(self): self.root = tk.Tk() self.root.title('帮助') sw = self.root.winfo_screenwidth()//2 sh = self.root.winfo_screenheight()//2 self.root.geometry('250x150+{}+{}'.format(sw-200, sh-200)) self.frame = tk.Frame(self.root) self.frame.pack() spacey(self.frame, 10) name_label = tk.Label( self.frame, text='学生成绩管理系统') name_label.pack() spacey(self.frame, 10) class_label = tk.Label( self.frame, text='作者') class_label.pack() spacey(self.frame, 10) author_label = tk.Label( self.frame, text='L-ING') author_label.pack() spacey(self.frame, 10) exit = tk.Button( self.frame, text='退出', command=self.exit) exit.pack() def exit(self): self.root.destroy() class query_page: def __init__(self, master): # 需要重定义self.get_sql(),self.get_area(),self.root.title(),self.exit() self.area = self.get_area() self.sql = self.get_sql() self.data = self.get_data() self.root = master self.root.geometry('500x400') self.frame = tk.Frame(self.root) self.frame.pack() spacey(self.frame, 10) top_sub_frame = tk.Frame(self.frame) top_sub_frame.pack(fill='x') help = tk.Button( top_sub_frame, text='帮助', command=self.help) help.pack(side='left') spacex(top_sub_frame, 10, side='left') exit = tk.Button( top_sub_frame, text='退出', command=self.exit) exit.pack(side='left') tk.Frame(top_sub_frame).pack(side='left', fill='x') spacey(self.frame, 10) id_sub_frame = tk.Frame(self.frame) id_sub_frame.pack() id_label = tk.Label( id_sub_frame, text='学号') id_label.pack(side='left') spacex(id_sub_frame, 5, side='left') self.search_entry = tk.Entry(id_sub_frame) self.search_entry.pack(side='left') spacex(id_sub_frame, 5, side='left') search = tk.Button( id_sub_frame, text='查询', command=self.search) search.pack(side='left') spacex(id_sub_frame, 5, side='left') reset = tk.Button( id_sub_frame, text='复位', command=self.load) reset.pack(side='left') spacey(self.frame, 10) self.details_list = self.get_list() self.details_list.pack() self.load() def get_list(self): _list = multipleList( self.frame, area=self.area, command=self.search_double_click, height=15) return _list def get_area(self): return 0 def get_sql(self): return 0 def clear(self): for item in self.details_list.get_children(): self.details_list.delete(item) def get_data(self): return sql(self.sql) def load(self): self.clear() for item in self.data: self.details_list.insert('', 'end', values=item) def search(self): _id = self.search_entry.get() self.load() if isnum(_id) == 1: result = sql(self.sql+' where sno=%s' % _id) if _id not in [item[0] for item in result]: message_box('学号不存在，请重新输入！') else: self.clear() for item in result: self.details_list.insert('', 'end', values=item) elif _id == '': message_box('学号不能为空!') else: message_box('请输入数字！') def search_double_click(self, event): _id = self.details_list.item(self.details_list.focus(), 'values')[0] self.search_entry.delete(0, 'end') self.search_entry.insert(0, _id) self.search() def help(self): help_page() def exit(self): return 0 class course_details_student_page(query_page): def __init__(self, master): super(course_details_student_page, self).__init__(master) self.root.title('开课情况查询') def get_area(self): return ('学号', '课程号', '课程名', '学分') def get_sql(self): return 'select * from xskkqk' def exit(self): self.frame.destroy() student_menu_page(self.root) class each_grade_query_student_page(query_page): def __init__(self, master): super(each_grade_query_student_page, self).__init__(master) self.root.geometry('550x400') self.root.title('单科成绩查询') def get_area(self): return ('学号', '姓名', '班级', '科目', '成绩') def get_sql(self): return 'select * from xsdkcj' def exit(self): self.frame.destroy() grade_query_mode_student_page(self.root) class sum_grade_query_student_page(query_page): def __init__(self, master): super(sum_grade_query_student_page, self).__init__(master) self.root.title('总成绩查询') def get_area(self): return ('学号', '姓名', '班级', '总成绩') def get_sql(self): return 'select * from xszcj' def search_double_click(self, event): _id = self.details_list.item(self.details_list.focus(), 'values')[0] self.search_entry.delete(0, 'end') self.search_entry.insert(0, _id) def exit(self): self.frame.destroy() grade_query_mode_student_page(self.root) class grade_query_mode_student_page: def __init__(self, master): self.root = master self.root.title('学生成绩查询模式') self.root.geometry('200x110') self.frame = tk.Frame(self.root) self.frame.pack() spacey(self.frame, 10) top_sub_frame = tk.Frame(self.frame) top_sub_frame.pack() help = tk.Button( top_sub_frame, text='帮助', command=self.help) help.pack(side='left') spacex(top_sub_frame, 10, side='left') exit = tk.Button( top_sub_frame, text='退出', command=self.exit) exit.pack(side='left') spacey(self.frame, 10) each_grade = tk.Button( self.frame, text='单科成绩', command=self.each_grade) each_grade.pack() spacey(self.frame, 10) sum_grade = tk.Button(