Client.py 文件源码

def buildTable():
    cconn, data = SQL_Handler.connectToDatabase('fobs', form.UsernameField.text(), form.PasswordField.text(), 'localhost')
    form2.sqlTable.clear()
    SQL_Handler.getAndSetData(cconn)
    form2.sqlTable.setColumnCount(len(data))
    form2.sqlTable.setRowCount(len(list(data.values())[0]))
    form2.sqlTable.setHorizontalHeaderLabels(sorted([d for d in data.keys()]))
    form2.sqlTable.resizeRowsToContents()
    form2.sqlTable.resizeColumnsToContents()
    for col, key in enumerate(sorted(data.keys())):
        for row, item in enumerate(data[key]):
            itemWidget = QTableWidgetItem(str(item))
            form2.sqlTable.setItem(row, col, itemWidget)