import pymysql
from datetime import datetime
# 创建数据库,先连接到mysql数据库
conn = pymysql.connect(host='127.0.0.1', user='root', database='smart_apartment_db',
password='160507pcsd', charset='utf8')
# 创建一个游标
cursor = conn.cursor()
# excute()函数可以执行简单得sql语句
f = open(file='./img/imageOne.jpg', mode='rb')
dataimg = f.read()
f.close()
nowtime = datetime.now().strftime("%Y-%m-%d, %H:%M:%S")
argdata = pymysql.Binary(dataimg)
sqlone = "insert into img_pack(imgtime,imgdata) values(%s,%s)"
try:
cursor.execute(sqlone, (
nowtime, argdata)
)
conn.commit()
except Exception as e:
conn.rollback()
print("错误信息: ", e)
# 先关闭游标
cursor.close()
# 再关闭数据库连接
conn.close()