frmchangepassword.frm

工资管理系统

VERSION 5.00
Begin VB.Form ChangePassword 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "修改登录口令"
   ClientHeight    =   1980
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   3645
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   ScaleHeight     =   1980
   ScaleWidth      =   3645
   Begin VB.TextBox txtOldPWD 
      DataSource      =   "Adodc1"
      Height          =   270
      Left            =   1162
      Locked          =   -1  'True
      MaxLength       =   6
      TabIndex        =   4
      TabStop         =   0   'False
      Top             =   240
      Width           =   1935
   End
   Begin VB.TextBox txtNewPWD 
      Height          =   270
      Index           =   1
      Left            =   1147
      MaxLength       =   6
      TabIndex        =   1
      Top             =   960
      Width           =   1935
   End
   Begin VB.TextBox txtNewPWD 
      Height          =   270
      Index           =   0
      Left            =   1147
      MaxLength       =   6
      TabIndex        =   0
      Top             =   630
      Width           =   1935
   End
   Begin VB.CommandButton cmdSave 
      Caption         =   "保存"
      Default         =   -1  'True
      Height          =   300
      Left            =   982
      TabIndex        =   2
      Top             =   1425
      Width           =   735
   End
   Begin VB.CommandButton cmdExit 
      Cancel          =   -1  'True
      Caption         =   "关闭"
      Height          =   300
      Left            =   2182
      TabIndex        =   3
      Top             =   1440
      Width           =   735
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      Caption         =   "新口令"
      Height          =   180
      Left            =   547
      TabIndex        =   7
      Top             =   1005
      Width           =   540
   End
   Begin VB.Label Label3 
      AutoSize        =   -1  'True
      Caption         =   "新口令"
      Height          =   180
      Left            =   547
      TabIndex        =   6
      Top             =   660
      Width           =   540
   End
   Begin VB.Label Label2 
      AutoSize        =   -1  'True
      Caption         =   "旧口令"
      Height          =   180
      Left            =   547
      TabIndex        =   5
      Top             =   285
      Width           =   540
   End
End
Attribute VB_Name = "ChangePassword"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdExit_Click()
    Unload Me       '关闭口令修改窗体
End Sub

Private Sub cmdSave_Click()
    On Error GoTo DealError
    If Trim(txtNewPWD(0)) = "" Then
        MsgBox "请输入新口令！", vbCritical, "修改口令"
        txtNewPWD(0).SetFocus
    ElseIf txtNewPWD(1) <> txtNewPWD(0) Then   '验证两次输入的新口令是否相同
        MsgBox "两次输入的新口令必须相同！", vbCritical, "修改口令"
        txtNewPWD(0).SetFocus
        txtNewPWD(0).SelStart = 0
        txtNewPWD(0).SelLength = Len(txtNewPWD(0))
    Else            '修改原来的口令
        '建立数据库连接，修改当前用户口令
        Dim objCn As New Connection
        strcn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                    "Data Source=" & App.Path & "\数据库\工资管理.mdb"
        objCn.Open strcn
        strsql = "Update 系统用户 set 口令='" & txtNewPWD(0) & "' " _
                 & "Where 用户名='" & ThisUserName & "'"
        objCn.Execute strsql, isupdated
        If isupdated > 0 Then
            ThisPassword = txtNewPWD(0)
            MsgBox "口令已被成功修改！", vbInformation, "修改口令"
        Else
            MsgBox "无法修改口令！", vbCritical, "修改口令"
        End If
        objCn.Close
        Set objCn = Nothing
    End If
    Exit Sub
DealError:
    ShowError "程序执行出错，错误信息如下：" & vbCrLf & Err.Description
End Sub

Private Sub Form_Load()
    txtOldPWD = ThisPassword  '显示用户口令
End Sub