import sqlite3

# 連接到SQLite數(shù)據(jù)庫(kù)

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

cursor = conn.cursor()

# 創(chuàng)建student_info表

cursor.execute('''CREATE TABLE IF NOT EXISTS student_info (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, student_id TEXT UNIQUE)''')

# 插入學(xué)生信息

def add_student(name, student_id):

cursor.execute("INSERT INTO student_info (name, student_id) VALUES (?, ?)", (name, student_id))

conn.commit()

# 查詢學(xué)生信息

def get_student(student_id):

cursor.execute("SELECT * FROM student_info WHERE student_id=?", (student_id,))

return cursor.fetchone()

學(xué)工系統(tǒng)

# 修改學(xué)生信息

def update_student(student_id, new_name):

cursor.execute("UPDATE student_info SET name=? WHERE student_id=?", (new_name, student_id))

conn.commit()

# 刪除學(xué)生信息

def delete_student(student_id):

cursor.execute("DELETE FROM student_info WHERE student_id=?", (student_id,))

conn.commit()

# 關(guān)閉連接

def close_db():

conn.close()