mvc多张图片存入数据库

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,
    name TEXT,
    image BLOB
)
''')

# 打开图片文件
image = Image.open('example.jpg')
buffered = io.BytesIO()
image.save(buffered, format="JPEG")
img_str = buffered.getvalue()

# 插入图片到数据库
cursor.execute('INSERT INTO images (name, image) VALUES (?, ?)', ('example.jpg', sqlite3.Binary(img_str)))
conn.commit()

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

import sqlite3
import os

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

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

# 插入图片路径到数据库
image_path = 'path/to/example.jpg'
cursor.execute('INSERT INTO images (name, path) VALUES (?, ?)', ('example.jpg', image_path))
conn.commit()

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