frmlogin.frm

有一些基本的操作

VERSION 5.00
Begin VB.Form frmLogin 
   Caption         =   "登陆"
   ClientHeight    =   3555
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   4785
   LinkTopic       =   "Form1"
   ScaleHeight     =   3555
   ScaleWidth      =   4785
   Begin VB.CommandButton btnClear 
      Caption         =   "取消"
      Height          =   375
      Left            =   2640
      TabIndex        =   7
      Top             =   2280
      Width           =   855
   End
   Begin VB.CommandButton btnSubmit 
      Caption         =   "确定"
      Height          =   375
      Left            =   1200
      TabIndex        =   6
      Top             =   2280
      Width           =   855
   End
   Begin VB.TextBox txbPwd 
      Height          =   375
      IMEMode         =   3  'DISABLE
      Left            =   1800
      PasswordChar    =   "*"
      TabIndex        =   5
      Top             =   1680
      Width           =   1335
   End
   Begin VB.TextBox txbName 
      Height          =   375
      Left            =   1800
      TabIndex        =   4
      Top             =   1080
      Width           =   1335
   End
   Begin VB.TextBox txbUserId 
      Height          =   375
      Left            =   1800
      TabIndex        =   3
      Top             =   480
      Width           =   1335
   End
   Begin VB.Label Label1 
      Caption         =   "初始用户为：1  密码为：sys"
      Height          =   375
      Left            =   1200
      TabIndex        =   8
      Top             =   3000
      Width           =   2775
   End
   Begin VB.Label lblPwd 
      Caption         =   "密码"
      Height          =   255
      Left            =   1080
      TabIndex        =   2
      Top             =   1800
      Width           =   615
   End
   Begin VB.Label lblName 
      Caption         =   "用户名"
      Height          =   255
      Left            =   1080
      TabIndex        =   1
      Top             =   1200
      Width           =   615
   End
   Begin VB.Label lblUserId 
      Caption         =   "用户号"
      Height          =   255
      Left            =   1080
      TabIndex        =   0
      Top             =   600
      Width           =   615
   End
End
Attribute VB_Name = "frmLogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
    '登陆的用户名
    Public UserName As String
    '登陆的用户密码
    Private UserPwd As String


Private Sub btnClear_Click()
        '关闭登陆对话框
        Me.Visible = False
        '关闭整个程序
        End
End Sub

Private Sub btnSubmit_Click()
        '判断用户输入密码的合法性
        If StrComp(Trim(UserPwd), Trim(txbPwd.Text)) = 0 _
        And UserPwd <> "" Then
            '合法用户
            bResult = True
            UserName = Me.txbName.Text
            Unload Me
        Else
            '密码错误
            bResult = False
            MsgBox "请确认你的用户名或密码是否正确"
        End If
End Sub

Private Sub Form_Load()

End Sub

Private Sub txbUserId_LostFocus()

        '定义一个数据访问类的对象
        Dim db As New DataBases
        Dim rs As ADODB.Recordset
        '根据输入的用户ID进行查询
        Set rs = db.RunSelectSQL _
        ("select 密码,姓名 from 用户清单 where 用户编号 = '" _
        + Me.txbUserId.Text + "'")
        '判断用户ID是否存在
        If rs.RecordCount = 0 Then
            '用户ID不存在
            Me.txbUserId.Text = ""
            Me.txbPwd.Text = ""
            Me.txbName.Text = ""
        Else
            '用户ID存在
            UserId = Me.txbUserId.Text
            '获得用户的密码级用户名
            UserPwd = rs("密码")
            txbName.Text = rs("姓名")
        End If

End Sub