上传图片保存在数据库中

import sqlite3
from PIL import Image
import io

# 创建数据库连接
conn = sqlite3.connect('images.db')
cursor = conn.cursor()

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

# 上传图片
def upload_image(name, image_path):
    with open(image_path, 'rb') as f:
        image_data = f.read()
    
    cursor.execute('INSERT INTO images (name, data) VALUES (?, ?)', (name, image_data))
    conn.commit()

# 下载图片
def download_image(image_id):
    cursor.execute('SELECT data FROM images WHERE id = ?', (image_id,))
    image_data = cursor.fetchone()[0]
    
    image = Image.open(io.BytesIO(image_data))
    return image

# 示例：上传图片
upload_image('example.jpg', 'path/to/example.jpg')

# 示例：下载图片
image = download_image(1)
image.show()

# 关闭数据库连接
conn.close()