Program Mencari Data PyQt Designer Bahasa Python

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

# Form implementation generated from reading ui file 'carimahasiswa.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_MainWindow3(object):
    def koneksi(self):
        db = pymysql.connect("localhost", "root", "", "pendaftaran")
        cur = db.cursor()

    def lihat(self):
        db = pymysql.connect("localhost", "root", "", "pendaftaran")
        cur = db.cursor()
        a = self.lineEdit.text()
        cur.execute("SELECT * FROM mhs_baru WHERE nama='" + a + "'")
        result = cur.fetchall()
        if (result):
            for row in result:
                self.lineEdit_2.setText("" + row[0])
                self.lineEdit_3.setText("" + row[7])
        else:
                self.lineEdit_2.setText("Tidak ada")
                self.lineEdit_3.setText("Tidak ada")

    def delete(self):
        db = pymysql.connect("localhost", "root", "", "pendaftaran")
        cur = db.cursor()
        c = self.lineEdit_4.text()
        cur.execute("DELETE FROM mhs_baru WHERE nama='" + c + "'")
        db.commit()
    def setupUi(self, MainWindow3):
        self.koneksi()
        MainWindow3.setObjectName("MainWindow3")
        MainWindow3.resize(417, 500)
        self.centralwidget = QtWidgets.QWidget(MainWindow3)
        self.centralwidget.setObjectName("centralwidget")
        self.label = QtWidgets.QLabel(self.centralwidget)
        self.label.setGeometry(QtCore.QRect(116, 20, 181, 20))
        self.label.setObjectName("label")
        self.label_2 = QtWidgets.QLabel(self.centralwidget)
        self.label_2.setGeometry(QtCore.QRect(40, 130, 47, 13))
        self.label_2.setObjectName("label_2")
        self.label_3 = QtWidgets.QLabel(self.centralwidget)
        self.label_3.setGeometry(QtCore.QRect(70, 90, 261, 21))
        self.label_3.setObjectName("label_3")
        self.lineEdit = QtWidgets.QLineEdit(self.centralwidget)
        self.lineEdit.setGeometry(QtCore.QRect(100, 130, 113, 20))
        self.lineEdit.setObjectName("lineEdit")
        self.pushButton = QtWidgets.QPushButton(self.centralwidget)
        self.pushButton.setGeometry(QtCore.QRect(220, 130, 75, 23))
        self.pushButton.setObjectName("pushButton")
        self.pushButton.clicked.connect(self.lihat)
        self.label_4 = QtWidgets.QLabel(self.centralwidget)
        self.label_4.setGeometry(QtCore.QRect(80, 230, 181, 31))
        self.label_4.setObjectName("label_4")
        self.label_5 = QtWidgets.QLabel(self.centralwidget)
        self.label_5.setGeometry(QtCore.QRect(40, 280, 47, 13))
        self.label_5.setObjectName("label_5")
        self.label_6 = QtWidgets.QLabel(self.centralwidget)
        self.label_6.setGeometry(QtCore.QRect(40, 320, 47, 13))
        self.label_6.setObjectName("label_6")
        self.lineEdit_2 = QtWidgets.QLineEdit(self.centralwidget)
        self.lineEdit_2.setGeometry(QtCore.QRect(90, 280, 113, 20))
        self.lineEdit_2.setObjectName("lineEdit_2")
        self.lineEdit_3 = QtWidgets.QLineEdit(self.centralwidget)
        self.lineEdit_3.setGeometry(QtCore.QRect(90, 320, 113, 20))
        self.lineEdit_3.setObjectName("lineEdit_3")
        self.label_7 = QtWidgets.QLabel(self.centralwidget)
        self.label_7.setGeometry(QtCore.QRect(90, 370, 171, 16))
        self.label_7.setObjectName("label_7")
        self.label_8 = QtWidgets.QLabel(self.centralwidget)
        self.label_8.setGeometry(QtCore.QRect(40, 400, 47, 13))
        self.label_8.setObjectName("label_8")
        self.lineEdit_4 = QtWidgets.QLineEdit(self.centralwidget)
        self.lineEdit_4.setGeometry(QtCore.QRect(90, 400, 113, 20))
        self.lineEdit_4.setObjectName("lineEdit_4")
        self.pushButton_2 = QtWidgets.QPushButton(self.centralwidget)
        self.pushButton_2.setGeometry(QtCore.QRect(210, 400, 75, 23))
        self.pushButton_2.setObjectName("pushButton_2")
        self.pushButton_2.clicked.connect(self.delete)
        MainWindow3.setCentralWidget(self.centralwidget)
        self.menubar = QtWidgets.QMenuBar(MainWindow3)
        self.menubar.setGeometry(QtCore.QRect(0, 0, 417, 21))
        self.menubar.setObjectName("menubar")
        MainWindow3.setMenuBar(self.menubar)
        self.statusbar = QtWidgets.QStatusBar(MainWindow3)
        self.statusbar.setObjectName("statusbar")
        MainWindow3.setStatusBar(self.statusbar)

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

    def retranslateUi(self, MainWindow3):
        _translate = QtCore.QCoreApplication.translate
        MainWindow3.setWindowTitle(_translate("MainWindow3", "MainWindow"))
        self.label.setText(_translate("MainWindow3", "SISTEM INFORMASI MAHASISWA"))
        self.label_2.setText(_translate("MainWindow3", "NAMA:"))
        self.label_3.setText(_translate("MainWindow3", "MASUKKAN NAMA YANG INGIN ANDA CARI DATANYA"))
        self.pushButton.setText(_translate("MainWindow3", "CARI"))
        self.label_4.setText(_translate("MainWindow3", "DATA MAHASISWA YANG ANDA CARI"))
        self.label_5.setText(_translate("MainWindow3", "NAMA:"))
        self.label_6.setText(_translate("MainWindow3", "PRODI:"))
        self.label_7.setText(_translate("MainWindow3", "HAPUS DATA MAHASISWA"))
        self.label_8.setText(_translate("MainWindow3", "NAMA:"))
        self.pushButton_2.setText(_translate("MainWindow3", "HAPUS"))


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