python - 如何在 QComboBox 中从 sqlite 数据库中设置文本？

Question

嗨，我创建了一个搜索功能并搜索记录 frint 组合框，但值不打印

def searchEmpolyee(self):

    searchresult = self.b1.text()

    self.conn = sqlite3.connect("databas.db")
    self.c = self.conn.cursor()
    result = self.c.execute("SELECT * from Hr_depart WHERE id='"+searchresult+"'")
    row = result.fetchone()

    self.b1.setText(str(row[0]))
    self.b2.setItemText(row[1]) # b2 is object name QcomboBox
    self.b3.setText(str(row[2]))
    self.b4.setText(str(row[3]))
    self.b5.setText(str(row[4]))
    self.b6.setText(str(row[5]))
    self.b7.setText(str(row[6]))
    self.b8.setItemText(row[7])  # b8 is object name QcomboBox

    QMessageBox.information(QMessageBox(), 'Successful', " "+searchresult+"  :Record Successfully Found!")
    self.conn.commit()
    self.c.close()
    self.conn.close()

标签： pythonpython-3.xpython-2.7pyqtpyqt4