def loginCheck(self): username = self.username_lineEdit.text() password = self.password_lineEdit.text() db = MySQLdb.connect(host="localhost", user="******", passwd="zaq12wsx", db="sakila") cursor = db.cursor() cursor.execute("SELECT * FROM actor WHERE user_name = %s AND password = %s", (username, password)) numrows = cursor.rowcount if numrows > 0: print("User found!") try: self.app2 = QtWidgets.QApplication(sys.argv) self.Dialog2 = QtWidgets.QMainWindow() self.ui = Ui_MainWindow() self.ui.setupUi(self.Dialog2) self.Dialog2.show() except: traceback.print_exc() else: print("User not found!")
def loginCheck(self): username=self.uname_lineEdit.text() password=self.pass_lineEdit.text() connection=sqlite3.connect("login.db") result=connection.execute("SELECT * FROM USERS WHERE USERNAME=? AND PASSWORD=?",(username,password)) if(len(result.fetchall()) >0): print("User Found..!") #############################3 self.welcomeWindow=QtWidgets.QMainWindow() self.ui=Ui_MainWindow() self.ui.setupUi(self.welcomeWindow) Dialog.hide() self.welcomeWindow.show() ################################ else: print("User not Found..!")
def welcomeWindowShow(self): self.welcomeWindow = QtGui.QMainWindow() self.ui = Ui_MainWindow() self.ui.setupUi(self.welcomeWindow) self.welcomeWindow.show()
def welcome(self): from welcome import Ui_MainWindow self.Window = QtWidgets.QMainWindow() self.ui = Ui_MainWindow() self.ui.setupUi(self.Window) self.Window.show()