研究生管理系统中的学生信息管理
import sqlite3
# 连接到SQLite数据库
conn = sqlite3.connect('graduate_students.db')
cursor = conn.cursor()
]]>
cursor.execute('''
CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
major TEXT NOT NULL,
entry_year INTEGER NOT NULL
)
''')
conn.commit()
]]>
cursor.execute('''
INSERT INTO students (name, major, entry_year)
VALUES ('张三', '计算机科学', 2020)
''')
conn.commit()
]]>
cursor.execute('SELECT * FROM students')
all_students = cursor.fetchall()
print(all_students)
]]>
本站知识库部分内容及素材来源于互联网，如有侵权，联系必删！