实战项目23：YOLOv8可视化Web智能检测系统｜含数据库/权限/报表/全套成品毕设

python
from flask import Flask, render_template, request, redirect, url_for, session, jsonify
import os
import time
import pandas as pd
from ultralytics import YOLO
import pymysql

app = Flask(__name__)
app.secret_key = "yolov8_web_system_2026"

# 数据库配置
db = pymysql.connect(
    host="localhost",
    user="root",
    password="123456",
    database="yolov8_web_db",
    charset="utf8"
)

# 加载YOLOv8模型
model = YOLO("best.pt")

# 静态文件、上传文件路径
UPLOAD_FOLDER = "static/upload"
RESULT_FOLDER = "static/result"
os.makedirs(UPLOAD_FOLDER, exist_ok=True)
os.makedirs(RESULT_FOLDER, exist_ok=True)

# 首页路由
@app.route("/")
def index():
    return render_template("index.html")

# 登录页面
@app.route("/login", methods=["GET","POST"])
def login():
    if request.method == "POST":
        username = request.form.get("username")
        password = request.form.get("password")
        cursor = db.cursor()
        sql = "SELECT * FROM user WHERE username=%s AND password=%s"
        cursor.execute(sql, (username, password))
        res = cursor.fetchone()
        if res:
            session["username"] = username
            session["role"] = res[3]
            return redirect(url_for("index"))
    return render_template("login.html")

# 图片检测路由
@app.route("/detect_img",methods=["POST"])
def detect_img():
    file = request.files["file"]
    conf = float(request.form.get("conf",0.4))
    if file:
        filename = str(int(time.time())) + os.path.splitext(file.filename)[-1]
        save_path = os.path.join(UPLOAD_FOLDER,filename)
        file.save(save_path)

        # YOLOv8推理
        results = model(save_path, conf=conf)
        result_img = results[0].plot()
        result_name = "res_" + filename
        result_path = os.path.join(RESULT_FOLDER, result_name)
        cv2.imwrite(result_path, result_img)

        # 统计目标数量
        num = len(results[0].boxes)
        # 写入数据库日志
        cursor = db.cursor()
        insert_sql = """
        INSERT INTO detect_log(detect_type,target_num,conf_param,img_path,user_name)
        VALUES (%s,%s,%s,%s,%s)
        """
        cursor.execute(insert_sql,("图片检测",num,conf,result_path,session.get("username","游客")))
        db.commit()

        return jsonify({"code":200,"msg":"检测成功","img_url":result_path,"num":num})
    return jsonify({"code":400,"msg":"上传失败"})

# 日志数据查询
@app.route("/get_log")
def get_log():
    cursor = db.cursor()
    cursor.execute("SELECT * FROM detect_log ORDER BY detect_time DESC")
    data = cursor.fetchall()
    return jsonify({"code":200,"data":data})

# 导出Excel报表
@app.route("/export_excel")
def export_excel():
    cursor = db.cursor()
    cursor.execute("SELECT * FROM detect_log")
    res = cursor.fetchall()
    df = pd.DataFrame(res,columns=["编号","检测时间","检测类型","目标数量","置信度","图片路径","操作用户"])
    excel_path = "static/检测报表.xlsx"
    df.to_excel(excel_path,index=False)
    return excel_path

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

sql
CREATE DATABASE IF NOT EXISTS yolov8_web_db DEFAULT CHARSET utf8;
USE yolov8_web_db;

-- 用户信息表
CREATE TABLE user(
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(30) NOT NULL UNIQUE,
    password VARCHAR(30) NOT NULL,
    role VARCHAR(20) NOT NULL,
    register_time DATETIME DEFAULT NOW(),
    status TINYINT DEFAULT 1
);

-- 插入默认管理员账号
INSERT INTO user(username,password,role) VALUES ('admin','123456','管理员');

-- 检测日志表
CREATE TABLE detect_log(
    id INT PRIMARY KEY AUTO_INCREMENT,
    detect_time DATETIME DEFAULT NOW(),
    detect_type VARCHAR(20),
    target_num INT,
    conf_param FLOAT,
    img_path VARCHAR(100),
    user_name VARCHAR(30)
);