import sqlite3

def create_table():

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

cursor = conn.cursor()

cursor.execute('''

CREATE TABLE IF NOT EXISTS students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

student_id TEXT UNIQUE NOT NULL,

major TEXT NOT NULL

)

''')

conn.commit()

conn.close()

create_table()

]]>

def add_student(name, student_id, major):

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

cursor = conn.cursor()

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

(name, student_id, major))

conn.commit()

conn.close()

add_student('张三', 'S12345678', '计算机科学')

]]>

def get_student(student_id):

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

cursor = conn.cursor()

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

result = cursor.fetchone()

conn.close()

return result

print(get_student('S12345678'))

]]>

def update_student(student_id, new_major):

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

cursor = conn.cursor()

cursor.execute('UPDATE students SET major = ? WHERE student_id = ?',

(new_major, student_id))

conn.commit()

conn.close()

update_student('S12345678', '人工智能')

]]>

def delete_student(student_id):

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

cursor = conn.cursor()

cursor.execute('DELETE FROM students WHERE student_id = ?', (student_id,))

conn.commit()

conn.close()

delete_student('S12345678')

]]>