如何从MySQL数据库中检索BLOB格式的图像并显示在html <img>标签中？

import mysql.connector
from PIL import Image
from io import BytesIO
from flask import Flask, render_template_string

app = Flask(__name__)

@app.route('/')
def display_image():
    # 连接到MySQL数据库
    conn = mysql.connector.connect(
        host='localhost',
        user='username',
        password='password',
        database='database_name'
    )
    
    # 执行查询语句
    cursor = conn.cursor()
    cursor.execute("SELECT image_blob FROM table_name WHERE condition")
    
    # 获取图像数据
    image_blob = cursor.fetchone()[0]
    
    # 将图像数据转换为合适的格式
    image = Image.open(BytesIO(image_blob))
    
    # 将图像数据嵌入HTML <img>标签
    html = render_template_string('<img src="data:image/jpeg;base64,{{ image_data }}" />', image_data=image_blob)
    
    # 关闭数据库连接
    cursor.close()
    conn.close()
    
    return html

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