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(
