一、问题描述
利用Qt开发前端界面时,当我们想要在textEdit中显示数据库表中的数据时,真的是太不美观了,如下图所示:
二、问题思路
1.先创建一个table Widget表格,使数据库表中的内容显示在表格中;
2.给按钮添加信号连接功能;
3.连接mysql并查询数据库,返回的是二维元组;
4.遍历二维元组,并将数据显示在table Widget里。
视频演示地址连接:
PyQt5连接mysql查询所有数据 并显示在table
三、问题解决
- 先创建一个table Widget表格,使数据库表中的内容显示在表格中,如下所示:
代码如下:
from PyQt5 import QtCore, QtGui, QtWidgets
from PyQt5.QtWidgets import QApplication, QWidget
import sys
import pymysql
class Ui_Form(object):
def setupUi(self, Form):
Form.setObjectName("Form")
Form.resize(830, 567)
self.pushButton = QtWidgets.QPushButton(Form)
self.pushButton.setGeometry(QtCore.QRect(360, 50, 93, 28))
self.pushButton.setObjectName("pushButton")
self.tableWidget = QtWidgets.QTableWidget(Form)
self.tableWidget.setGeometry(QtCore.QRect(220, 100, 421, 331))
self.tableWidget.setObjectName("tableWidget")
self.tableWidget.setColumnCount(3)
self.tableWidget.setRowCount(13)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(0, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(1, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(2, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(3, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(4, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(5, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(6, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(7, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(8, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(9, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(10, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(11, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(12, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setHorizontalHeaderItem(0, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setHorizontalHeaderItem(1, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setHorizontalHeaderItem(2, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setItem(1, 1, item)
self.retranslateUi(Form)
QtCore.QMetaObject.connectSlotsByName(Form)
def retranslateUi(self, Form):
_translate = QtCore.QCoreApplication.translate
Form.setWindowTitle(_translate("Form", "Form"))
self.pushButton.setText(_translate("Form", "PushButton"))
item = self.tableWidget.verticalHeaderItem(0)
item.setText(_translate("Form", "1"))
item = self.tableWidget.verticalHeaderItem(1)
item.setText(_translate("Form", "2"))
item = self.tableWidget.verticalHeaderItem(2)
item.setText(_translate("Form", "3"))
item = self.tableWidget.verticalHeaderItem(3)
item.setText(_translate("Form", "4"))
item = self.tableWidget.verticalHeaderItem(4)
item.setText(_translate("Form", "5"))
item = self.tableWidget.verticalHeaderItem(5)
item.setText(_translate("Form", "6"))
item = self.tableWidget.verticalHeaderItem(6)
item.setText(_translate("Form", "7"))
item = self.tableWidget.verticalHeaderItem(7)
item.setText(_translate("Form", "8"))
item = self.tableWidget.verticalHeaderItem(8)
item.setText(_translate("Form", "9"))
item = self.tableWidget.verticalHeaderItem(9)
item.setText(_translate("Form", "10"))
item = self.tableWidget.verticalHeaderItem(10)
item.setText(_translate("Form", "11"))
item = self.tableWidget.verticalHeaderItem(11)
item.setText(_translate("Form", "12"))
item = self.tableWidget.verticalHeaderItem(12)
item.setText(_translate("Form", "13"))
item = self.tableWidget.horizontalHeaderItem(0)
item.setText(_translate("Form", "Number"))
item = self.tableWidget.horizontalHeaderItem(1)
item.setText(_translate("Form", "University"))
item = self.tableWidget.horizontalHeaderItem(2)
item.setText(_translate("Form", "Award"))
__sortingEnabled = self.tableWidget.isSortingEnabled()
self.tableWidget.setSortingEnabled(False)
self.tableWidget.setSortingEnabled(__sortingEnabled)
if __name__ == '__main__':
app = QApplication(sys.argv)
Widget = QWidget()
ui = Ui_Form()
ui.setupUi(Widget)
Widget.show()
sys.exit(app.exec_())
- 给按钮添加信号连接功能(创建函数)
self.pushButton.clicked.connect(self.load)
- 连接mysql并查询数据库,返回的是二维元组(核心)
def load(self):
conn = pymysql.Connect(
host='localhost',
user='root',
password='自己设置的mysql密码',
database='mysql'
)
cursor = conn.cursor()
cursor.execute('select * from awardlist')
data = cursor.fetchall()
print(data)
- 遍历二维元组,并将数据显示在table Widget里(核心)
x = 0
for i in data:
y = 0
for j in i:
self.tableWidget.setItem(x,y,QtWidgets.QTableWidgetItem(str(data[x][y])))
y = y + 1
x = x + 1
cursor.close()
conn.close()
到此,点击按钮,就可以看到数据库表中的数据美观的排列起来了,如下图: