构建基于Python的江西高校招生系统

import tkinter as tk

from tkinter import messagebox

import sqlite3

# 创建数据库连接

conn = sqlite3.connect('jx_admission.db')

cursor = conn.cursor()

cursor.execute('''CREATE TABLE IF NOT EXISTS students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

数字化校园解决方案

name TEXT,

score REAL)''')

def add_student():

name = entry_name.get()

score = entry_score.get()

if not name or not score:

messagebox.showerror("错误", "姓名和分数不能为空")

return

try:

cursor.execute("INSERT INTO students (name, score) VALUES (?, ?)", (name, float(score)))

conn.commit()

messagebox.showinfo("成功", f"{name}已添加")

except Exception as e:

messagebox.showerror("错误", str(e))

root = tk.Tk()

root.title("江西高校招生系统")

label_name = tk.Label(root, text="姓名:")

label_name.grid(row=0, column=0)

entry_name = tk.Entry(root)

entry_name.grid(row=0, column=1)

label_score = tk.Label(root, text="分数:")

label_score.grid(row=1, column=0)

entry_score = tk.Entry(root)

entry_score.grid(row=1, column=1)

btn_add = tk.Button(root, text="添加学生", command=add_student)

btn_add.grid(row=2, column=1)

root.mainloop()

conn.close()

def query_student():

student_id = entry_query.get()

if not student_id.isdigit():

messagebox.showerror("错误", "请输入有效的ID")

return

cursor.execute("SELECT * FROM students WHERE id=?", (int(student_id),))

result = cursor.fetchone()

if result:

messagebox.showinfo("查询结果", f"ID: {result[0]}, 姓名: {result[1]}, 分数: {result[2]}")

else:

messagebox.showinfo("查询结果", "未找到该学生")