基于教材发放管理系统与手册的设计与实现

import sqlite3

# 创建数据库连接

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

cursor = conn.cursor()

# 创建教材表

cursor.execute('''

数据平台

CREATE TABLE IF NOT EXISTS textbook (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

author TEXT,

quantity INTEGER DEFAULT 0

)

''')

# 添加教材

def add_textbook(name, author, quantity):

cursor.execute('INSERT INTO textbook (name, author, quantity) VALUES (?, ?, ?)',

(name, author, quantity))

conn.commit()

# 查询教材

def query_textbook():

cursor.execute('SELECT * FROM textbook')

return cursor.fetchall()

]]>