import tkinter as tkimport mysql.connector# 连接 MySQL 数据库mydb = mysql.connector.connect(user='sa', password='sa', host='localhost', db='Student')cursor = mydb.cursor()# 创建 GUI 界面# 添加学生信息def create_student_info_window(): tk.Label(root, text="添加学生信息").pack() tk.Entry(root, textvariable=tk.StringVar(value='请输入学生信息')).pack() tk.Button(root, text="添加", command=lambda: add_student()).pack()# 单个录入def add_student(): id = id_entry.get() name = name_entry.get() age = age_entry.get() gender = gender_entry.get() IDcard = IDcard_entry.get() xueyuan = xueyuan_entry.get() banji = banji_entry.get() zhuanye = zhuanye_entry.get() jiguan = jiguan_entry.get() number = number_entry.get() sql = "INSERT INTO students (id, name, age, gender, IDcard, xueyuan, banji, zhuanye, jiguan, number) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" val = (id, name, age, gender, IDcard, xueyuan, banji, zhuanye, jiguan, number) cursor.execute(sql, val) mydb.commit() id_entry.delete(0, tk.END) name_entry.delete(0, tk.END) age_entry.delete(0, tk.END) gender_entry.delete(0, tk.END) IDcard_entry.delete(0, tk.END) xueyuan_entry.delete(0, tk.END) banji_entry.delete(0, tk.END) zhuanye_entry.delete(0, tk.END) jiguan_entry.delete(0, tk.END)number_entry.delete(0, tk.END)
时间: 2024-04-03 19:30:57 浏览: 25
这段代码是用 Python 的 tkinter 库和 mysql.connector 库创建了一个 GUI 界面,用于添加学生信息到 MySQL 数据库中。其中,create_student_info_window() 函数创建了一个窗口,包含了多个文本框和一个添加按钮;add_student() 函数则是在点击添加按钮后将文本框中的信息插入到 MySQL 数据库中。值得注意的是,这里将 SQL 语句和参数分开定义,使用 cursor.execute() 函数执行 SQL 语句并传入参数,最后通过 mydb.commit() 函数提交事务。
相关问题
import tkinter as tk import tkinter.messagebox from tkinter.constants import SUNKEN 注释上述代码
```python
import tkinter as tk
import tkinter.messagebox
from tkinter.constants import SUNKEN # 导入tkinter库和相关模块
# 创建一个根窗口
root = tk.Tk()
# 创建一个Frame,并设置padding为10
frm = tk.Frame(root, padding=10)
frm.grid()
# 在Frame中添加一个Label,显示文本"Hello World!"
ttk.Label(frm, text="Hello World!").grid(column=0, row=0)
# 在Frame中添加一个Button,文本为"Quit",点击按钮时销毁根窗口
ttk.Button(frm, text="Quit", command=root.destroy).grid(column=1, row=0)
# 进入主循环
root.mainloop()
```
这段代码使用了Tkinter库来创建一个简单的GUI应用程序。首先导入了Tkinter库和相关模块,然后创建了一个根窗口。在根窗口中创建了一个Frame,并设置了padding为10。在Frame中添加了一个Label,显示文本"Hello World!",并添加了一个Button,文本为"Quit",点击按钮时会销毁根窗口。最后进入主循环,使应用程序保持运行状态。
import tkinter as tk import mysql.connector from tkinter import messagebox as mb # 连接数据库 mydb = mysql.connector.connect( host="localhost", user="root", password="kk", database="c" ) # 创建游标 mycursor = mydb.cursor() # 创建GUI窗口 root = tk.Tk() root.title("MySQL数据库查询") # 创建文本框和标签 query_label = tk.Label(root, text="查询语句:") query_label.grid(row=0, column=0) query_entry = tk.Entry(root) query_entry.grid(row=0, column=1) # 创建按钮 search_button = tk.Button(root, text="查询", command=search) search_button.grid(row=1, column=0) # 创建结果标签 result_label = tk.Label(root, text="") result_label.grid(row=2, column=0, columnspan=2) # 查询函数 def search(): # 获取查询语句 query = query_entry.get() # 执行查询 mycursor.execute(query) result = mycursor.fetchall() # 在结果标签中显示结果 result_label.config(text=result)
Thank you for providing the code. The issue you are encountering is due to the fact that the `search` function has not been defined before it is called in the `search_button` command. To resolve this issue, you can define the `search` function before the `search_button` widget is created. Here is the updated code:
```
import tkinter as tk
import mysql.connector
from tkinter import messagebox as mb
# 连接数据库
mydb = mysql.connector.connect(
host="localhost",
user="root",
password="kk",
database="c"
)
# 创建游标
mycursor = mydb.cursor()
# 创建GUI窗口
root = tk.Tk()
root.title("MySQL数据库查询")
# 创建文本框和标签
query_label = tk.Label(root, text="查询语句:")
query_label.grid(row=0, column=0)
query_entry = tk.Entry(root)
query_entry.grid(row=0, column=1)
# 查询函数
def search():
# 获取查询语句
query = query_entry.get()
# 执行查询
mycursor.execute(query)
result = mycursor.fetchall()
# 在结果标签中显示结果
result_label.config(text=result)
# 创建按钮
search_button = tk.Button(root, text="查询", command=search)
search_button.grid(row=1, column=0)
# 创建结果标签
result_label = tk.Label(root, text="")
result_label.grid(row=2, column=0, columnspan=2)
# 运行GUI
root.mainloop()
```
I hope this helps! Let me know if you have any further questions.