智慧校园建设中的试用与实现——基于Python的智慧校园管理系统开发实例

                CREATE TABLE users (
                    id INTEGER PRIMARY KEY,
                    username TEXT NOT NULL UNIQUE,
                    password TEXT NOT NULL,
                    role TEXT NOT NULL
                );

                CREATE TABLE courses (
                    id INTEGER PRIMARY KEY,
                    name TEXT NOT NULL,
                    teacher TEXT NOT NULL,
                    description TEXT
                );
            

                from flask import Flask, request, jsonify
                from sqlite3 import dbapi2 as sqlite

                app = Flask(__name__)

                def login():
                    conn = sqlite.connect('school.db')
                    cursor = conn.cursor()
                    data = request.get_json()
                    username = data['username']
                    password = data['password']

                    query = "SELECT * FROM users WHERE username=? AND password=?"
                    cursor.execute(query, (username, password))
                    user = cursor.fetchone()

                    if user:
                        return jsonify({"status": "success", "message": "Login successful"})
                    else:
                        return jsonify({"status": "failure", "message": "Invalid credentials"})

                if __name__ == '__main__':
                    app.run(debug=True)