错误详情
代码
import sys
import MySQLdb
from PyQt5.QtWidgets import QWidget, QApplication
from RfidAttendance.login_ui import Ui_Dialog
db = MySQLdb.connect("localhost", "root", "root", "contact", charset='utf8')
cursor = db.cursor()
class login(QWidget, Ui_Dialog):
def __init__(self, parent=None):
super(login, self).__init__(parent)
self.setupUi(self)
self.retranslateUi(self)
self.pushButton.clicked.connect(self.login)
def init(self):
self.lineEdit.clear()
self.lineEdit_2.clear()
def login(self):
if self.radioButton.isChecked():
accnum = self.lineEdit.text()
password = self.lineEdit_2.text()
sql = "select accnum from account "
cursor.execute(sql)
AccnumResults = cursor.fetchall()
print(AccnumResults)
AccnumList = []
AccnumList.clear()
for i in AccnumResults:
AccnumList.append(i[0])
if accnum not in AccnumList:
print("登录失败,无此用户!")
self.init()
else:
sql2 = "select password from account where accnum = '%s'" % accnum
cursor.execute(sql2)
PasswordResults = cursor.fetchall()
print(PasswordResults)
PasswordList = []
PasswordList.clear()
for i in PasswordResults:
PasswordList.append(i[0])
if password not in PasswordList:
print("请检查密码")
self.init()
cursor.close()
elif self.radioButton_2.isChecked():
accnum = self.lineEdit.text()
password = self.lineEdit_2.text()
sql = "select accnum from administrators "
cursor.execute(sql)
AccnumResults = cursor.fetchall()
print(AccnumResults)
AccnumList = []
AccnumList.clear()
for i in AccnumResults:
AccnumList.append(i[0])
print(AccnumList)
if accnum not in AccnumList:
print("登录失败,无此用户!")
self.init()
else:
sql2 = "select password from administrators where accnum = '%s'" % accnum
cursor.execute(sql2)
PasswordResults = cursor.fetchall()
print(PasswordResults)
PasswordList = []
PasswordList.clear()
for i in PasswordResults:
PasswordList.append(i[0])
if password not in PasswordList:
print("请检查密码")
self.init()
else:
print("登录成功")
self.init()
cursor.close()
else:
print("请选择人员类别")
self.init()
if __name__ == "__main__":
app = QApplication(sys.argv)
log = login()
log.show()
sys.exit(app.exec_())