frm_pass.frm

学校财务管理系统课程设计VB+SQL2

VERSION 5.00
Begin VB.Form frm_pass 
   Caption         =   "Form1"
   ClientHeight    =   4395
   ClientLeft      =   6210
   ClientTop       =   4320
   ClientWidth     =   7530
   LinkTopic       =   "Form1"
   ScaleHeight     =   4395
   ScaleWidth      =   7530
   Begin VB.Frame Frame2 
      BackColor       =   &H00FFC0C0&
      Height          =   4695
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   8055
      Begin VB.CommandButton CmdBack 
         Caption         =   "返回"
         BeginProperty Font 
            Name            =   "楷体_GB2312"
            Size            =   15
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   4920
         TabIndex        =   4
         Top             =   3240
         Width           =   975
      End
      Begin VB.TextBox TxtNewcode02 
         Height          =   375
         IMEMode         =   3  'DISABLE
         Left            =   2760
         PasswordChar    =   "*"
         TabIndex        =   3
         Top             =   2400
         Width           =   2295
      End
      Begin VB.TextBox TxtNewcode01 
         Height          =   375
         IMEMode         =   3  'DISABLE
         Left            =   2760
         PasswordChar    =   "*"
         TabIndex        =   2
         Top             =   1800
         Width           =   2295
      End
      Begin VB.CommandButton CmdXcode 
         Caption         =   "提交"
         BeginProperty Font 
            Name            =   "楷体_GB2312"
            Size            =   15
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   6000
         TabIndex        =   1
         Top             =   3240
         Width           =   975
      End
      Begin VB.Label Label7 
         BackColor       =   &H00FFC0C0&
         Caption         =   "请妥善保管自己的密码."
         BeginProperty Font 
            Name            =   "楷体_GB2312"
            Size            =   14.25
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   2160
         TabIndex        =   8
         Top             =   840
         Width           =   3255
      End
      Begin VB.Label Label6 
         BackColor       =   &H00FFC0C0&
         Caption         =   "请确认新密码："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   255
         Left            =   1080
         TabIndex        =   7
         Top             =   2520
         Width           =   1695
      End
      Begin VB.Label Label1 
         BackColor       =   &H00FFC0C0&
         Caption         =   "请输入新密码："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   255
         Left            =   1080
         TabIndex        =   6
         Top             =   1800
         Width           =   1695
      End
      Begin VB.Label Label2 
         BackColor       =   &H00FFC0C0&
         Caption         =   "温馨提示："
         BeginProperty Font 
            Name            =   "楷体_GB2312"
            Size            =   14.25
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   360
         TabIndex        =   5
         Top             =   480
         Width           =   1695
      End
   End
End
Attribute VB_Name = "frm_pass"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub CmdBack_Click()
Me.Hide

End Sub

Private Sub CmdXcode_Click()

If Trim(TxtNewcode01.Text) = "" Then
     MsgBox "密码不能为空!", vbOKOnly + vbExclamation, "警告"
      TxtNewcode01.SetFocus
 Else
        
    If TxtNewcode01.Text <> TxtNewcode02.Text Then
           MsgBox "两次输入的密码不一样！", vbOKOnly + vbExclamation, "错误"
    End If
    
    Dim rst As New ADODB.Recordset
    Dim strSql As String
    strSql = "update tb_login set userpwd = " & TxtNewcode01.Text & " where userid ='" & Frm_login.txtUser.Text & " '"
    Set rst = ExecuteSql(strSql)
    MsgBox "密码修改成功!", vbOKOnly + vbExclamation, "HKJSJ052201H"
    Me.Hide
    
    End If
    
End Sub