基于Python实现的教材管理系统与用户手册

import sqlite3

def create_table():

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

cursor = conn.cursor()

cursor.execute('''

CREATE TABLE IF NOT EXISTS textbooks (

id INTEGER PRIMARY KEY AUTOINCREMENT,

title TEXT NOT NULL,

author TEXT NOT NULL,

year INT NOT NULL

)

''')

conn.commit()

conn.close()

def add_textbook(title, author, year):

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

cursor = conn.cursor()

cursor.execute("INSERT INTO textbooks (title, author, year) VALUES (?, ?, ?)", (title, author, year))

conn.commit()

实习管理平台

conn.close()

def list_textbooks():

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

cursor = conn.cursor()

cursor.execute("SELECT * FROM textbooks")

rows = cursor.fetchall()

for row in rows:

print(row)

conn.close()

]]>