You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
214 lines
9.1 KiB
214 lines
9.1 KiB
5 months ago
|
from tkinter import Frame
|
||
|
|
import tkinter.font as tkFont
|
||
|
|
|
||
|
|
from ttkbootstrap import *
|
||
|
|
import ttkbootstrap as ttk
|
||
|
|
from ttkbootstrap.constants import *
|
||
|
|
|
||
|
|
import pandas as pd
|
||
|
|
import pymysql
|
||
|
|
from ttkbootstrap.tableview import Tableview
|
||
|
|
|
||
|
|
from BaseWindow import BaseWindow
|
||
|
|
|
||
|
|
|
||
|
|
def get_text_content(text):
|
||
|
|
return text.get("0.0", "end").replace("\n", " ")
|
||
|
|
|
||
|
|
conn = pymysql.connect(user="root", password="Wyz010810", database="SCT", host="127.0.0.1", port=3306)
|
||
|
|
|
||
|
|
class LoadElement(Frame):
|
||
|
|
def __init__(self, master, table_name):
|
||
|
|
super().__init__(master)
|
||
|
|
self.master = master
|
||
|
|
self.table_name = table_name
|
||
|
|
self.TableList = pd.read_sql(f"select * from {self.table_name} limit 0", conn)
|
||
|
|
self.font_style = tkFont.Font(family="Lucida Grande", size=20)
|
||
|
|
self.button_font = tkFont.Font(family="Lucida Grande", size=10)
|
||
|
|
self.create_widget()
|
||
|
|
self.create_tree_widget()
|
||
|
|
|
||
|
|
def create_widget(self):
|
||
|
|
# 创建装载按钮
|
||
|
|
label = Label(self, width=10, font=self.font_style, text=self.table_name, style="inverse-secondary")
|
||
|
|
label.grid(column=0, row=0)
|
||
|
|
Button(self, text="装载", width=10, command=self.load).grid(column=1, row=0, padx=5, sticky=NSEW)
|
||
|
|
|
||
|
|
def create_tree_widget(self):
|
||
|
|
frame = Frame(self, width=50, height=220)
|
||
|
|
frame.grid(row=1, column=0, columnspan=2, sticky=NSEW, pady=5)
|
||
|
|
frame.grid_columnconfigure(0, weight=1)
|
||
|
|
frame.grid_rowconfigure(0, weight=1)
|
||
|
|
columns = self.TableList.keys().tolist()
|
||
|
|
style = ttk.Style()
|
||
|
|
style.configure("Custom.Treeview.Heading", font=("宋体", 15))
|
||
|
|
style.configure("Custom.Treeview", rowheight=30, font=("宋体", 15))
|
||
|
|
tree = ttk.Treeview(frame, columns=columns, show="headings", style="Custom.Treeview", selectmode=BROWSE)
|
||
|
|
# 根据dataFrame结构生成表
|
||
|
|
for i in columns:
|
||
|
|
tree.heading(column=i, text=i)
|
||
|
|
for i in columns:
|
||
|
|
tree.column(i, anchor=CENTER, width=80)
|
||
|
|
if columns.index(i) == 1 or columns.index(i) == 0:
|
||
|
|
tree.column(i, anchor=CENTER, width=120)
|
||
|
|
for row in self.TableList.itertuples():
|
||
|
|
tree.insert(parent="", index=END, values=[row[i] for i in range(1, len(row))])
|
||
|
|
y_scrollbar = ttk.Scrollbar(self, orient='vertical', command=tree.yview)
|
||
|
|
x_scrollbar = ttk.Scrollbar(frame, orient="horizontal", command=tree.xview)
|
||
|
|
tree.configure(yscrollcommand=y_scrollbar.set)
|
||
|
|
tree.config(height=6)
|
||
|
|
tree.grid(row=0, column=0, columnspan=2, sticky=NSEW, pady=5)
|
||
|
|
y_scrollbar.grid(row=1, column=3, sticky='ns')
|
||
|
|
x_scrollbar.grid(row=2, column=0, columnspan=2, sticky='ew')
|
||
|
|
frame.grid_propagate(False)
|
||
|
|
|
||
|
|
def load(self):
|
||
|
|
"""
|
||
|
|
加载数据
|
||
|
|
:return:
|
||
|
|
"""
|
||
|
|
SQLString = f"select * from {self.table_name}"
|
||
|
|
# 执行SQL语句 并返回列表数据
|
||
|
|
self.TableList = pd.read_sql(SQLString, conn)
|
||
|
|
# 调用X2界面函数将self.TableList数据展示出来
|
||
|
|
self.create_tree_widget()
|
||
|
|
|
||
|
|
|
||
|
|
class FormElement(Frame):
|
||
|
|
def __init__(self, master):
|
||
|
|
super().__init__(master)
|
||
|
|
self.master = master
|
||
|
|
self.data = []
|
||
|
|
self.conn = pymysql.connect(user="root", password="Wyz010810", database="SCT", host="127.0.0.1", port=3306)
|
||
|
|
self.font_style = tkFont.Font(family="Lucida Grande", size=20)
|
||
|
|
self.button_font = tkFont.Font(family="Lucida Grande", size=10)
|
||
|
|
self.default_query_sql = "select * from student"
|
||
|
|
self.create_form()
|
||
|
|
fields_mapping = {'sid': '学号', 'sname': '姓名', 'ssex': '性别', 'sage': '年龄', 'sclass': '班级'}
|
||
|
|
self.create_treeview(pd.read_sql(self.default_query_sql, con=self.conn), fields_mapping)
|
||
|
|
|
||
|
|
|
||
|
|
def create_form(self):
|
||
|
|
# 创建表单区域
|
||
|
|
self.sql_text = Text(self, width=75, height=4, font=self.font_style)
|
||
|
|
self.sql_text.grid(row=0, column=0, rowspan=2)
|
||
|
|
Button(self, text="\n\n执行SQL\n\n", command=self.execute_sql, width=7, style=INFO, compound=TOP).grid(column=1, row=0, rowspan=2, padx=10)
|
||
|
|
self.sql_text.insert(1.0, self.default_query_sql)
|
||
|
|
|
||
|
|
def execute_sql(self):
|
||
|
|
"""
|
||
|
|
执行sql方法
|
||
|
|
:return:
|
||
|
|
"""
|
||
|
|
# 获取text组件中用户输入的值
|
||
|
|
sql = get_text_content(self.sql_text).lower().strip()
|
||
|
|
print(sql)
|
||
|
|
|
||
|
|
def create_treeview(self, data_frame,fields_mapping):
|
||
|
|
"""
|
||
|
|
创建数据列表展示组件
|
||
|
|
:param data_frame:
|
||
|
|
:return:
|
||
|
|
"""
|
||
|
|
frame = Frame(self, height=700) # 创建一个 Frame (框架) 组件，作为树形视图的容器
|
||
|
|
frame.grid(row=10, column=0, columnspan=10, rowspan=5, sticky=NSEW)
|
||
|
|
# 这两行代码使得框架内的行和列可以随着窗口大小的改变而伸缩。
|
||
|
|
frame.grid_columnconfigure(0, weight=1)
|
||
|
|
frame.grid_rowconfigure(0, weight=1)
|
||
|
|
# columns = data_frame.keys().tolist()
|
||
|
|
# 使用字段名映射将列名转换为中文
|
||
|
|
columns = [fields_mapping.get(col, col) for col in data_frame.keys().tolist()]
|
||
|
|
tree = ttk.Treeview(frame, columns=columns, show="headings", style="mystyle.Treeview", height=50,
|
||
|
|
selectmode=BROWSE)
|
||
|
|
style = ttk.Style()
|
||
|
|
style.configure("Treeview.Heading", font=self.font_style)
|
||
|
|
style.configure("Treeview", rowheight=30, font=self.font_style, borderwidth=1)
|
||
|
|
# 根据dataFrame结构生成表
|
||
|
|
for i in columns: # 通过循环，为每一列设置标题（列名）
|
||
|
|
tree.heading(column=i, text=i)
|
||
|
|
for i in columns: # 通过循环，为每一列设置列宽
|
||
|
|
tree.column(i, anchor=CENTER, minwidth=100, width=100)
|
||
|
|
for row in data_frame.itertuples(): # 循环遍历 DataFrame 的每一行，并将数据插入到树形视图中
|
||
|
|
tree.insert(parent="", index=END, values=[row[i] for i in range(1, len(row))])
|
||
|
|
tree.grid(row=0, column=0, sticky=NSEW, pady=10)
|
||
|
|
y_scrollbar = ttk.Scrollbar(frame, orient='vertical', command=tree.yview) # 创建一个垂直滚动条，并将其与树形视图的垂直滚动事件绑定
|
||
|
|
tree.configure(yscrollcommand=y_scrollbar.set)
|
||
|
|
y_scrollbar.grid(row=0, column=1, sticky='ns')
|
||
|
|
frame.grid_propagate(False) # 禁止框架自动调整其大小以适应其中的内容
|
||
|
|
|
||
|
|
|
||
|
|
class StuSys_X2(BaseWindow):
|
||
|
|
def __init__(self, master, attr):
|
||
|
|
super().__init__(master, attr)
|
||
|
|
self.create_left_plate()
|
||
|
|
self.create_right_plate()
|
||
|
|
|
||
|
|
def create_left_plate(self):
|
||
|
|
# 创建左侧装载区域的组件
|
||
|
|
self.left_frame = Frame(self.master, height=self.attr["height"])
|
||
|
|
self.left_frame.pack(side=LEFT, anchor=NW, pady=10, padx=10)
|
||
|
|
load_element1 = LoadElement(self.left_frame, "student")
|
||
|
|
load_element1.pack(side=TOP, pady=10)
|
||
|
|
load_element2 = LoadElement(self.left_frame, "course")
|
||
|
|
load_element2.pack(side=TOP, pady=10)
|
||
|
|
load_element2 = LoadElement(self.left_frame, "sc")
|
||
|
|
load_element2.pack(side=TOP, pady=10)
|
||
|
|
|
||
|
|
def create_right_plate(self):
|
||
|
|
# 创建右侧表单以及数据展示的组件
|
||
|
|
self.right_frame = Frame(self.master, height=self.attr["height"])
|
||
|
|
self.right_frame.pack(side=LEFT, anchor=NW, pady=10, padx=10)
|
||
|
|
form_element = FormElement(self.right_frame)
|
||
|
|
form_element.pack(side=TOP, pady=10, anchor=NE)
|
||
|
|
|
||
|
|
|
||
|
|
# if __name__ == '__main__':
|
||
|
|
# """
|
||
|
|
# minty, lumen, sandstone, yeti, pulse, united, morph, journal, darkly, superhero, solar
|
||
|
|
# cyborg, vapor, simplex, cerculean,
|
||
|
|
# """
|
||
|
|
# style = "morph"
|
||
|
|
# root = Window(themename=style)
|
||
|
|
# screenwidth = root.winfo_screenwidth()
|
||
|
|
# screenheight = root.winfo_screenheight()
|
||
|
|
# root.columnconfigure(0, weight=1)
|
||
|
|
# root.rowconfigure(1, weight=1)
|
||
|
|
# root_attr = {
|
||
|
|
# "width": screenwidth * 0.83,
|
||
|
|
# "height": screenheight * 0.85,
|
||
|
|
# }
|
||
|
|
# alignstr = '%dx%d+%d+%d' % (root_attr['width'], root_attr['height'], (screenwidth - root_attr['width']) / 2,
|
||
|
|
# (screenheight - root_attr['height']) / 2)
|
||
|
|
# root.geometry(alignstr)
|
||
|
|
# root.resizable(width=False, height=False)
|
||
|
|
# app = StuSys_X2(root, root_attr)
|
||
|
|
#
|
||
|
|
# ttk.Style().configure("TButton", font="-size 18")
|
||
|
|
# root.mainloop()
|
||
|
|
|
||
|
|
|
||
|
|
if __name__ == '__main__':
|
||
|
|
"""
|
||
|
|
minty, lumen, sandstone, yeti, pulse, united, morph, journal, darkly, superhero, solar
|
||
|
|
cyborg, vapor, simplex, cerculean,
|
||
|
|
"""
|
||
|
|
style = "morph"
|
||
|
|
root = Window(themename=style)
|
||
|
|
screenwidth = root.winfo_screenwidth()
|
||
|
|
screenheight = root.winfo_screenheight()
|
||
|
|
root.columnconfigure(0, weight=1)
|
||
|
|
root.rowconfigure(1, weight=1)
|
||
|
|
root_attr = {
|
||
|
|
# "width": screenwidth * 0.83,
|
||
|
|
# "height": screenheight * 0.85,
|
||
|
|
"width": screenwidth * 0.61,
|
||
|
|
"height": screenheight * 0.63,
|
||
|
|
}
|
||
|
|
alignstr = '%dx%d+%d+%d' % (root_attr['width'], root_attr['height'], (screenwidth - root_attr['width']) / 2,
|
||
|
|
(screenheight - root_attr['height']) / 2)
|
||
|
|
root.geometry(alignstr)
|
||
|
|
root.resizable(width=False, height=False)
|
||
|
|
app = StuSys_X2(root, root_attr)
|
||
|
|
|
||
|
|
ttk.Style().configure("TButton", font="-size 18")
|
||
|
|
root.mainloop()
|