基于学生实习管理系统的航天实习请假功能实现

import sqlite3

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

cursor = conn.cursor()

cursor.execute('''

CREATE TABLE leave_application (

id INTEGER PRIMARY KEY AUTOINCREMENT,

student_id TEXT NOT NULL,

company_name TEXT NOT NULL,

start_time DATETIME NOT NULL,

end_time DATETIME NOT NULL,

reason TEXT NOT NULL

);

''')

conn.commit()

conn.close()

import tkinter as tk

from tkinter import messagebox

def submit_leave():

student_id = entry_student_id.get()

company_name = entry_company_name.get()

start_time = entry_start_time.get()

end_time = entry_end_time.get()

reason = entry_reason.get()

if not (student_id and company_name and start_time and end_time and reason):

messagebox.showerror("错误", "所有字段都必须填写")

return

try:

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

cursor = conn.cursor()

cursor.execute('''

INSERT INTO leave_application (student_id, company_name, start_time, end_time, reason)

VALUES (?, ?, ?, ?, ?);

''', (student_id, company_name, start_time, end_time, reason))

conn.commit()

messagebox.showinfo("成功", "请假申请已提交")

except Exception as e:

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

finally:

conn.close()

root = tk.Tk()

root.title("航天实习请假系统")

label_student_id = tk.Label(root, text="学生ID:")

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

entry_student_id = tk.Entry(root)

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

label_company_name = tk.Label(root, text="实习单位:")

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

entry_company_name = tk.Entry(root)

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

label_start_time = tk.Label(root, text="开始时间:")

label_start_time.grid(row=2, column=0)

entry_start_time = tk.Entry(root)

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

label_end_time = tk.Label(root, text="结束时间:")

label_end_time.grid(row=3, column=0)

entry_end_time = tk.Entry(root)

entry_end_time.grid(row=3, column=1)

label_reason = tk.Label(root, text="请假原因:")

label_reason.grid(row=4, column=0)

entry_reason = tk.Entry(root)

entry_reason.grid(row=4, column=1)

btn_submit = tk.Button(root, text="提交", command=submit_leave)

btn_submit.grid(row=5, column=1)

root.mainloop()

def view_leaves():

try:

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

cursor = conn.cursor()

cursor.execute("SELECT * FROM leave_application;")

rows = cursor.fetchall()

for row in rows:

print(f"ID: {row[0]}, 学生ID: {row[1]}, 单位: {row[2]}, 开始时间: {row[3]}, 结束时间: {row[4]}, 原因: {row[5]}")

except Exception as e:

print(f"Error: {e}")

finally:

conn.close()

view_leaves()