我有數(shù)據(jù)庫(kù)包括名為(IMG)的BLOB列,當(dāng)按代碼搜索時(shí),我需要什么,顯示項(xiàng)目圖像,但結(jié)果總是像這樣(caV\xd6\xf7\xd0\xec]c\x1b\x95\xe2\xa4\x00\xe3\xd3\x82L\xc9L\xa2W8H\xaf\xe4\xe0\x9f\xcb\x7f\xb5\xbautm]\x94\'\xb6\xb7p\xa7{\xbffU\xb7Q\xd5\x8d\xe3\xe1\xb....等)import ioimport base64from PyQt5 import QtGuifrom ui import Ui_MainWindowfrom PyQt5.QtCore import *from PyQt5.QtGui import *from PyQt5.QtWidgets import *import astimport sqlite3import sysclass HmcProject ( QMainWindow, Ui_MainWindow ): # ,FORM_CLASS def __init__(self): QMainWindow.__init__ ( self ) super ( HmcProject, self ).__init__ () self.setupUi ( self ) self.Handle_Buttons () self.Db_Connect () self.Image_Retrive() def Db_Connect(self): self.connection = sqlite3.connect ( 'deals_db.db' ) cursor = self.connection.cursor () def Handle_Buttons(self): self.pushButton.clicked.connect(self.Image_Retrive) def Image_Retrive(self): try: cursor = self.connection.cursor () itemsearch = self.lineEdit_Item_NameS_3.text () sql = (''' SELECT IMG FROM deals_data WHERE ITEM_CODE= ? ''') cursor.execute ( sql,[(itemsearch)]) data = cursor.fetchone () print ( data [0]) pix= QPixmap.loadFromData(data[0]) self.label.setPixmap(pix) except: passdef main(): app = QApplication ( sys.argv ) window = HmcProject () window.show () app.exec_ ()if __name__ == '__main__': main ()
顯示來(lái)自 sqlite 的 BLOB 數(shù)據(jù) On Pyqt5 DESIGN
拉風(fēng)的咖菲貓
2022-08-31 16:14:48