基于Python实现的研究生管理信息系统下载功能设计与实现

                import sqlite3

                # 连接数据库
                conn = sqlite3.connect('gmis.db')
                cursor = conn.cursor()

                # 创建表
                cursor.execute('''
                    CREATE TABLE IF NOT EXISTS documents (
                        id INTEGER PRIMARY KEY AUTOINCREMENT,
                        name TEXT NOT NULL,
                        path TEXT NOT NULL
                    );
                ''')

                # 插入数据
                cursor.execute("INSERT INTO documents (name, path) VALUES ('example.pdf', '/path/to/example.pdf')")
                conn.commit()
            

                from flask import Flask, send_file

                app = Flask(__name__)

                @app.route('/download/')
                def download(doc_id):
                    conn = sqlite3.connect('gmis.db')
                    cursor = conn.cursor()
                    cursor.execute("SELECT path FROM documents WHERE id=?", (doc_id,))
                    result = cursor.fetchone()
                    if result:
                        return send_file(result[0], as_attachment=True)
                    else:
                        return "Document not found", 404

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