构建基于商标理念的智慧教材管理平台

学工管理系统

import sqlite3

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

cursor = conn.cursor()

cursor.execute('''

CREATE TABLE IF NOT EXISTS textbook (

id INTEGER PRIMARY KEY AUTOINCREMENT,

title TEXT UNIQUE NOT NULL,

author TEXT NOT NULL,

trademark TEXT UNIQUE NOT NULL

)

''')

conn.commit()

conn.close()

]]>

from flask import Flask, request, jsonify

app = Flask(__name__)

@app.route('/add_textbook', methods=['POST'])

def add_textbook():

data = request.get_json()

title = data['title']

author = data['author']

trademark = data['trademark']

# Add to database logic here

return jsonify({"message": "Textbook added successfully"}), 201

if __name__ == '__main__':

app.run(debug=True)

]]>