python 生成二维码,本地服务器上传数据,直接运行就能用
uploadpdf.py
from flask import Flask, request, redirect, url_for,abort,send_from_directory
import mysql.connector
import os
import qrcode
app = Flask(__name__)
# 数据库配置
db_config = {
'host': '127.0.0.1',
'user': 'abc',
'password': 'abc',
'database': 'abc_v3'
}
UPLOAD_FOLDER = 'uploads'
if not os.path.exists(UPLOAD_FOLDER):
os.makedirs(UPLOAD_FOLDER)
def upload_file_to_db(file_path, mime_type,file_name):
try:
# 连接数据库
conn = mysql.connector.connect(
host=db_config['host'],
user=db_config['user'],
password=db_config['password'],
database=db_config['database']
)
cursor = conn.cursor()
# 读取文件内容
with open(file_path, 'rb') as file:
file_data = file.read()
# 插入文件数据,注意注意注意下面的pdf_documents是我自己数据库里放pdf的表名称,需要改成你自己表的名字!!!
query = "INSERT INTO pdf_documents (name, mime_type,content,file_path) VALUES (%s, %s,%s,%s)"
cursor.execute(query, (file_name,mime_type, file_data,file_path))
conn