import sqlite3
# 创建连接
conn = sqlite3.connect('textbook_distribution.db')
cursor = conn.cursor()
# 创建表格
cursor.execute('''
CREATE TABLE IF NOT EXISTS students (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
grade INTEGER NOT NULL,
textbook TEXT
)
''')
# 提交更改并关闭连接
conn.commit()
conn.close()
def add_student(name, grade, textbook):
conn = sqlite3.connect('textbook_distribution.db')
cursor = conn.cursor()
cursor.execute('INSERT INTO students (name, grade, textbook) VALUES (?, ?, ?)', (name, grade, textbook))
conn.commit()
conn.close()
def view_students():
conn = sqlite3.connect('textbook_distribution.db')
cursor = conn.cursor()
cursor.execute('SELECT * FROM students')
rows = cursor.fetchall()
for row in rows:
print(row)
conn.close()
def update_textbook(student_id, new_textbook):
conn = sqlite3.connect('textbook_distribution.db')
cursor = conn.cursor()
cursor.execute('UPDATE students SET textbook = ? WHERE id = ?', (new_textbook, student_id))
conn.commit()
conn.close()