学生信息管理系统

import sqlite3

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

cursor = conn.cursor()

cursor.execute('''CREATE TABLE IF NOT EXISTS students (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER, grade REAL)''')

def add_student(name, age, grade):

cursor.execute("INSERT INTO students (name, age, grade) VALUES (?, ?, ?)", (name, age, grade))

conn.commit()

def get_students():

cursor.execute("SELECT * FROM students")

return cursor.fetchall()

def main():

print("欢迎来到学生工作管理系统！")

while True:

print("\n1. 添加学生\n2. 查看所有学生\n3. 退出")

choice = input("请输入你的选择: ")

if choice == '1':

公司统一身份认证平台

name = input("请输入学生姓名: ")

age = int(input("请输入学生年龄: "))

grade = float(input("请输入学生成绩: "))

add_student(name, age, grade)

print("学生已添加！")

elif choice == '2':

students = get_students()

for student in students:

print(student)

elif choice == '3':

print("再见！")

break

else:

print("无效的选择，请重试。")

if __name__ == '__main__':

main()