frmssecrect.frm

一款非常适合中小学教学任务不是很繁重的管理程序

VERSION 5.00
Object = "{3A6644DE-3402-11D9-9DE7-C33FAA87690A}#1.0#0"; "WinXPCEngine.ocx"
Begin VB.Form frmSSecrect 
   ClientHeight    =   8310
   ClientLeft      =   60
   ClientTop       =   60
   ClientWidth     =   9660
   ControlBox      =   0   'False
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   Picture         =   "frmSSecrect.frx":0000
   ScaleHeight     =   8310
   ScaleWidth      =   9660
   WindowState     =   2  'Maximized
   Begin WinXPC_Engine.WindowsXPC WindowsXPC1 
      Left            =   2970
      Top             =   1935
      _ExtentX        =   6588
      _ExtentY        =   1085
      ColorScheme     =   2
      Common_Dialog   =   0   'False
   End
   Begin VB.TextBox txtNew 
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   480
      IMEMode         =   3  'DISABLE
      Left            =   3960
      PasswordChar    =   "*"
      TabIndex        =   7
      Top             =   3780
      Width           =   2940
   End
   Begin VB.TextBox txtRNew 
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   480
      IMEMode         =   3  'DISABLE
      Left            =   3960
      PasswordChar    =   "*"
      TabIndex        =   6
      Top             =   4590
      Width           =   2940
   End
   Begin VB.TextBox txtSecret 
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   405
      IMEMode         =   3  'DISABLE
      Left            =   3960
      PasswordChar    =   "*"
      TabIndex        =   2
      Top             =   3060
      Width           =   2940
   End
   Begin VB.CommandButton cmdOk 
      Caption         =   "确定"
      Height          =   420
      Left            =   3960
      TabIndex        =   1
      Top             =   5625
      Width           =   1320
   End
   Begin VB.CommandButton cmdCansel 
      Caption         =   "取消"
      Height          =   420
      Left            =   5535
      TabIndex        =   0
      Top             =   5625
      Width           =   1320
   End
   Begin VB.Label Label3 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "新密码"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   12
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00400000&
      Height          =   300
      Left            =   2880
      TabIndex        =   5
      Top             =   4005
      Width           =   765
   End
   Begin VB.Label Label2 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "确认密码"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   12
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00400000&
      Height          =   300
      Left            =   2880
      TabIndex        =   4
      Top             =   4725
      Width           =   1020
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "原密码"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   12
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00400000&
      Height          =   300
      Left            =   2880
      TabIndex        =   3
      Top             =   3105
      Width           =   765
   End
End
Attribute VB_Name = "frmSSecrect"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim strSql As String
Dim RS As ADODB.Recordset
Private Sub cmdCansel_Click()
Unload Me
End Sub
Private Sub cmdOk_Click()
'登陆
strSql = "select 密码 from 密码表 where 用户='admin'"
Set RS = dbSelect(strSql)
If Me.txtSecret.Text = RS.Fields(0) Then
    If Me.txtNew.Text = Me.txtRNew.Text Then
        strSql = "update 密码表 set 密码='" & Me.txtNew.Text
        strSql = strSql & "' where 用户='admin'"
        dbOperate strSql
        MsgBox "成功", vbOKOnly + vbExclamation, "提示"
    Else
        MsgBox "确认密码错误!", vbExclamationvbo + vbOKOnly, "提示"
    End If
Else
    Me.txtSecret.SetFocus
    MsgBox "密码错误!", vbOKOnly + vbExclamation, "提示"
End If
End Sub
Private Sub Form_Load()
Me.WindowsXPC1.InitSubClassing
End Sub