frmlogin.frm

北大青鸟教学管理系统是学习规范编程范本.功能非常完备,代码编写有章法,不可多得

VERSION 5.00
Begin VB.Form frmlogin 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "用户登录"
   ClientHeight    =   2460
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   3795
   Icon            =   "frmlogin.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Picture         =   "frmlogin.frx":0442
   ScaleHeight     =   2460
   ScaleWidth      =   3795
   StartUpPosition =   2  '屏幕中心
   Begin VB.ComboBox cmbUserName 
      Height          =   300
      ItemData        =   "frmlogin.frx":6B6F
      Left            =   1440
      List            =   "frmlogin.frx":6B71
      Style           =   2  'Dropdown List
      TabIndex        =   2
      ToolTipText     =   "请选择用户名"
      Top             =   960
      Width           =   2055
   End
   Begin VB.TextBox txtPassword 
      Height          =   345
      IMEMode         =   3  'DISABLE
      Left            =   1440
      MaxLength       =   32
      PasswordChar    =   "*"
      TabIndex        =   0
      ToolTipText     =   "请输入密码"
      Top             =   1500
      Width           =   2055
   End
   Begin VB.CommandButton cmdLogon 
      Caption         =   "登录"
      Default         =   -1  'True
      Height          =   350
      Left            =   1440
      TabIndex        =   1
      ToolTipText     =   "系统登录"
      Top             =   2040
      Width           =   855
   End
   Begin VB.CommandButton cmdExit 
      Caption         =   "关闭"
      Height          =   350
      Left            =   2640
      TabIndex        =   3
      ToolTipText     =   "退出程序"
      Top             =   2040
      Width           =   855
   End
   Begin VB.Line Line1 
      X1              =   0
      X2              =   3960
      Y1              =   650
      Y2              =   650
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "密  码"
      Height          =   180
      Left            =   240
      TabIndex        =   5
      Top             =   1582
      Width           =   540
   End
   Begin VB.Label Label2 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "用户名"
      Height          =   180
      Left            =   240
      TabIndex        =   4
      Top             =   1020
      Width           =   540
   End
End
Attribute VB_Name = "frmlogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private Sub cmdExit_Click()
    End
End Sub

Private Sub cmdLogon_Click()
    If Login(cmbUserName.Text, txtPassword.Text) Then
        Unload Me
        Load frmMain
        frmMain.Show
        Rst.Close
    End If
    
End Sub
Private Sub Form_Load()     '初始化用户列表
    Set Rst = Nothing
    
    Call Fun_Rst("select * from sysuser")
    Rst.MoveFirst
    Do While Rst.EOF = False
        cmbUserName.AddItem Rst.Fields("UserName").Value
        Rst.MoveNext
    Loop
    cmbUserName.ListIndex = 0
End Sub