1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
| import sys
from PyQt5.QtWidgets import *
from PyQt5.QtGui import *
from PyQt5.QtCore import *
import qdarkstyle
import time
from PyQt5.QtSql import *
import hashlib
class changePasswordDialog(QDialog):
def __init__(self, parent=None):
super(changePasswordDialog, self).__init__(parent)
self.setWindowModality(Qt.WindowModal)
self.setWindowTitle("修改密码")
self.setUpUI()
def setUpUI(self):
self.resize(300, 280)
self.layout = QFormLayout()
self.setLayout(self.layout)
self.titlelabel = QLabel(" 修改密码")
self.studentIdLabel = QLabel("学 号：")
# self.studentNameLabel=QLabel("姓 名：")
self.oldPasswordLabel = QLabel("旧 密 码：")
self.passwordLabel = QLabel("新 密 码：")
self.confirmPasswordLabel = QLabel("确认密码：")
self.studentIdEdit = QLineEdit()
# self.studentNameEdit=QLineEdit()
self.oldPasswordEdit = QLineEdit()
self.passwordEdit = QLineEdit()
self.confirmPasswordEdit = QLineEdit()
self.changePasswordButton = QPushButton("确认修改")
self.changePasswordButton.setFixedWidth(140)
self.changePasswordButton.setFixedHeight(32)
self.layout.addRow("", self.titlelabel)
self.layout.addRow(self.studentIdLabel, self.studentIdEdit)
# self.layout.addRow(self.studentNameLabel,self.studentNameEdit)
self.layout.addRow(self.oldPasswordLabel, self.oldPasswordEdit)
self.layout.addRow(self.passwordLabel, self.passwordEdit)
self.layout.addRow(self.confirmPasswordLabel, self.confirmPasswordEdit)
self.layout.addRow("", self.changePasswordButton)
font = QFont()
font.setPixelSize(20)
self.titlelabel.setFont(font)
font.setPixelSize(16)
self.studentIdLabel.setFont(font)
# self.studentNameLabel.setFont(font)
self.oldPasswordLabel.setFont(font)
self.passwordLabel.setFont(font)
self.confirmPasswordLabel.setFont(font)
font.setPixelSize(16)
self.studentIdEdit.setFont(font)
self.changePasswordButton.setFont(font)
# self.studentNameEdit.setFont(font)
font.setPixelSize(10)
self.oldPasswordEdit.setFont(font)
self.passwordEdit.setFont(font)
self.confirmPasswordEdit.setFont(font)
self.titlelabel.setMargin(8)
self.layout.setVerticalSpacing(10)
# 设置长度
self.studentIdEdit.setMaxLength(10)
self.oldPasswordEdit.setMaxLength(16)
self.passwordEdit.setMaxLength(16)
self.confirmPasswordEdit.setMaxLength(16)
# 设置密码掩膜
self.oldPasswordEdit.setEchoMode(QLineEdit.Password)
self.passwordEdit.setEchoMode(QLineEdit.Password)
self.confirmPasswordEdit.setEchoMode(QLineEdit.Password)
# 设置校验
reg = QRegExp("PB[0~9]{8}")
pValidator = QRegExpValidator(self)
pValidator.setRegExp(reg)
self.studentIdEdit.setValidator(pValidator)
reg = QRegExp("[a-zA-z0-9]+$")
pValidator.setRegExp(reg)
self.oldPasswordEdit.setValidator(pValidator)
self.passwordEdit.setValidator(pValidator)
self.confirmPasswordEdit.setValidator(pValidator)
# 设置信号与槽
self.changePasswordButton.clicked.connect(self.changePasswordButtonClicked)
def changePasswordButtonClicked(self):
studentId = self.studentIdEdit.text()
oldPassword = self.oldPasswordEdit.text()
password = self.passwordEdit.text()
confirmPassword = self.confirmPasswordEdit.text()
if (studentId == "" or oldPassword == "" or password == "" or confirmPassword == ""):
print(QMessageBox.warning(self, "警告", "输入不可为空，请重新输入", QMessageBox.Yes, QMessageBox.Yes))
return
db = QSqlDatabase.addDatabase("QSQLITE")
db.setDatabaseName('./db/LibraryManagement.db')
db.open()
query = QSqlQuery()
sql = "SELECT * FROM User WHERE StudentId='%s'" % studentId
query.exec_(sql)
# 如果用户不存在
if (not query.next()):
print(QMessageBox.warning(self, "警告", "该用户不存在，请重新输入", QMessageBox.Yes, QMessageBox.Yes))
self.studentIdEdit.clear()
return
# 如果密码错误
hl = hashlib.md5()
hl.update(oldPassword.encode(encoding='utf-8'))
md5password = hl.hexdigest()
sql = "SELECT * FROM User WHERE Password='%s' AND StudentId='%s'" %(md5password,studentId)
query.exec_(sql)
if (not query.next()):
print(QMessageBox.warning(self, "警告", "原密码输入错误,请重新输入", QMessageBox.Yes, QMessageBox.Yes))
self.oldPasswordEdit.clear()
return
# 密码与确认密码不同
if(password!=confirmPassword):
print(QMessageBox.warning(self,"警告","两次输入密码不同,请确认输入",QMessageBox.Yes,QMessageBox.Yes))
self.passwordEdit.clear()
self.confirmPasswordEdit.clear()
return
# 修改密码
hl = hashlib.md5()
hl.update(password.encode(encoding='utf-8'))
md5password = hl.hexdigest()
sql="UPDATE User SET Password='%s' WHERE StudentId='%s'"%(md5password,studentId)
query.exec_(sql)
db.commit()
QMessageBox.information(self,"提醒","修改密码成功，请登录系统!",QMessageBox.Yes,QMessageBox.Yes)
self.close()
return
if __name__ == "__main__":
app = QApplication(sys.argv)
app.setWindowIcon(QIcon("./images/MainWindow_1.png"))
app.setStyleSheet(qdarkstyle.load_stylesheet_pyqt5())
mainMindow = changePasswordDialog()
mainMindow.show()
sys.exit(app.exec_())
|
