学生信息管理系统

import sqlite3

# 连接到SQLite数据库

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

cursor = conn.cursor()

# 创建表

cursor.execute('''

CREATE TABLE IF NOT EXISTS students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

age INTEGER,

major TEXT

)

''')

# 插入数据

def add_student(name, age, major):

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

conn.commit()

]]>

def find_student_by_id(student_id):

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

return cursor.fetchone()

# 示例调用

print(find_student_by_id(1))

]]>

while True:

command = input("请输入命令 (add/find/exit): ")

if command == "add":

name = input("姓名: ")

age = int(input("年龄: "))

major = input("专业: ")

add_student(name, age, major)

elif command == "find":

student_id = int(input("请输入学号: "))

result = find_student_by_id(student_id)

if result:

print(f"学号 {student_id}: 姓名 {result[1]}, 年龄 {result[2]}, 专业 {result[3]}")

else:

print("未找到该学生")

elif command == "exit":

break

]]>