class loginWindow(QDialog):
initial = ''
def __init__(self, parent=None):
QDialog.__init__(self)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.count = 0
# Connect to the database
self.db = MySQLdb.connect(host='localhost', user='******', password='******', db="library", port=3310)
self.cur = self.db.cursor() # Create a cursor
# Call button handler function
self.buttonHandler()
## ==> REMOVE STANDARD TITLE BAR
self.setWindowFlags(QtCore.Qt.FramelessWindowHint) # Remove title bar
self.setAttribute(QtCore.Qt.WA_TranslucentBackground) # Set background to transparent
def loginHandler(self):
username = self.ui.usernameLEdit.text()
password = self.ui.passwordLEdit.text()
sql = '''SELECT * FROM users '''
self.cur.execute(sql)
data = self.cur.fetchall()
for row in data:
if username == row[1] and password == row[3]:
self.ui.error_label.setText('')
initial = (row[1][0].upper() + row[1][1].upper())
print(initial)
self.window2 = MainWindow()
self.close()
self.window2.show()
self.window2.ui.user_initialsLabel.setText(initial)
MainWindow.currentUser = username
else:
self.ui.error_label.setText('Invalid credentials, please try again')
def buttonHandler(self):
self.ui.pushButton_4.clicked.connect(self.loginHandler)
self.ui.logOffBtn.clicked.connect(self.closeWindow)
self.ui.signUpBtn.clicked.connect(self.openRegisterWindow)
self.ui.viewPasswordBtn.clicked.connect(self.showPassword)
def closeWindow(self):
self.close()
def openRegisterWindow(self):
self.regWindow = registerWindow()
self.close()
self.regWindow.show()
def showPassword(self):
if self.count == 0:
self.ui.passwordLEdit.setEchoMode(QLineEdit.Normal)
self.count = 1
elif self.count == 1:
self.ui.passwordLEdit.setEchoMode(QLineEdit.Password)
self.count = 0
class loginDialog(QDialog):
def __init__(self, parent=None):
# QDialog.__init__(self)
super(loginDialog, self).__init__(parent)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
# QObject.connect(self.ui.openXml_pushButton, QtCore.SIGNAL("clicked()"), self, QtCore.SLOT("xml_open()"))
QtCore.QObject.connect(self.ui.ok_buttonBox, QtCore.SIGNAL("accepted()"), self, QtCore.SLOT("onAccepted()"))
QtCore.QObject.connect(self.ui.ok_buttonBox, QtCore.SIGNAL("rejected()"), self, QtCore.SLOT("onRejected()"))
self.connecting = None
self.parent = parent
def onAccepted(self):
"""确定动作"""
host = str(self.ui.server_lineEdit.text())
port = 8002
user = str(self.ui.user_lineEdit.text())
password = str(self.ui.password_lineEdit.text())
uiDebug("host: " + host + ",user: "******",password: "******"loginPanelUi onAccepted()")
def onRejected(self):
"""取消动作"""
self.parent.closeEvent()
self.reject()
uiDebug("loginPanelUi onRejected()")
def closeEvent(self, evt):
uiDebug("loginPanelUi closeEvent() start")
self.parent.closeEvent(evt)
uiDebug("loginPanelUi closeEvent() end")
def __init__(self, parent=None):
QDialog.__init__(self)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.count = 0
# Connect to the database
self.db = MySQLdb.connect(host='localhost', user='******', password='******', db="library", port=3310)
self.cur = self.db.cursor() # Create a cursor
# Call button handler function
self.buttonHandler()
## ==> REMOVE STANDARD TITLE BAR
self.setWindowFlags(QtCore.Qt.FramelessWindowHint) # Remove title bar
self.setAttribute(QtCore.Qt.WA_TranslucentBackground) # Set background to transparent
def __init__(self, parent=None):
# QDialog.__init__(self)
super(loginDialog, self).__init__(parent)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
# QObject.connect(self.ui.openXml_pushButton, QtCore.SIGNAL("clicked()"), self, QtCore.SLOT("xml_open()"))
QtCore.QObject.connect(self.ui.ok_buttonBox, QtCore.SIGNAL("accepted()"), self, QtCore.SLOT("onAccepted()"))
QtCore.QObject.connect(self.ui.ok_buttonBox, QtCore.SIGNAL("rejected()"), self, QtCore.SLOT("onRejected()"))
self.connecting = None
self.parent = parent
def __init__(self,parent=None):
super(LoginDialog,self).__init__(parent)
self.ui=Ui_Dialog()
self.ui.setupUi(self)
self.ui.checkBox.setChecked(True)
self.retValue=None
self.connect(self.ui.buttonBox,QtCore.SIGNAL("accepted()"),
self.accept())
self.connect(self.ui.buttonBox,QtCore.SIGNAL("rejected()"),
self.reject())
self.ui.leUsername.setFocus()
class LoginDialog(QtGui.QDialog):
def __init__(self,parent=None):
super(LoginDialog,self).__init__(parent)
self.ui=Ui_Dialog()
self.ui.setupUi(self)
self.ui.checkBox.setChecked(True)
self.retValue=None
self.connect(self.ui.buttonBox,QtCore.SIGNAL("accepted()"),
self.accept())
self.connect(self.ui.buttonBox,QtCore.SIGNAL("rejected()"),
self.reject())
self.ui.leUsername.setFocus()
def accept(self):
self.retValue=[self.ui.leUsername.text(),self.ui.lePassword.text()]
QtGui.QDialog.accept(self)
def reject(self):
self.retValue=None
QtGui.QDialog.reject(self)
def getRetValue(self):
return self.retValue
