# -*- coding: utf-8 -*-
# Form implementation generated from reading ui file 'formpendaftaran.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_MainWindow2(object):
def koneksi(self):
db = pymysql.connect("localhost", "root", "", "pendaftaran")
cur = db.cursor()
def save(self):
comboBox_2 = QtWidgets.QComboBox
db = pymysql.connect("localhost", "root", "", "pendaftaran")
cur = db.cursor()
a = self.lineEdit.text()
b = self.lineEdit_2.text()
c = self.radioButton.text()
d = self.lineEdit_3.text()
e = self.comboBox_2.currentText()
f = self.lineEdit_4.text()
g = self.lineEdit_5.text()
h = self.lineEdit_6.text()
cur.execute(
"INSERT INTO mhs_baru VALUES('" + a + "','" + b + "','" + c + "','" + d + "','" + e + "','" + f + "','" + g + "','" + h + "')")
db.commit()
def update(self):
db = pymysql.connect("localhost", "root", "", "pendaftaran")
cur = db.cursor()
i = self.lineEdit_7.text()
j = self.lineEdit_8.text()
cur.execute("UPDATE mhs_baru SET prodi='" + j + "' WHERE nama='" + i + "'")
db.commit()
def setupUi(self, MainWindow2):
MainWindow2.setObjectName("MainWindow2")
MainWindow2.resize(450, 691)
self.centralwidget = QtWidgets.QWidget(MainWindow2)
self.centralwidget.setObjectName("centralwidget")
self.label = QtWidgets.QLabel(self.centralwidget)
self.label.setGeometry(QtCore.QRect(40, 10, 411, 41))
font = QtGui.QFont()
font.setFamily("MS Reference Sans Serif")
font.setPointSize(12)
font.setBold(True)
font.setWeight(75)
self.label.setFont(font)
self.label.setObjectName("label")
self.label_2 = QtWidgets.QLabel(self.centralwidget)
self.label_2.setGeometry(QtCore.QRect(20, 60, 47, 13))
self.label_2.setObjectName("label_2")
self.label_3 = QtWidgets.QLabel(self.centralwidget)
self.label_3.setGeometry(QtCore.QRect(10, 170, 61, 16))
self.label_3.setObjectName("label_3")
self.label_4 = QtWidgets.QLabel(self.centralwidget)
self.label_4.setGeometry(QtCore.QRect(30, 220, 71, 16))
self.label_4.setObjectName("label_4")
self.label_6 = QtWidgets.QLabel(self.centralwidget)
self.label_6.setGeometry(QtCore.QRect(30, 270, 47, 13))
self.label_6.setObjectName("label_6")
self.label_7 = QtWidgets.QLabel(self.centralwidget)
self.label_7.setGeometry(QtCore.QRect(10, 320, 81, 16))
self.label_7.setObjectName("label_7")
self.label_9 = QtWidgets.QLabel(self.centralwidget)
self.label_9.setGeometry(QtCore.QRect(40, 370, 47, 13))
self.label_9.setObjectName("label_9")
self.label_10 = QtWidgets.QLabel(self.centralwidget)
self.label_10.setGeometry(QtCore.QRect(20, 420, 71, 16))
self.label_10.setObjectName("label_10")
self.radioButton = QtWidgets.QRadioButton(self.centralwidget)
self.radioButton.setGeometry(QtCore.QRect(120, 170, 82, 17))
self.radioButton.setObjectName("radioButton")
self.radioButton_2 = QtWidgets.QRadioButton(self.centralwidget)
self.radioButton_2.setGeometry(QtCore.QRect(220, 170, 82, 17))
self.radioButton_2.setObjectName("radioButton_2")
self.pushButton = QtWidgets.QPushButton(self.centralwidget)
self.pushButton.setGeometry(QtCore.QRect(80, 480, 75, 23))
self.pushButton.setObjectName("pushButton")
self.pushButton.clicked.connect(self.save)
self.comboBox_2 = QtWidgets.QComboBox(self.centralwidget)
self.comboBox_2.setGeometry(QtCore.QRect(130, 260, 69, 22))
self.comboBox_2.setObjectName("comboBox_2")
self.comboBox_2.addItem("")
self.comboBox_2.addItem("")
self.comboBox_2.addItem("")
self.comboBox_2.addItem("")
self.comboBox_2.addItem("")
self.lineEdit = QtWidgets.QLineEdit(self.centralwidget)
self.lineEdit.setGeometry(QtCore.QRect(120, 60, 113, 20))
self.lineEdit.setObjectName("lineEdit")
self.lineEdit_2 = QtWidgets.QLineEdit(self.centralwidget)
self.lineEdit_2.setGeometry(QtCore.QRect(120, 110, 113, 20))
self.lineEdit_2.setObjectName("lineEdit_2")
self.lineEdit_3 = QtWidgets.QLineEdit(self.centralwidget)
self.lineEdit_3.setGeometry(QtCore.QRect(120, 210, 113, 20))
self.lineEdit_3.setObjectName("lineEdit_3")
self.lineEdit_4 = QtWidgets.QLineEdit(self.centralwidget)
self.lineEdit_4.setGeometry(QtCore.QRect(130, 320, 113, 20))
self.lineEdit_4.setObjectName("lineEdit_4")
self.label_12 = QtWidgets.QLabel(self.centralwidget)
self.label_12.setGeometry(QtCore.QRect(20, 110, 51, 16))
self.label_12.setObjectName("label_12")
self.lineEdit_5 = QtWidgets.QLineEdit(self.centralwidget)
self.lineEdit_5.setGeometry(QtCore.QRect(130, 370, 113, 20))
self.lineEdit_5.setObjectName("lineEdit_5")
self.lineEdit_6 = QtWidgets.QLineEdit(self.centralwidget)
self.lineEdit_6.setGeometry(QtCore.QRect(130, 420, 113, 20))
self.lineEdit_6.setObjectName("lineEdit_6")
self.label_5 = QtWidgets.QLabel(self.centralwidget)
self.label_5.setGeometry(QtCore.QRect(20, 530, 47, 20))
self.label_5.setObjectName("label_5")
self.label_8 = QtWidgets.QLabel(self.centralwidget)
self.label_8.setGeometry(QtCore.QRect(20, 580, 47, 13))
self.label_8.setObjectName("label_8")
self.pushButton_2 = QtWidgets.QPushButton(self.centralwidget)
self.pushButton_2.setGeometry(QtCore.QRect(70, 620, 75, 23))
self.pushButton_2.setObjectName("pushButton_2")
self.pushButton_2.clicked.connect(self.update)
self.lineEdit_7 = QtWidgets.QLineEdit(self.centralwidget)
self.lineEdit_7.setGeometry(QtCore.QRect(120, 530, 113, 20))
self.lineEdit_7.setObjectName("lineEdit_7")
self.lineEdit_8 = QtWidgets.QLineEdit(self.centralwidget)
self.lineEdit_8.setGeometry(QtCore.QRect(120, 580, 113, 20))
self.lineEdit_8.setObjectName("lineEdit_8")
MainWindow2.setCentralWidget(self.centralwidget)
self.menubar = QtWidgets.QMenuBar(MainWindow2)
self.menubar.setGeometry(QtCore.QRect(0, 0, 450, 21))
self.menubar.setObjectName("menubar")
MainWindow2.setMenuBar(self.menubar)
self.statusbar = QtWidgets.QStatusBar(MainWindow2)
self.statusbar.setObjectName("statusbar")
MainWindow2.setStatusBar(self.statusbar)
self.retranslateUi(MainWindow2)
QtCore.QMetaObject.connectSlotsByName(MainWindow2)
def retranslateUi(self, MainWindow2):
_translate = QtCore.QCoreApplication.translate
MainWindow2.setWindowTitle(_translate("MainWindow2", "MainWindow"))
self.label.setText(_translate("MainWindow2", "FORMULIR PENDAFTARAN MAHASISWA BARU"))
self.label_2.setText(_translate("MainWindow2", "Nama"))
self.label_3.setText(_translate("MainWindow2", "Jenis kelamin"))
self.label_4.setText(_translate("MainWindow2", "TTL"))
self.label_6.setText(_translate("MainWindow2", "Agama"))
self.label_7.setText(_translate("MainWindow2", "Alamat Lengkap"))
self.label_9.setText(_translate("MainWindow2", "Email"))
self.label_10.setText(_translate("MainWindow2", "Program Studi"))
self.radioButton.setText(_translate("MainWindow2", "LAKI-LAKI"))
self.radioButton_2.setText(_translate("MainWindow2", "PEREMPUAN"))
self.pushButton.setText(_translate("MainWindow2", "DAFTAR"))
self.comboBox_2.setItemText(0, _translate("MainWindow2", "Agama"))
self.comboBox_2.setItemText(1, _translate("MainWindow2", "Islam"))
self.comboBox_2.setItemText(2, _translate("MainWindow2", "Kristen"))
self.comboBox_2.setItemText(3, _translate("MainWindow2", "Hindu"))
self.comboBox_2.setItemText(4, _translate("MainWindow2", "Budha"))
self.label_12.setText(_translate("MainWindow2", "Asal SMA"))
self.label_5.setText(_translate("MainWindow2", "NAMA:"))
self.label_8.setText(_translate("MainWindow2", "PRODI:"))
self.pushButton_2.setText(_translate("MainWindow2", "UPDATE"))
if __name__ == "__main__":
import sys
app = QtWidgets.QApplication(sys.argv)
MainWindow2 = QtWidgets.QMainWindow()
ui = Ui_MainWindow2()
ui.setupUi(MainWindow2)
MainWindow2.show()
sys.exit(app.exec_())
Komentar
Posting Komentar