class Main(QtGui.QMainWindow): def __init__(self,parent=None): super(Main, self).__init__(parent) self.ui = Ui_MainWindow() self.ui.setupUi(self) self.show() self.iniciar_botones() def iniciar_botones(self): """ Funcion que inicia las señales de los objetos """ self.ui.pushButton.clicked.connect(self.entra) self.ui.label_4.setText("") def entra(self): datos = manejo_bd.consulta_claves() for row in datos: print row['id'] if(row['id']==str(self.ui.lineEdit.text()) and row['pass']==str(self.ui.lineEdit_2.text())): menu = menu_controlador.Main(self) menu.exec_ else: self.errorMessageDialog = QtGui.QErrorMessage(self) self.errorMessageDialog.showMessage("error de ingreso")
class Main(QtGui.QMainWindow,Ui_MainWindow): def __init__(self, parent=None): QtGui.QMainWindow.__init__(self,parent) self.ui=Ui_MainWindow() self.ui.setupUi(self) self.ui.pushButton2.clicked.connect(self.kayit) self.ui.pushButton2.setToolTip("Kayit Ol") self.grs=None def kayit(self): username = self.ui.lineEdit.text() email = self.ui.lineEdit_2.text() password = int(self.ui.lineEdit_3.text()) db = MySQLdb.connect("localhost","root","password","Python" ) cursor = db.cursor() #cursor.execute("DROP TABLE IF EXISTS Kullanicilar") #sql = """ CREATE TABLE Kullanicilar (ADI CHAR(20) NOT NULL , SOYADI CHAR(20) NOT NULL , YAS INT )""" sql = "INSERT INTO Kullanicilar(ADI,SOYADI,PAROLA) VALUES('%s','%s','%d')" %(username,email,password) cursor.execute(sql) db.commit() self.ui.statusbar.showMessage("kayit eklendi") self.ui.lineEdit.setText("") self.ui.lineEdit_2.setText("") self.ui.lineEdit_3.setText("") db.close() self.grs = Giris(self.grs) self.grs.show() self.close()
class Window(QMainWindow): def __init__(self): super().__init__() self.ui = Ui_MainWindow() self.ui.setupUi(self) self.initUI() self.show() def initUI(self): self.ui.statusBar.showMessage("Not connected!") self.ui.pushButton.clicked.connect(self.establish_connection) self.ui.pushButton_2.clicked.connect(self.generate_reports) def establish_connection(self): self.username = self.ui.username.text() self.password = self.ui.password.text() self.login_thread = Login(self.username, self.password, self.ui.statusBar) self.login_thread.start() def generate_reports(self): self.filename = self.saveFileDialog() if self.filename is not None: self.report_thread = StoreResults(self.login_thread.connection.jira, self.filename, self.ui.statusBar) self.report_thread.start() def saveFileDialog(self): options = QFileDialog.Options() options |= QFileDialog.DontUseNativeDialog fileName, _ = QFileDialog.getSaveFileName(self,"Save file as...","","Excel-Document (*.xlsx);;All Files (*)", options=options) if fileName and fileName.endswith('xlsx'): return fileName elif fileName: return fileName + '.xlsx'
class LoginDialog(QMainWindow): def __init__(self): super(LoginDialog, self).__init__() # Set up the user interface from Designer. self.ui = Ui_MainWindow() self.ui.setupUi(self)
def run(self): # 2. Implement run() MainWindow = QMainWindow() ui = Ui_MainWindow(self) self.ui_hello = hello_mainWindow() ui.setupUi(MainWindow) MainWindow.show() return self.app.exec_() # 3. End run() with this line
class LoginWindow(QtWidgets.QMainWindow): def __init__(self): super().__init__() self.mainWindow = Ui_MainWindow() self.mainWindow.setupUi(self) self.show() def on_reset(self): self.mainWindow.usernameEdit.setText('') self.mainWindow.passwordEdit.setText('') def on_login(self): username = self.mainWindow.usernameEdit.text() password = self.mainWindow.passwordEdit.text() print(username, password)
class MeuLogin(QtGui.QMainWindow): def __init__(self): QtGui.QMainWindow.__init__(self) self.ui = Ui_MainWindow() self.ui.setupUi(self) QtCore.QMetaObject.connectSlotsByName(self) QtCore.QObject.connect(self.ui.buttonEntrar, QtCore.SIGNAL("clicked()"), self.Entrar) QtCore.QObject.connect(self.ui.buttonCreate, QtCore.SIGNAL("clicked()"), self.Create) def Entrar(self): login = str(self.ui.lineEditUser.text()) senha = str(self.ui.lineEditPass.text()) cur.execute("SELECT login, senha FROM usuarios") data = cur.fetchall() existe = False for x in data: if x[0] == login and x[1] == senha: existe = True if existe: self.ui.lineEditUser.setText("") self.ui.lineEditPass.setText("") self.index = MeuIndex(login, senha) self.index.show() else: erroMsg = QtGui.QMessageBox() erroMsg.setText("Login nao cadastrado") erroMsg.setWindowTitle("Erro") erroMsg.exec_() def Create(self): self.create = MeuCreate() self.create.show()
class Ui_Form(object): ###### chamada de QDialog def bug_report_call(self): self.bug_report = QtWidgets.QWidget() self.ui = Ui_bug_report() self.ui.setupUi(self.bug_report) self.bug_report.show() def login(self): self.login = QtWidgets.QMainWindow() self.ui = Ui_MainWindow() self.ui.setupUi(self.login) self.login.show() def setupUi(self, Form): Form.setObjectName("Form") Form.resize(1109, 828) icon = QtGui.QIcon() icon.addPixmap(QtGui.QPixmap(":/iconteste/icons/Ativo [email protected]"), QtGui.QIcon.Normal, QtGui.QIcon.Off) Form.setWindowIcon(icon) Form.setStyleSheet("background-color:#433A4D;\n" "color:white;") self.verticalLayout_5 = QtWidgets.QVBoxLayout(Form) self.verticalLayout_5.setContentsMargins(0, 0, 0, 0) self.verticalLayout_5.setSpacing(0) self.verticalLayout_5.setObjectName("verticalLayout_5") self.frame_3 = QtWidgets.QFrame(Form) self.frame_3.setMinimumSize(QtCore.QSize(0, 0)) self.frame_3.setMaximumSize(QtCore.QSize(16777215, 60)) self.frame_3.setStyleSheet("background-color: #281c35;\n" "color:#fff;") self.frame_3.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_3.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_3.setObjectName("frame_3") self.verticalLayout_3 = QtWidgets.QVBoxLayout(self.frame_3) self.verticalLayout_3.setContentsMargins(0, 0, 0, 0) self.verticalLayout_3.setSpacing(0) self.verticalLayout_3.setObjectName("verticalLayout_3") self.frame_12 = QtWidgets.QFrame(self.frame_3) self.frame_12.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_12.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_12.setObjectName("frame_12") self.horizontalLayout_3 = QtWidgets.QHBoxLayout(self.frame_12) self.horizontalLayout_3.setContentsMargins(6, 0, 0, 0) self.horizontalLayout_3.setObjectName("horizontalLayout_3") self.frame_2 = QtWidgets.QFrame(self.frame_12) self.frame_2.setMinimumSize(QtCore.QSize(31, 30)) self.frame_2.setMaximumSize(QtCore.QSize(31, 30)) self.frame_2.setStyleSheet("border-image: url(:/iconteste/icons/ba812f4a-b112-4fa5-96d0-dccd574e3a86.jpg);\n" "border-radius:15px;") self.frame_2.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_2.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_2.setObjectName("frame_2") self.gridLayout_3 = QtWidgets.QGridLayout(self.frame_2) self.gridLayout_3.setContentsMargins(0, 0, 0, 0) self.gridLayout_3.setSpacing(0) self.gridLayout_3.setObjectName("gridLayout_3") self.horizontalLayout_3.addWidget(self.frame_2) self.frame_4 = QtWidgets.QFrame(self.frame_12) self.frame_4.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_4.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_4.setObjectName("frame_4") self.verticalLayout = QtWidgets.QVBoxLayout(self.frame_4) self.verticalLayout.setContentsMargins(0, 0, 0, 0) self.verticalLayout.setSpacing(0) self.verticalLayout.setObjectName("verticalLayout") self.Logincadastro = QtWidgets.QPushButton(self.frame_4) self.Logincadastro.setMinimumSize(QtCore.QSize(111, 25)) self.Logincadastro.setMaximumSize(QtCore.QSize(110, 16777215)) self.Logincadastro.setStyleSheet("QPushButton{\n" "border:0px;\n" "border-radius:12px;\n" "}\n" "QPushButton::hover\n" "{\n" "\n" "background-color:#403749\n" "\n" "}\n" "QPushButton::pressed\n" "{\n" "border-style: outset;\n" "border-width: 3px;\n" "border-color: #30fcc2;\n" "background-color:625f66\n" "}\n" "") icon1 = QtGui.QIcon() icon1.addPixmap(QtGui.QPixmap(":/iconteste/icons/user.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off) self.Logincadastro.setIcon(icon1) self.Logincadastro.setObjectName("Logincadastro") self.Logincadastro.clicked.connect(self.login) self.verticalLayout.addWidget(self.Logincadastro) self.horizontalLayout_3.addWidget(self.frame_4) self.frame_5 = QtWidgets.QFrame(self.frame_12) self.frame_5.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_5.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_5.setObjectName("frame_5") self.horizontalLayout_3.addWidget(self.frame_5) self.frame_13 = QtWidgets.QFrame(self.frame_12) self.frame_13.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_13.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_13.setObjectName("frame_13") self.horizontalLayout = QtWidgets.QHBoxLayout(self.frame_13) self.horizontalLayout.setContentsMargins(20, 0, 0, 0) self.horizontalLayout.setSpacing(0) self.horizontalLayout.setObjectName("horizontalLayout") self.label_2 = QtWidgets.QLabel(self.frame_13) self.label_2.setMinimumSize(QtCore.QSize(200, 0)) self.label_2.setMaximumSize(QtCore.QSize(200, 30)) self.label_2.setObjectName("label_2") self.horizontalLayout.addWidget(self.label_2) self.horizontalLayout_3.addWidget(self.frame_13, 0, QtCore.Qt.AlignRight) self.verticalLayout_3.addWidget(self.frame_12) self.label_24 = QtWidgets.QLabel(self.frame_3) self.label_24.setMinimumSize(QtCore.QSize(0, 15)) self.label_24.setMaximumSize(QtCore.QSize(16777215, 15)) self.label_24.setStyleSheet("background-color: qlineargradient(spread:pad, x1:0.0227727, y1:0.557, x2:1, y2:0.551, stop:0.181818 rgba(116, 0, 239, 255), stop:0.903409 rgba(48, 252, 194, 255));") self.label_24.setText("") self.label_24.setObjectName("label_24") self.verticalLayout_3.addWidget(self.label_24) self.verticalLayout_5.addWidget(self.frame_3) self.frame_11 = QtWidgets.QFrame(Form) self.frame_11.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_11.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_11.setObjectName("frame_11") self.gridLayout = QtWidgets.QGridLayout(self.frame_11) self.gridLayout.setObjectName("gridLayout") self.frame_8 = QtWidgets.QFrame(self.frame_11) self.frame_8.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_8.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_8.setObjectName("frame_8") self.verticalLayout_4 = QtWidgets.QVBoxLayout(self.frame_8) self.verticalLayout_4.setObjectName("verticalLayout_4") self.frame_22 = QtWidgets.QFrame(self.frame_8) self.frame_22.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_22.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_22.setObjectName("frame_22") self.verticalLayout_7 = QtWidgets.QVBoxLayout(self.frame_22) self.verticalLayout_7.setSpacing(6) self.verticalLayout_7.setObjectName("verticalLayout_7") self.frame_6 = QtWidgets.QFrame(self.frame_22) self.frame_6.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_6.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_6.setObjectName("frame_6") self.verticalLayout_8 = QtWidgets.QVBoxLayout(self.frame_6) self.verticalLayout_8.setObjectName("verticalLayout_8") self.frame_23 = QtWidgets.QFrame(self.frame_6) self.frame_23.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_23.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_23.setObjectName("frame_23") self.horizontalLayout_9 = QtWidgets.QHBoxLayout(self.frame_23) self.horizontalLayout_9.setSpacing(7) self.horizontalLayout_9.setObjectName("horizontalLayout_9") self.frame_14 = QtWidgets.QFrame(self.frame_23) self.frame_14.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_14.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_14.setObjectName("frame_14") self.horizontalLayout_9.addWidget(self.frame_14) self.pushButton_7 = QtWidgets.QPushButton(self.frame_23) self.pushButton_7.setMinimumSize(QtCore.QSize(100, 30)) self.pushButton_7.setMaximumSize(QtCore.QSize(100, 30)) self.pushButton_7.setStyleSheet("\n" "QPushButton{\n" "border: 1px solid black;\n" "border-radius: 10px;\n" "background-color: white;\n" "color:black;\n" "\n" "}\n" "QPushButton::hover\n" "{\n" "\n" "\n" "border-width: 2px;\n" "\n" "border-color: black;\n" "\n" "}\n" "QPushButton::pressed\n" "{\n" "border-style: outset;\n" "border-width: 3px;\n" "border-color: #281c35;\n" "}\n" "") self.pushButton_7.setObjectName("pushButton_7") self.pushButton_7.clicked.connect(self.bug_report_call) self.horizontalLayout_9.addWidget(self.pushButton_7) self.pushButton_8 = QtWidgets.QPushButton(self.frame_23) self.pushButton_8.setMinimumSize(QtCore.QSize(100, 30)) self.pushButton_8.setMaximumSize(QtCore.QSize(100, 30)) self.pushButton_8.setStyleSheet("\n" "\n" "\n" "QPushButton{\n" "border:1px;\n" "background-color: qlineargradient(spread:pad, x1:0.0227727, y1:0.557, x2:1, y2:0.551, stop:0.181818 rgba(116, 0, 239, 255), stop:0.903409 rgba(48, 252, 194, 255));\n" "border-radius:10px;\n" "}\n" "QPushButton::hover\n" "{\n" "\n" "\n" "border-width: 2px;\n" "\n" "border-color: black;\n" "\n" "}\n" "QPushButton::pressed\n" "{\n" "border-style: outset;\n" "border-width: 3px;\n" "border-color: #30fcc2;\n" "}\n" "") self.pushButton_8.setObjectName("pushButton_8") self.horizontalLayout_9.addWidget(self.pushButton_8) self.frame_15 = QtWidgets.QFrame(self.frame_23) self.frame_15.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_15.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_15.setObjectName("frame_15") self.horizontalLayout_9.addWidget(self.frame_15) self.verticalLayout_8.addWidget(self.frame_23) self.frame_7 = QtWidgets.QFrame(self.frame_6) self.frame_7.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_7.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_7.setObjectName("frame_7") self.verticalLayout_6 = QtWidgets.QVBoxLayout(self.frame_7) self.verticalLayout_6.setObjectName("verticalLayout_6") self.label_5 = QtWidgets.QLabel(self.frame_7) self.label_5.setStyleSheet("font: 16pt \"MS Shell Dlg 2\";") self.label_5.setAlignment(QtCore.Qt.AlignCenter) self.label_5.setObjectName("label_5") self.verticalLayout_6.addWidget(self.label_5) self.verticalLayout_8.addWidget(self.frame_7) self.verticalLayout_7.addWidget(self.frame_6) self.frame_10 = QtWidgets.QFrame(self.frame_22) self.frame_10.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_10.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_10.setObjectName("frame_10") self.verticalLayout_7.addWidget(self.frame_10) self.frame_9 = QtWidgets.QFrame(self.frame_22) self.frame_9.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame_9.setFrameShadow(QtWidgets.QFrame.Raised) self.frame_9.setObjectName("frame_9") self.verticalLayout_7.addWidget(self.frame_9) self.verticalLayout_4.addWidget(self.frame_22) self.frame = QtWidgets.QFrame(self.frame_8) self.frame.setFrameShape(QtWidgets.QFrame.StyledPanel) self.frame.setFrameShadow(QtWidgets.QFrame.Raised) self.frame.setObjectName("frame") self.verticalLayout_2 = QtWidgets.QVBoxLayout(self.frame) self.verticalLayout_2.setContentsMargins(-1, -1, -1, 199) self.verticalLayout_2.setObjectName("verticalLayout_2") self.label_4 = QtWidgets.QLabel(self.frame) self.label_4.setMinimumSize(QtCore.QSize(550, 350)) self.label_4.setStyleSheet("image: url(:/iconteste/icons/404.png);") self.label_4.setText("") self.label_4.setObjectName("label_4") self.verticalLayout_2.addWidget(self.label_4) self.verticalLayout_4.addWidget(self.frame) self.gridLayout.addWidget(self.frame_8, 0, 0, 1, 1) self.verticalLayout_5.addWidget(self.frame_11) self.retranslateUi(Form) QtCore.QMetaObject.connectSlotsByName(Form) def retranslateUi(self, Form): _translate = QtCore.QCoreApplication.translate Form.setWindowTitle(_translate("Form", "404")) self.Logincadastro.setText(_translate("Form", "Login/ Cadastro")) self.label_2.setText(_translate("Form", " andrade esquadrias id user #8774")) self.pushButton_7.setText(_translate("Form", "Bug Report")) self.pushButton_8.setText(_translate("Form", "Retornar ao Inicio")) self.label_5.setText(_translate("Form", "Não encontramos o que você buscava :("))
class Ui_MainWindow2(QtWidgets.QWidget): def setup2(self, MainWindow1): MainWindow1.setObjectName("MainWindow1") MainWindow1.setFixedSize(440, 541) sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Preferred) sizePolicy.setHorizontalStretch(10) sizePolicy.setVerticalStretch(10) sizePolicy.setHeightForWidth( MainWindow1.sizePolicy().hasHeightForWidth()) MainWindow1.setSizePolicy(sizePolicy) MainWindow1.setCursor(QtGui.QCursor(QtCore.Qt.ArrowCursor)) MainWindow1.setFocusPolicy(QtCore.Qt.NoFocus) icon = QtGui.QIcon() icon.addPixmap(QtGui.QPixmap(":/Register/logo2.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off) MainWindow1.setWindowIcon(icon) self.centralwidget = QtWidgets.QWidget(MainWindow1) self.centralwidget.setObjectName("centralwidget") self.label = QtWidgets.QLabel(self.centralwidget) self.label.setGeometry(QtCore.QRect(60, 0, 330, 330)) self.label.setObjectName("label") self.label_2 = QtWidgets.QLabel(self.centralwidget) self.label_2.setGeometry(QtCore.QRect(15, 330, 300, 20)) self.label_2.setObjectName("label_2") self.label_3 = QtWidgets.QLabel(self.centralwidget) self.label_3.setEnabled(True) self.label_3.setGeometry(QtCore.QRect(15, 380, 300, 20)) self.label_3.setObjectName("label_3") self.label_4 = QtWidgets.QLabel(self.centralwidget) self.label_4.setGeometry(QtCore.QRect(20, 430, 300, 20)) self.label_4.setObjectName("label_4") self.user_r = QtWidgets.QLineEdit(self.centralwidget) self.user_r.setGeometry(QtCore.QRect(20, 350, 401, 22)) self.user_r.setObjectName("user_r") self.pass_r = QtWidgets.QLineEdit(self.centralwidget) self.pass_r.setGeometry(QtCore.QRect(20, 400, 401, 22)) self.pass_r.setEchoMode(QtWidgets.QLineEdit.Password) self.pass_r.setObjectName("pass_r") self.cpass_r = QtWidgets.QLineEdit(self.centralwidget) self.cpass_r.setGeometry(QtCore.QRect(20, 450, 401, 22)) self.cpass_r.setEchoMode(QtWidgets.QLineEdit.Password) self.cpass_r.setObjectName("cpass_r") self.register_r = QtWidgets.QPushButton(self.centralwidget) self.register_r.setGeometry(QtCore.QRect(70, 480, 300, 28)) self.register_r.setObjectName("register_r") self.error_r = QtWidgets.QLabel(self.centralwidget) self.error_r.setGeometry(QtCore.QRect(70, 510, 300, 20)) self.error_r.setText("") self.error_r.setObjectName("error_r") MainWindow1.setCentralWidget(self.centralwidget) self.retranslateUi(MainWindow1) QtCore.QMetaObject.connectSlotsByName(MainWindow1) self.register_r.clicked.connect(self.register) def register(self): username = self.user_r.text() passw = self.pass_r.text() cpassword = self.cpass_r.text() dbcon = pymysql.connect( host="rapcwc.cakorcerkah4.us-east-2.rds.amazonaws.com", user="******", password="******", db="RAP") cursor = dbcon.cursor() if passw == cpassword: cursor.execute( "INSERT INTO RAP.login (`user`, `password`) VALUES (%s, %s);", (username, passw)) dbcon.commit() dbcon.close() self.closew() from login import Ui_MainWindow self.window = QtWidgets.QMainWindow() self.ui = Ui_MainWindow() self.ui.setupUi(self.window) self.window.show() else: self.error() print(passw) print(cpassword) def error(self): self.error_r.setText('Please check your username or password') def closew(self): MainWindow1.close() def retranslateUi(self, MainWindow1): _translate = QtCore.QCoreApplication.translate MainWindow1.setWindowTitle(_translate("MainWindow1", "Register")) self.label.setText( _translate( "MainWindow1", "<html><head/><body><p align=\"center\"><img src=\":/Register/logo2.png\"/></p><p align=\"center\"><img src=\":/Register/logo3.png\"/></p></body></html>" )) self.label_2.setText( _translate("MainWindow1", "<html><head/><body><p>Username</p></body></html>")) self.label_3.setText(_translate("MainWindow1", "Password")) self.label_4.setText(_translate("MainWindow1", "Confirm Password")) self.register_r.setText(_translate("MainWindow1", "Register"))
class Ui_Register(object): def openWindow(self): self.window=QtWidgets.QMainWindow() self.ui=Ui_MainWindow() self.ui.setupUi(self.window) self.window.show() def openWindow1(self): self.window=QtWidgets.QMainWindow() self.ui=Ui_MainWindow() self.ui.setupUi(self.window) name=self.textEdit.toPlainText() email=self.textEdit_2.toPlainText() mobile=self.textEdit_3.toPlainText() address=self.textEdit_4.toPlainText() place=self.textEdit_5.toPlainText() usrname=self.textEdit_6.toPlainText() psw=self.textEdit_7.toPlainText() query="INSERT INTO register (name,email,mobile,address,place,usrname,psw) VALUES (%s,%s,%s,%s,%s,%s,%s)" query1="INSERT INTO login (username,password) VALUES (%s,%s)" print("hai") cursor.execute(query,(name,email,mobile,address,place,usrname,psw)) cursor.execute(query1,(usrname,psw)) db.commit() print(cursor.rowcount, "record inserted.") self.window.show() def setupUi(self, Register): Register.setObjectName("Register") Register.resize(800, 600) self.centralwidget = QtWidgets.QWidget(Register) self.centralwidget.setObjectName("centralwidget") self.label = QtWidgets.QLabel(self.centralwidget) self.label.setGeometry(QtCore.QRect(230, 50, 111, 31)) font = QtGui.QFont() font.setPointSize(14) 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(230, 110, 111, 31)) font = QtGui.QFont() font.setPointSize(14) font.setBold(True) font.setWeight(75) self.label_2.setFont(font) self.label_2.setObjectName("label_2") self.label_3 = QtWidgets.QLabel(self.centralwidget) self.label_3.setGeometry(QtCore.QRect(230, 170, 111, 31)) font = QtGui.QFont() font.setPointSize(14) font.setBold(True) font.setWeight(75) self.label_3.setFont(font) self.label_3.setObjectName("label_3") self.label_4 = QtWidgets.QLabel(self.centralwidget) self.label_4.setGeometry(QtCore.QRect(230, 230, 111, 31)) font = QtGui.QFont() font.setPointSize(14) font.setBold(True) font.setWeight(75) self.label_4.setFont(font) self.label_4.setObjectName("label_4") self.label_5 = QtWidgets.QLabel(self.centralwidget) self.label_5.setGeometry(QtCore.QRect(230, 280, 111, 31)) font = QtGui.QFont() font.setPointSize(14) font.setBold(True) font.setWeight(75) self.label_5.setFont(font) self.label_5.setObjectName("label_5") self.label_6 = QtWidgets.QLabel(self.centralwidget) self.label_6.setGeometry(QtCore.QRect(230, 330, 111, 31)) font = QtGui.QFont() font.setPointSize(14) font.setBold(True) font.setWeight(75) self.label_6.setFont(font) self.label_6.setObjectName("label_6") self.label_7 = QtWidgets.QLabel(self.centralwidget) self.label_7.setGeometry(QtCore.QRect(230, 380, 111, 31)) font = QtGui.QFont() font.setPointSize(14) font.setBold(True) font.setWeight(75) self.label_7.setFont(font) self.label_7.setObjectName("label_7") self.textEdit = QtWidgets.QTextEdit(self.centralwidget) self.textEdit.setGeometry(QtCore.QRect(340, 50, 251, 31)) self.textEdit.setObjectName("textEdit") self.textEdit_2 = QtWidgets.QTextEdit(self.centralwidget) self.textEdit_2.setGeometry(QtCore.QRect(340, 110, 251, 31)) self.textEdit_2.setObjectName("textEdit_2") self.textEdit_3 = QtWidgets.QTextEdit(self.centralwidget) self.textEdit_3.setGeometry(QtCore.QRect(340, 170, 251, 31)) self.textEdit_3.setObjectName("textEdit_3") self.textEdit_4 = QtWidgets.QTextEdit(self.centralwidget) self.textEdit_4.setGeometry(QtCore.QRect(340, 230, 251, 31)) self.textEdit_4.setObjectName("textEdit_4") self.textEdit_5 = QtWidgets.QTextEdit(self.centralwidget) self.textEdit_5.setGeometry(QtCore.QRect(340, 280, 251, 31)) self.textEdit_5.setObjectName("textEdit_5") self.textEdit_6 = QtWidgets.QTextEdit(self.centralwidget) self.textEdit_6.setGeometry(QtCore.QRect(340, 330, 251, 31)) self.textEdit_6.setObjectName("textEdit_6") self.textEdit_7 = QtWidgets.QTextEdit(self.centralwidget) self.textEdit_7.setGeometry(QtCore.QRect(340, 380, 251, 31)) self.textEdit_7.setObjectName("textEdit_7") self.pushButton = QtWidgets.QPushButton(self.centralwidget) self.pushButton.setGeometry(QtCore.QRect(210, 440, 99, 27)) self.pushButton.setObjectName("pushButton") self.pushButton_2 = QtWidgets.QPushButton(self.centralwidget) self.pushButton_2.setGeometry(QtCore.QRect(500, 440, 99, 27)) self.pushButton_2.setObjectName("pushButton_2") self.pushButton.clicked.connect(self.openWindow1) self.pushButton_3 = QtWidgets.QPushButton(self.centralwidget) self.pushButton_3.setGeometry(QtCore.QRect(290, 490, 241, 27)) self.pushButton_3.setObjectName("pushButton_3") self.pushButton_3.clicked.connect(self.openWindow) Register.setCentralWidget(self.centralwidget) self.menubar = QtWidgets.QMenuBar(Register) self.menubar.setGeometry(QtCore.QRect(0, 0, 800, 25)) self.menubar.setObjectName("menubar") Register.setMenuBar(self.menubar) self.statusbar = QtWidgets.QStatusBar(Register) self.statusbar.setObjectName("statusbar") Register.setStatusBar(self.statusbar) self.retranslateUi(Register) QtCore.QMetaObject.connectSlotsByName(Register) def retranslateUi(self, Register): _translate = QtCore.QCoreApplication.translate Register.setWindowTitle(_translate("Register", "subtitles")) self.label.setText(_translate("Register", "Name")) self.label_2.setText(_translate("Register", "Email id")) self.label_3.setText(_translate("Register", "Mobile no")) self.label_4.setText(_translate("Register", "Address")) self.label_5.setText(_translate("Register", "Place")) self.label_6.setText(_translate("Register", "User name")) self.label_7.setText(_translate("Register", "Password")) self.pushButton.setText(_translate("Register", "SIGN IN")) self.pushButton_2.setText(_translate("Register", "CANCEL")) self.pushButton_3.setText(_translate("Register", "Allready have an Account?"))
from owner import Ui_ownerPage from billGenerator import Ui_BILL from login import Ui_MainWindow from PyQt5 import QtWidgets from PyQt5 import QtCore, QtGui if __name__ == "__main__": import sys app = QtWidgets.QApplication(sys.argv) MainWindow = QtWidgets.QMainWindow() ui = Ui_MainWindow() ui.setupUi(MainWindow) MainWindow.show() sys.exit(app.exec_())