研究生管理信息系统操作手册解析与代码实现

CREATE TABLE students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

student_id TEXT UNIQUE NOT NULL,

name TEXT NOT NULL,

major TEXT NOT NULL,

email TEXT UNIQUE

);

import sqlite3

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

cursor = conn.cursor()

cursor.execute("INSERT INTO students (student_id, name, major, email) VALUES (?, ?, ?, ?)",

('S12345', 'Alice Smith', 'Computer Science', 'alice@example.com'))

conn.commit()

conn.close()

走班排课系统

import sqlite3

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

cursor = conn.cursor()

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

result = cursor.fetchall()

print(result)

conn.close()

import sqlite3

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

cursor = conn.cursor()

cursor.execute("UPDATE students SET email = ? WHERE student_id = ?",

('new_email@example.com', 'S12345'))

conn.commit()

conn.close()