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()