frmlogin.frm

鲜花订购系统(这是单机版的),采用VB+Access编写

VERSION 5.00
Begin VB.Form frmlogin 
   BackColor       =   &H00C0C000&
   Caption         =   "登陆窗口"
   ClientHeight    =   3480
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5535
   FillColor       =   &H00FFFFFF&
   ForeColor       =   &H00FFFFFF&
   Icon            =   "frmlogin.frx":0000
   LinkTopic       =   "Form1"
   Moveable        =   0   'False
   ScaleHeight     =   3480
   ScaleWidth      =   5535
   StartUpPosition =   1  '所有者中心
   Begin VB.CommandButton Command2 
      BackColor       =   &H00C0FFC0&
      Caption         =   "取消(&E)"
      Height          =   375
      Left            =   3240
      TabIndex        =   5
      Top             =   2400
      Width           =   855
   End
   Begin VB.CommandButton Command1 
      BackColor       =   &H00C0FFC0&
      Caption         =   "确定(&F)"
      Default         =   -1  'True
      Height          =   375
      Left            =   2280
      TabIndex        =   4
      Top             =   2400
      Width           =   855
   End
   Begin VB.TextBox Text1 
      BackColor       =   &H00C0C000&
      Height          =   375
      IMEMode         =   3  'DISABLE
      Left            =   2280
      MaxLength       =   8
      PasswordChar    =   "*"
      TabIndex        =   3
      Top             =   1560
      Width           =   1815
   End
   Begin VB.ComboBox cmb1 
      BackColor       =   &H00C0C000&
      Height          =   300
      Left            =   2280
      Style           =   2  'Dropdown List
      TabIndex        =   1
      Top             =   840
      Width           =   1815
   End
   Begin VB.Label Label2 
      BackColor       =   &H00C0C000&
      Caption         =   "登陆密码"
      BeginProperty Font 
         Name            =   "楷体_GB2312"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   840
      TabIndex        =   2
      Top             =   1560
      Width           =   1215
   End
   Begin VB.Label Label1 
      BackColor       =   &H00C0C000&
      Caption         =   "登陆名称"
      BeginProperty Font 
         Name            =   "楷体_GB2312"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   840
      TabIndex        =   0
      Top             =   840
      Width           =   1335
   End
End
Attribute VB_Name = "frmlogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'根据登陆姓名用记录集查找相对应的密码，记录下来，进行验证
Private Sub Command1_Click()
Set rs1 = Nothing
Dim pwd As String
Dim strq2 As String
strq2 = "select mpwd from manger where mname='" & cmb1.Text & "'"
rs1.Open strq2, g_dbcon, adOpenDynamic, adLockOptimistic, -1
pwd = rs1.Fields("mpwd").Value
If pwd = Text1.Text Then
Unload Me
MDIForm1.Show
Else
If MsgBox("您输入的密码不正确，你要重新输入吗？", vbQuestion + vbYesNo, "登陆失败") = vbYes Then
  Text1.SetFocus
Else
Unload Me
End If
End If
End Sub

Private Sub Command2_Click()
Unload Me
End Sub
'把登陆姓名显示到组合框中
Private Sub Form_Load()
Command1.Enabled = False
Call ConnectToServer
Set rs1 = Nothing
Dim strq1 As String
strq1 = "select * from manger"
rs1.Open strq1, g_dbcon, adOpenDynamic, adLockOptimistic, -1
Do While Not rs1.EOF = True
cmb1.AddItem rs1.Fields("mname").Value
rs1.MoveNext
Loop
cmb1.ListIndex = 0
End Sub

Private Sub Text1_Change()
Command1.Enabled = True
End Sub