loginsys.frm

图书进销存系统里面有很的多版块是图书管理系统全集

VERSION 5.00
Begin VB.Form LoginSys 
   Caption         =   "管理员登录"
   ClientHeight    =   2190
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   3450
   Icon            =   "LoginSys.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   ScaleHeight     =   2190
   ScaleWidth      =   3450
   Begin VB.CommandButton cmdOkCancel 
      Cancel          =   -1  'True
      Caption         =   "取消(&C)"
      Height          =   375
      Index           =   1
      Left            =   1920
      TabIndex        =   5
      Top             =   1320
      Width           =   855
   End
   Begin VB.CommandButton cmdOkCancel 
      Caption         =   "确定(&E)"
      Default         =   -1  'True
      Height          =   375
      Index           =   0
      Left            =   600
      TabIndex        =   4
      Top             =   1320
      Width           =   855
   End
   Begin VB.TextBox MiMa 
      Height          =   270
      IMEMode         =   3  'DISABLE
      Left            =   1320
      PasswordChar    =   "*"
      TabIndex        =   3
      Text            =   "Text1"
      Top             =   840
      Width           =   1575
   End
   Begin VB.ComboBox ZhangHao 
      Height          =   300
      Left            =   1320
      TabIndex        =   2
      Text            =   "Combo1"
      Top             =   360
      Width           =   1575
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackColor       =   &H8000000A&
      BackStyle       =   0  'Transparent
      Caption         =   "密码"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00FF0000&
      Height          =   210
      Index           =   1
      Left            =   720
      TabIndex        =   1
      Top             =   840
      Width           =   465
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackColor       =   &H8000000A&
      BackStyle       =   0  'Transparent
      Caption         =   "管理员"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00FF0000&
      Height          =   210
      Index           =   0
      Left            =   480
      TabIndex        =   0
      Top             =   360
      Width           =   690
   End
End
Attribute VB_Name = "LoginSys"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

' **********************************************************************
'  描  述：银龙图书管理系统
'  中国VB网收集整理  http://www.ChinaVB.net
'  QQ交流群：13047826  14356878
'  发表源码或文章请发邮件到:[e-mail]
' **********************************************************************Dim i As Integer

Dim db As Database
Dim rst As Recordset
Dim Asc() As Integer
Dim Rec As Integer


Private Sub cmdOkCancel_Click(Index As Integer)

Select Case Index
    Case 0
        If MiMa.Text = "" Or ZhangHao.Text = "" Then
            MsgBox "请选择用户名或输入密码!", 0 + 48, "提示"
            MiMa.SetFocus
            Exit Sub
        End If
        i = 0
        If Val(MiMa.Text) = Asc(ZhangHao.ListIndex) Then
            Mainfrm.Show
            Unload Me
        Else
            MsgBox "密码错误,请重试！", 0 + 16, "错误"
            MiMa.SetFocus
            Exit Sub
        End If
Case 1
    Unload Me
End Select
End Sub
Private Sub Form_Load()

Me.Top = (Screen.Height - Me.Height) \ 2
Me.Left = (Screen.Width - Me.Width) \ 2

'设置数据库路径
DBpath = App.Path + "\DataBase\Data.mdb"
'连接数据库，打开表用户
Set db = Workspaces(0).OpenDatabase(DBpath, False, False, ";pwd=" & "tsglxt")
Set rst = db.OpenRecordset("用户", dbOpenTable)
'使管理员组合框显示数据库的名称字段
rst.MoveLast
Rec = rst.RecordCount
ReDim Asc(Rec - 1)
rst.MoveFirst
For i = 1 To Rec
    ZhangHao.AddItem rst.Fields("名称")
    Asc(i - 1) = Val(rst.Fields("密码"))
    rst.MoveNext
    If rst.EOF Then Exit For
Next
ZhangHao.Text = ""
MiMa.Text = ""
End Sub