基于Python的研究生管理系统设计与实现

import sqlite3

# 连接到SQLite数据库（如果文件不存在会自动创建）

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

cursor = conn.cursor()

# 创建研究生信息表

cursor.execute('''

CREATE TABLE IF NOT EXISTS students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

major TEXT NOT NULL,

supervisor TEXT

);

''')

print("表已成功创建！")

def add_student(name, major, supervisor):

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

cursor = conn.cursor()

cursor.execute('INSERT INTO students (name, major, supervisor) VALUES (?, ?, ?)',

(name, major, supervisor))

conn.commit()

print(f"研究生 {name} 已成功添加！")

def get_student_by_name(name):

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

cursor = conn.cursor()

cursor.execute('SELECT * FROM students WHERE name = ?', (name,))

result = cursor.fetchone()

if result:

print(f"找到研究生 {name}: ID={result[0]}, Major={result[2]}, Supervisor={result[3]}")

else:

print(f"未找到名为 {name} 的研究生。")

顶岗实习管理系统