技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 55
|
Private Sub Command1_Click()
If IsNull(new_pwd1) Then
MsgBox "請輸入新密碼!", vbCritical, "提示"
End If
If IsNull(new_pwd2) Then
MsgBox "請再次確認(rèn)新密碼!", vbCritical, "提示"
End If
If new_pwd1 <> new_pwd2 Then
MsgBox "新密碼確認(rèn)不正確!", vbCritical, "提示"
new_pwd1.SetFocus
new_pwd1 = ""
new_pwd2 = ""
End If
Dim rs As New ADODB.Recordset
Dim str As String
str = "select * from 管理員 where 用戶名='" & User & "'"
Set rs = ExeSQL(str)
If Not rs.EOF Then
rs("用戶名") = User
rs("密碼") = new_pwd1
rs.Update
rs.Close
Set rs = Nothing
MsgBox "您成功地修改了該用戶!"
Else
MsgBox "wrong"
End If
Me.Visible = False
End Sub
|
|