📄 登录.frm
字号:
VERSION 5.00
Begin VB.Form Frm_Login
BorderStyle = 1 'Fixed Single
Caption = "登录"
ClientHeight = 3225
ClientLeft = 45
ClientTop = 330
ClientWidth = 5295
Icon = "登录.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3225
ScaleWidth = 5295
StartUpPosition = 2 '屏幕中心
Begin VB.CommandButton Command2
Caption = "退出"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 3240
TabIndex = 7
Top = 2520
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "登录"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 840
TabIndex = 6
Top = 2520
Width = 1215
End
Begin VB.ComboBox Combo1
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 2040
TabIndex = 5
Text = "Combo1"
Top = 1680
Width = 1695
End
Begin VB.TextBox Text2
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
IMEMode = 3 'DISABLE
Left = 2040
PasswordChar = "*"
TabIndex = 4
Text = "Text2"
Top = 1080
Width = 1695
End
Begin VB.TextBox Text1
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 2040
TabIndex = 3
Text = "Text1"
Top = 480
Width = 1695
End
Begin VB.Label Label3
Caption = "身份："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 1320
TabIndex = 2
Top = 1680
Width = 735
End
Begin VB.Label Label2
Caption = "密码："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 1320
TabIndex = 1
Top = 1080
Width = 735
End
Begin VB.Label Label1
Caption = "用户名："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 1080
TabIndex = 0
Top = 480
Width = 855
End
End
Attribute VB_Name = "Frm_Login"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim myCon As New ADODB.Connection ' 连接数据库
Dim myRs As New ADODB.Recordset '操作数据
Dim zong As Integer
Private Sub Command1_Click()
Dim sqldl As String
Dim sf As String
If zong = 3 Then '若用户输入的次数超过三次，则自动退出
Unload Me
Exit Sub
End If
myCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=信息.mdb;" '打开数据库
If Trim(Text1.Text = "") Then
MsgBox "没有输入用户名,请输入!", vbOKOnly + vbExclamation, "警告"
Text1.SetFocus
Text2.Text = ""
myCon.Close
zong = zong + 1 '累加输入次数
Exit Sub
End If
'myRs.CursorType = adOpenKeyset
'myRs.LockType = adLockOptimistic
sqldl = "select * from 用户资料 where 用户名='" & Text1.Text & "' "
myRs.Open sqldl, myCon
If myRs.EOF = True Then
MsgBox "没有这个用户,请重新输入用户名!", vbOKOnly + vbExclamation, "警告"
Text1.SetFocus
Text1.Text = ""
Text2.Text = ""
myRs.Close
myCon.Close
zong = zong + 1
Exit Sub
End If
If myRs.Fields("密码") <> Trim(Text2.Text) Then
MsgBox "密码不正确,请重新输入!", vbOKOnly + vbExclamation, "警告"
Text2.SetFocus
myRs.Close
myCon.Close
zong = zong + 1
Exit Sub
End If
If myRs.Fields("身份") <> Combo1.Text Then
MsgBox "身份不正确,请重新选择!", vbOKOnly + vbExclamation, "警告"
Combo1.SetFocus
myRs.Close
myCon.Close
zong = zong + 1
Exit Sub
End If
sf = myRs.Fields("身份")
myRs.Close
myCon.Close
XingMing = Text1.Text
Unload Me
Frm_Main.Show
If sf = "管理员" Then
Frm_Main.Mun_LiulanUser.Enabled = True
admin = 1
Else
Frm_Main.Mun_LiulanUser.Enabled = False
Frm_Main.Mun_DelUser.Enabled = False
Frm_Main.Mun_AddUser.Enabled = False
Frm_Main.Mun_AddClass.Enabled = False
Frm_Main.Mun_AddDangA.Enabled = False
Frm_Main.Mun_ShezGrean.Enabled = False
Frm_Main.Mun_AddChengJ.Enabled = False
Frm_Main.Mun_ChengJWeiG.Enabled = False
Frm_Main.Mun_AddJiaoF.Enabled = False
Frm_Main.Mun_ClassCount.Enabled = False
Frm_Main.Mun_DandACount.Enabled = False
Frm_Main.Mun_GreanCount.Enabled = False
Frm_Main.Mun_ChengJCount.Enabled = False
Frm_Main.Mun_JiaoFCount.Enabled = False
admin = 0
End If
'If sf = "管理员" Then
'admin = 1
'Else
'admin = 0
'End If
End Sub
Private Sub Command2_Click()
Dim anw As Integer
anw = MsgBox("确定要退出系统吗？", vbYesNo, "请问")
If anw = 6 Then
Unload Me
Else
Text1.Text = ""
Text2.Text = ""
Text1.SetFocus
End If
End Sub
Private Sub Form_Load()
zong = 0
Text1.Text = ""
Text2.Text = ""
Combo1.Text = ""
Combo1.AddItem ("管理员")
Combo1.AddItem ("用户")
End Sub
Private Sub Text1_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Then
Text2.SetFocus
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -