身份登录.frm

小区物业管理系统vb开发的,曾用于本科毕业设计

VERSION 5.00
Object = "{E95A2510-F3D1-416D-823B-4F840FE98091}#3.0#0"; "Command.ocx"
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form 身份登录 
   BackColor       =   &H00FFFFFF&
   BorderStyle     =   1  'Fixed Single
   Caption         =   "身份登录验证"
   ClientHeight    =   3315
   ClientLeft      =   4905
   ClientTop       =   3705
   ClientWidth     =   4140
   LinkTopic       =   "Form2"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3315
   ScaleWidth      =   4140
   Begin MSComCtl2.MonthView MonthView1 
      Height          =   2220
      Left            =   0
      TabIndex        =   6
      Top             =   1080
      Width           =   4065
      _ExtentX        =   7170
      _ExtentY        =   3916
      _Version        =   393216
      ForeColor       =   -2147483630
      BackColor       =   16777215
      Appearance      =   1
      StartOfWeek     =   63569921
      CurrentDate     =   39480
   End
   Begin CSCommand.Command Cmdexit 
      Height          =   375
      Left            =   3000
      TabIndex        =   5
      Top             =   600
      Width           =   1095
      _ExtentX        =   1931
      _ExtentY        =   661
      Icon            =   "身份登录.frx":0000
      Caption         =   " 退出"
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
   End
   Begin CSCommand.Command Cmdok 
      Height          =   375
      Left            =   3000
      TabIndex        =   4
      Top             =   120
      Width           =   1095
      _ExtentX        =   1931
      _ExtentY        =   661
      Icon            =   "身份登录.frx":0E52
      Caption         =   " 确定"
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
   End
   Begin VB.TextBox Txtpwd 
      Height          =   375
      IMEMode         =   3  'DISABLE
      Left            =   1200
      PasswordChar    =   "*"
      TabIndex        =   3
      Top             =   600
      Width           =   1695
   End
   Begin VB.TextBox Txtname 
      Height          =   390
      Left            =   1200
      TabIndex        =   2
      Top             =   120
      Width           =   1695
   End
   Begin VB.Image Image1 
      Height          =   270
      Left            =   120
      Picture         =   "身份登录.frx":1CA4
      Top             =   120
      Width           =   420
   End
   Begin VB.Image Image2 
      Height          =   285
      Left            =   120
      Picture         =   "身份登录.frx":53E6
      Top             =   600
      Width           =   450
   End
   Begin VB.Label Label2 
      BackColor       =   &H00FFFFFF&
      Caption         =   "密码:"
      Height          =   255
      Left            =   720
      TabIndex        =   1
      Top             =   600
      Width           =   495
   End
   Begin VB.Label Label1 
      BackColor       =   &H00FFFFFF&
      Caption         =   "姓名:"
      Height          =   255
      Left            =   720
      TabIndex        =   0
      Top             =   120
      Width           =   495
   End
End
Attribute VB_Name = "身份登录"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Const Maxlogtimes As Integer = 3
Dim intlogtimes As Integer
Dim objadmin As Recordset


Private Sub Cmdexit_Click()
End
End Sub

Private Sub Cmdok_Click()
If Trim(Txtname) = "" Then
   MsgBox "请输入用户名!", vbExclamation, "温馨提示"
   Txtname = ""
   Txtname.SetFocus
   Exit Sub
End If
If Trim(Txtpwd) = "" Then
   MsgBox "请输入密码!", vbExclamation, "温馨提示"
   Txtpwd = ""
   Txtpwd.SetFocus
   Exit Sub
End If
'登录身份验证
Static intlogtimes As Integer
intlogtimes = intlogtimes + 1
If intlogtimes > Maxlogtimes Then
   MsgBox "你已超过允许的登录验证次数!" & vbCr & "应用程序将结束!", vbCritical, "温馨提示"
   End
End If

Dim strpwdfield As String
With objadmin
     If .RecordCount > 0 Then
        .MoveFirst
        If Txtname <> "" Then
           .Find "管理员='" & Trim(Txtname) & "'"
           strpwdfield = "密码"
        End If
           
        If .EOF Then
           MsgBox "用户名输入错误!", vbCritical, "温馨提示"
           Txtname.SetFocus
           Txtname.SelStart = 0
           Txtname.SelLength = Len(Txtname)
        ElseIf .Fields(strpwdfield) <> Trim(Txtpwd) Then
           MsgBox "密码错误,请重新输入!", vbCritical, "温馨提示"
           Txtpwd.SetFocus
           Txtpwd = ""
        Else
        MsgBox "欢迎使用小区物业管理系统", vbInformation, "登录成功"
        Unload Me
        物业管理系统.Show
        End If
     End If
End With
'Set objadmin = Nothing
End Sub

Private Sub Form_Load()
'清空用户名和口令的文本框
 Txtname = ""
 Txtpwd = ""
 
'建立数据库联接
Set objcn = New Connection                   '实例化联接对象
  With objcn                                 '建立数据库联接
        .Provider = "SQLOLEDB"
        .ConnectionString = "User ID=sa;PWD=sa;Data Source=(local);" & _
                            "Initial Catalog=物业管理系统"
        .Open
  End With
  
Set objadmin = New Recordset
With objadmin
     Set .ActiveConnection = objcn
         .CursorLocation = adUseClient
         .CursorType = adOpenStatic
         .LockType = adLockOptimistic
         .Open " select *  from 管理员信息表 "
End With

End Sub

Private Sub form_unload(cancel As Integer)
Set objadmin = Nothing
End Sub