?? 登錄.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 ' 連接數(shù)據(jù)庫
Dim myRs As New ADODB.Recordset '操作數(shù)據(jù)
Dim zong As Integer
Private Sub Command1_Click()
Dim sqldl As String
Dim sf As String
If zong = 3 Then '若用戶輸入的次數(shù)超過三次，則自動退出
Unload Me
Exit Sub
End If
myCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=信息.mdb;" '打開數(shù)據(jù)庫
If Trim(Text1.Text = "") Then
MsgBox "沒有輸入用戶名,請輸入!", vbOKOnly + vbExclamation, "警告"
Text1.SetFocus
Text2.Text = ""
myCon.Close
zong = zong + 1 '累加輸入次數(shù)
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("確定要退出系統(tǒng)嗎？", 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 + -