frmsystemusermodify.frm

教务管理系统,用VB 完成,以SQL SERVER 2000作为后台数据库

VERSION 5.00
Object = "{0BA686C6-F7D3-101A-993E-0000C0EF6F5E}#2.0#0"; "THREED20.OCX"
Begin VB.Form frmSystemUserModify 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "密码修改"
   ClientHeight    =   2955
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   5205
   Icon            =   "frmSystemUserModify.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2955
   ScaleWidth      =   5205
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  'CenterScreen
   Begin VB.CommandButton Command1 
      Caption         =   "删除用户"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   345
      Left            =   3840
      TabIndex        =   6
      Top             =   1450
      Width           =   1215
   End
   Begin VB.CommandButton cmdExit 
      Caption         =   "取消"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   345
      Left            =   3840
      TabIndex        =   5
      Top             =   1010
      Width           =   1215
   End
   Begin VB.CommandButton cmdDenJ 
      BackColor       =   &H00C0C0C0&
      Caption         =   "确定"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   345
      Left            =   3840
      MaskColor       =   &H00FFFFFF&
      Style           =   1  'Graphical
      TabIndex        =   4
      Top             =   570
      UseMaskColor    =   -1  'True
      Width           =   1215
   End
   Begin Threed.SSFrame SSFrame1 
      Height          =   2655
      Left            =   240
      TabIndex        =   0
      Top             =   120
      Width           =   3375
      _ExtentX        =   5953
      _ExtentY        =   4683
      _Version        =   131073
      Font3D          =   1
      ForeColor       =   0
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Caption         =   "用户密码"
      ShadowStyle     =   1
      Begin VB.ComboBox cboUser 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00000000&
         Height          =   360
         IMEMode         =   2  'OFF
         Left            =   1530
         TabIndex        =   1
         Top             =   600
         Width           =   1605
      End
      Begin VB.TextBox txtNewPwd 
         ForeColor       =   &H00000000&
         Height          =   330
         IMEMode         =   3  'DISABLE
         Left            =   1530
         PasswordChar    =   "*"
         TabIndex        =   3
         Top             =   1710
         Width           =   1605
      End
      Begin VB.TextBox txtOldPwd 
         ForeColor       =   &H00000000&
         Height          =   330
         IMEMode         =   3  'DISABLE
         Left            =   1530
         PasswordChar    =   "*"
         TabIndex        =   2
         Top             =   1155
         Width           =   1605
      End
      Begin VB.Label Label3 
         Caption         =   "新密码："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00000000&
         Height          =   375
         Left            =   330
         TabIndex        =   9
         Top             =   1770
         Width           =   1125
      End
      Begin VB.Label Label2 
         Caption         =   "旧密码："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00000000&
         Height          =   375
         Left            =   330
         TabIndex        =   8
         Top             =   1170
         Width           =   1125
      End
      Begin VB.Label Label1 
         Caption         =   "用  户："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00000000&
         Height          =   375
         Left            =   330
         TabIndex        =   7
         Top             =   600
         Width           =   1125
      End
   End
End
Attribute VB_Name = "frmSystemUserModify"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim Recuser As Recordset

Private Sub cmdDenJ_Click()
'用户名未填写
If Len(CboUSER) = 0 Then
    MsgBox "请填写用户名！", vbExclamation + vbOKOnly, "信息"
    Exit Sub
End If
'旧密码不正确
Recuser.FindFirst "user='" + Trim(CboUSER) + "' and pwd='" + Trim(txtOldPwd) + "'"
If Recuser.NoMatch Then
    MsgBox "旧密码不正确！", vbExclamation + vbOKOnly, "信息"
    txtOldPwd = ""
    txtOldPwd.SetFocus
Else
    If Len(txtNewPwd) = 0 Then
        MsgBox "密码不能为空！", vbExclamation + vbOKOnly, "信息"
        txtNewPwd.SetFocus
    Else
        Recuser.Edit
        Recuser.Fields("pwd") = Trim(txtNewPwd)
        Recuser.Update
        MsgBox "祝贺您！修改成功", vbExclamation + vbOKOnly, "信息"
        CboUSER = ""
        txtOldPwd = ""
        txtNewPwd = ""
        Unload Me
    End If
End If

End Sub

Private Sub cmdExit_Click()
Unload Me
End Sub


Private Sub Command1_Click()
On Error Resume Next
If Len(CboUSER) = 0 Then Exit Sub
If CboUSER.Text = "系统管理员" Then Exit Sub
Recuser.FindFirst "user='" + Trim(CboUSER) + "'"
Kill App.Path & "\system\" & Trim(CboUSER) & ".txt"
Recuser.Delete
CboUSER.Clear
Recuser.MoveLast
Recuser.MoveFirst
While Not Recuser.EOF
  CboUSER.AddItem Recuser.Fields("user")
  Recuser.MoveNext
Wend

CboUSER.SetFocus

End Sub

Private Sub Form_Load()
Set Recuser = Dbstudent.OpenRecordset("select * from user", dbOpenDynaset)
Recuser.MoveLast
Recuser.MoveFirst
While Not Recuser.EOF
  CboUSER.AddItem Recuser.Fields("user")
  Recuser.MoveNext
Wend
End Sub

Private Sub txtNewPwd_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Call cmdDenJ_Click
End If

End Sub