python - pyqt5 tablewidgets 检索数据

Question

你好，我想从 mysql 数据库检索数据，我想将其添加到我的 pyqt5 tablewidget 中，但它给了我错误，即 int 对象不可迭代

这是我的代码

def LoadData(self):
    conn = mdb.connect("localhost", "root", "", "pyqt5")

    with conn:
        query = "SELECT * FROM data"
        cur = conn.cursor()
        result = cur.execute(query)
    self.tableWidget.setRowCount(0)
    for row_number, row_data in enumerate():
        self.tableWidget.insertRow(row_number)
        for col_number, data in enumerate(row_data):
            self.tableWidget.setItem(row_number, col_number, QtWidgets.QTableWidgetItem(str(data)))

Answer 1

试试这个。您在第一个 for 循环中缺少“enumerate(result)”。

 def LoadData(self):
    conn = mdb.connect("localhost", "root", "", "pyqt5")

    with conn:
        query = "SELECT * FROM data"
        cur = conn.cursor()
        result = cur.execute(query)
    self.tableWidget.setRowCount(0)
    for row_number, row_data in enumerate(result):
        self.tableWidget.insertRow(row_number)
        for col_number, data in enumerate(row_data):
            self.tableWidget.setItem(row_number, col_number, QtWidgets.QTableWidgetItem(str(data)))