实战项目13：YOLOv8全套毕设终极系统｜Web网页端+数据库+后台管理+EXE桌面端完整成品

bash
pip install ultralytics flask pymysql opencv-python numpy echarts-python -i https://pypi.tuna.tsinghua.edu.cn/simple

sql
CREATE DATABASE yolov8_system;
USE yolov8_system;

CREATE TABLE user(
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(20) NOT NULL,
    password VARCHAR(20) NOT NULL,
    role VARCHAR(10) DEFAULT "user",
    create_time DATETIME DEFAULT NOW()
);

CREATE TABLE detect_log(
    id INT PRIMARY KEY AUTO_INCREMENT,
    detect_type VARCHAR(30),
    target_num INT,
    warn_status VARCHAR(20),
    save_path VARCHAR(100),
    detect_time DATETIME DEFAULT NOW()
);

python
from flask import Flask,render_template,request,jsonify
import pymysql
import cv2
from ultralytics import YOLO
import time

app = Flask(__name__)

# 加载模型（可自由切换）
model = YOLO("best.pt")

# 数据库连接
def get_db():
    db = pymysql.connect(
        host="localhost",
        user="root",
        password="123456",
        database="yolov8_system",
        charset="utf8"
    )
    return db

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

# 检测接口
@app.route("/detect",methods=["POST"])
def detect():
    if request.files.get("file"):
        file = request.files["file"]
        save_path = "static/"+str(int(time.time()))+".jpg"
        file.save(save_path)

        # 算法推理
        results = model(save_path,conf=0.4)
        num = len(results[0].boxes)

        # 存入数据库
        db = get_db()
        cur = db.cursor()
        sql = f"insert into detect_log(detect_type,target_num,warn_status,save_path) values('智能检测',{num},'正常','{save_path}')"
        cur.execute(sql)
        db.commit()
        cur.close()
        db.close()

        return jsonify({"code":200,"msg":"检测成功","num":num})
    return jsonify({"code":400,"msg":"无文件上传"})

# 获取日志数据
@app.route("/get_log")
def get_log():
    db = get_db()
    cur = db.cursor()
    cur.execute("select * from detect_log order by detect_time desc")
    res = cur.fetchall()
    cur.close()
    db.close()
    return jsonify(res)

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

bash
pyinstaller -F -w main.py --noconsole