【VB开源代码栏目提醒】:以下是网学会员为您推荐的VB开源代码-FMLOGIN.frm,希望本篇文章对您学习有所帮助。
VERSION 5.00
Begin VB.Form FMLOGIN
BorderStyle = 3 'Fixed Dialog
Caption = "登录"
ClientHeight = 1545
ClientLeft = 2835
ClientTop = 3480
ClientWidth = 3855
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 912.837
ScaleMode = 0 'User
ScaleWidth = 3619.636
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin VB.TextBox txtUserName
Height = 345
Left = 1410
TabIndex = 1
Top = 120
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 = 2220
TabIndex = 5
Top = 1020
Width = 1140
End
Begin VB.TextBox txtPassword
Height = 345
IMEMode = 3 'DISABLE
Left = 1410
PasswordChar = "*"
TabIndex = 3
Top = 525
Width = 2325
End
Begin
VB.Label lblLabels
Caption = "用户名(&U)"
Height = 270
Index = 0
Left = 105
TabIndex = 0
Top = 150
Width = 1200
End
Begin VB.Label lblLabels
Caption = "密码(&P)"
Height = 270
Index = 1
Left = 105
TabIndex = 2
Top = 540
Width = 1080
End
End
Attribute VB_Name = "FMLOGIN"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Public LoginSucceeded As Boolean
Public CN As New ADODB.Connection, RS As New ADODB.Recordset
Public SQL As String
Const DBPATH = "./POS.MDB"
Const ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPATH
Private Sub cmdCancel_Click()
'设定全局变量为 false 来代表
'失败的登录
LoginSucceeded = False
Me.Hide
End Sub
Private Sub cmdOK_Click()
CN.Open ConnString
SQL = "SELECT * FROM BMAN "
SQL = SQL & "WHERE BNENO = '" & txtUserName & "' "
RS.Open SQL, ConnString, , , adCmdText
If RS.EOF = False Then
'检查密码的正确性
If txtPass
word = RS("BNPWD") Then
FMMAIN.USERNAME = RS("BNNAM")
SQL = " INSERT INTO SYSLOG "
SQL = SQL & "(SGKIN, PAIDE, BNENO, SGDAT, SGTME, SGMRK)"
SQL = SQL & " VALUES ( "
SQL = SQL & " 'LOG', "
SQL = SQL & " '001', "
SQL = SQL & " '" & txtUserName & "', "
SQL = SQL & " '" & Date & "' , "
SQL = SQL & " '" & Right(Time, 5) & "' , "
SQL = SQL & " '后台' ) "
CN.Execute SQL
LoginSucceeded = True
Me.Hide
Else
MsgBox "密码错误,请重新输入!", , "登录"
txtPassword.SetFocus
SendKeys "{Home}+{End}"
End If
Else
MsgBox "无此用户代号!"
txtUserName.SetFocus
SendKeys "{Home}+{End}"
End If
RS.Close
CN.Close
End Sub