Program Menampilkan Data PyQt Designer Bahasa Python


# -*- coding: utf-8 -*-

# Form implementation generated from reading ui file 'Listmahasiswa.ui'
#
# Created by: PyQt5 UI code generator 5.13.0
#
# WARNING! All changes made in this file will be lost!


from PyQt5 import QtCore, QtGui, QtWidgets
import pymysql

class Ui_MainWindow4(object):
    def koneksi(self):
        db = pymysql.connect("localhost", "root", "", "pendaftaran")
        cur = db.cursor()
    def isidata(self):
        db = pymysql.connect("localhost", "root", "", "pendaftaran")
        cur = db.cursor()
        cur.execute("SELECT * FROM mhs_baru")
        results = cur.fetchall()
        self.tableWidget.setRowCount(0)
        for row_number,row_data in enumerate(results):
            self.tableWidget.insertRow(row_number)
            for column_number,data in enumerate(row_data):
                self.tableWidget.setItem(row_number, column_number,QtWidgets.QTableWidgetItem(str(data)))
        db.close()
    def setupUi(self, MainWindow4):
        self.koneksi()
        MainWindow4.setObjectName("MainWindow4")
        MainWindow4.resize(516, 380)
        self.centralwidget = QtWidgets.QWidget(MainWindow4)
        self.centralwidget.setObjectName("centralwidget")
        self.label = QtWidgets.QLabel(self.centralwidget)
        self.label.setGeometry(QtCore.QRect(110, 20, 301, 41))
        font = QtGui.QFont()
        font.setPointSize(10)
        font.setBold(True)
        font.setWeight(75)
        self.label.setFont(font)
        self.label.setObjectName("label")
        self.tableWidget = QtWidgets.QTableWidget(self.centralwidget)
        self.tableWidget.setGeometry(QtCore.QRect(40, 80, 421, 181))
        self.tableWidget.setRowCount(5)
        self.tableWidget.setColumnCount(8)
        self.tableWidget.setObjectName("tableWidget")
        self.pushButton = QtWidgets.QPushButton(self.centralwidget)
        self.pushButton.setGeometry(QtCore.QRect(340, 270, 121, 21))
        self.pushButton.setObjectName("pushButton")
        self.pushButton.clicked.connect(self.isidata)
        MainWindow4.setCentralWidget(self.centralwidget)
        self.menubar = QtWidgets.QMenuBar(MainWindow4)
        self.menubar.setGeometry(QtCore.QRect(0, 0, 516, 21))
        self.menubar.setObjectName("menubar")
        MainWindow4.setMenuBar(self.menubar)
        self.statusbar = QtWidgets.QStatusBar(MainWindow4)
        self.statusbar.setObjectName("statusbar")
        MainWindow4.setStatusBar(self.statusbar)

        self.retranslateUi(MainWindow4)
        QtCore.QMetaObject.connectSlotsByName(MainWindow4)

    def retranslateUi(self, MainWindow4):
        _translate = QtCore.QCoreApplication.translate
        MainWindow4.setWindowTitle(_translate("MainWindow4", "MainWindow"))
        self.label.setText(_translate("MainWindow4", "Mahasiswa Yang Terdaftar Di Universitas Ini"))
        self.pushButton.setText(_translate("MainWindow4", "Lihat Semua Mahasiswa"))


if __name__ == "__main__":
    import sys
    app = QtWidgets.QApplication(sys.argv)
    MainWindow4 = QtWidgets.QMainWindow()
    ui = Ui_MainWindow4()
    ui.setupUi(MainWindow4)
    MainWindow4.show()
    sys.exit(app.exec_())

Komentar