?? frmlogin.frm
字號(hào):
VERSION 5.00
Begin VB.Form frmLogin
BorderStyle = 3 'Fixed Dialog
Caption = "登錄"
ClientHeight = 1755
ClientLeft = 2835
ClientTop = 3480
ClientWidth = 4410
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 1036.912
ScaleMode = 0 'User
ScaleWidth = 4140.751
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin VB.TextBox txtUserName
Height = 345
Left = 1290
TabIndex = 1
Text = "huzi"
Top = 135
Width = 2325
End
Begin VB.CommandButton cmdOK
Caption = "確定"
Default = -1 'True
Height = 390
Left = 495
TabIndex = 4
Top = 1020
Width = 1140
End
Begin VB.CommandButton cmdCancel
Cancel = -1 'True
Caption = "取消"
Height = 390
Left = 2100
TabIndex = 5
Top = 1020
Width = 1140
End
Begin VB.TextBox txtPassword
Height = 345
IMEMode = 3 'DISABLE
Left = 1290
PasswordChar = "*"
TabIndex = 3
Text = "0"
Top = 525
Width = 2325
End
Begin VB.Label lblLabels
Caption = "用戶名稱(&U):"
Height = 270
Index = 0
Left = 105
TabIndex = 0
Top = 150
Width = 1080
End
Begin VB.Label lblLabels
Caption = "密碼(&P):"
Height = 270
Index = 1
Left = 120
TabIndex = 2
Top = 540
Width = 1080
End
End
Attribute VB_Name = "frmLogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Public LoginSucceeded As Boolean
Private Sub cmdCancel_Click()
LoginSucceeded = False
Me.Hide
End Sub
Private Sub cmdOK_Click()
If txtUserName.Text = "administer" Then
LoginSucceeded = check(txtUserName, txtPassword)
If (LoginSucceeded = True) Then
yhid = txtUserName
admi = True
Unload frmLogin
MDIForm1.Show
End If
Else
LoginSucceeded = check(txtUserName, txtPassword)
If (LoginSucceeded = True) Then
admi = False
yhid = txtUserName
Me.Hide
MDIForm1.Show
End If
End If
End Sub
Function check(userid As String, txtpwd As String) As Boolean
Dim idinfo As Recordset
Dim sqlstr As String
sqlstr = "select id, pw from mmb where id='" & userid & "'"
Set idinfo = db.OpenRecordset(sqlstr, dbOpenSnapshot, dbReadOnly)
If (idinfo.RecordCount = 0) Then
MsgBox "無此用戶 ", , "登陸 "
check = False
Else
If (idinfo.Fields("pw").Value = Trim(txtpwd)) Then
check = True
Else
MsgBox "無效的密碼,請(qǐng)重試 ", , "登陸 "
check = False
End If
End If
idinfo.Close
End Function
Private Sub Form_Load()
Call opendb
End Sub
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -