修改口令.frm

企业工资管理系统的主要任务是用计算机对各种工资信息进行日常的管理

VERSION 5.00
Begin VB.Form ChangePassword 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "修改登录口令"
   ClientHeight    =   2550
   ClientLeft      =   45
   ClientTop       =   435
   ClientWidth     =   4485
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2550
   ScaleWidth      =   4485
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton cmdExit 
      Cancel          =   -1  'True
      Caption         =   "关闭"
      Height          =   375
      Left            =   2640
      TabIndex        =   7
      Top             =   1920
      Width           =   1095
   End
   Begin VB.CommandButton cmdSave 
      Caption         =   "保存"
      Default         =   -1  'True
      Height          =   375
      Left            =   600
      TabIndex        =   6
      Top             =   1920
      Width           =   1095
   End
   Begin VB.TextBox txtNewPWD 
      Height          =   375
      Index           =   1
      Left            =   1920
      TabIndex        =   5
      Top             =   1200
      Width           =   2055
   End
   Begin VB.TextBox txtNewPWD 
      Height          =   375
      Index           =   0
      Left            =   1920
      TabIndex        =   4
      Top             =   660
      Width           =   2055
   End
   Begin VB.TextBox txtOldPWD 
      Height          =   375
      Left            =   1920
      Locked          =   -1  'True
      TabIndex        =   3
      Top             =   120
      Width           =   2055
   End
   Begin VB.Label Label3 
      AutoSize        =   -1  'True
      Caption         =   "重新输入新口令："
      Height          =   180
      Left            =   240
      TabIndex        =   2
      Top             =   1320
      Width           =   1440
   End
   Begin VB.Label Label2 
      AutoSize        =   -1  'True
      Caption         =   "新口令："
      Height          =   180
      Left            =   960
      TabIndex        =   1
      Top             =   757
      Width           =   720
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      Caption         =   "旧口令："
      Height          =   180
      Left            =   960
      TabIndex        =   0
      Top             =   240
      Width           =   720
   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()
  '首先检查两次新口令是否一致,然后创建Connection对象建立数据库连接用Connection对象的Execute方法执行Update查询修改口令
On Error GoTo DealError
  If Trim(txtNewPWD(0)) = "" Then
     MsgBox "请输入新口令!", vbCritical, "修改口令"
     txtNewPWD(0).SetFocus
  ElseIf txtNewPWD(1) <> txtNewPWD(0) Then                '验证2次输入
     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:
   msg = "程序执行出错，错误信息如下：" & vbCrLf & Err.Description
   ShowError msg

End Sub

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