mdb数据库添加图片

import sqlite3
from PIL import Image
import io

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

# 创建表
cursor.execute('''CREATE TABLE IF NOT EXISTS images (
                    id INTEGER PRIMARY KEY,
                    name TEXT,
                    image BLOB)''')

# 读取图片并转换为二进制数据
with open('example.jpg', 'rb') as f:
    img_data = f.read()

# 将图片数据插入数据库
cursor.execute("INSERT INTO images (name, image) VALUES (?, ?)", ('example.jpg', img_data))
conn.commit()

# 从数据库读取图片数据并显示
cursor.execute("SELECT image FROM images WHERE id = 1")
img_data = cursor.fetchone()[0]
image = Image.open(io.BytesIO(img_data))
image.show()

# 关闭连接
cursor.close()
conn.close()