Python 图片数据MYSQL存取(BASE64编码解码)
1.相关python代码
#-*- coding:utf-8 -*-import pymysqlimport sysimport base64import osdef dbinfo():conn = ""conn = pymysql.connect(host='127.0.0.1', port=3306, user="root", password='123456', database='data',charset='utf8',cursorclass =pymysql.cursors.DictCursor)cur = conn.cursor()if not cur:return "access db is fail!"else:return connfp = open('tools.png','rb').read() #读取图片信息base64_date = base64.b64encode(fp) #二级制图片BASE64编码try:conn=dbinfo()conncur = conn.cursor()sql_insertimage="insert into tess (id,imgs) VALUE (%s, %s) "conncur.execute(sql_insertimage, ('1',base64_date))seatdic= conncur.fetchall()mit()conn.close()except pymysql.Error as e :print("Error %d %s" % (e.args[0],e.args[1]))sys.exit(1)try:conn = dbinfo()conncur = conn.cursor()sql_selectimage = "select imgs from tess"conncur.execute(sql_selectimage)softpath = conncur.fetchall()softpathlist = [x['imgs'].decode('gbk') for x in softpath]print(softpathlist)for i in softpathlist:print(i)imgdata = base64.b64decode(i)with open('123.png', 'wb') as f:f.write(imgdata)mit()conn.close()except pymysql.Error as e :print(e)sys.exit(1)
2.数据库字段、存储
