![vb用户怎么登录界面?用户登陆的代码是多少?,第1张 vb用户怎么登录界面?用户登陆的代码是多少?,第1张](/aiimages/vb%E7%94%A8%E6%88%B7%E6%80%8E%E4%B9%88%E7%99%BB%E5%BD%95%E7%95%8C%E9%9D%A2%EF%BC%9F%E7%94%A8%E6%88%B7%E7%99%BB%E9%99%86%E7%9A%84%E4%BB%A3%E7%A0%81%E6%98%AF%E5%A4%9A%E5%B0%91%EF%BC%9F.png)
vb登陆程序源代码\x0d\x0a\x0d\x0a你可以这样做建一个模块在里面输入下列\x0d\x0aPublic conn As ADODB.Connection\x0d\x0aSub main()\x0d\x0aSet conn = New ADODB.Connection\x0d\x0a conn.ConnectionString = "Provider=SQLOLEDB.1Persist Security Info=False" _\x0d\x0a + "User ID=sapassword=saInitial Catalog=您的数据库名Data Source=127.0.0.1"\x0d\x0aconn.Open\x0d\x0afrom1.Show ’登录
界面\x0d\x0aEnd Sub\x0d\x0a\x0d\x0a再在登录界面“确定”下写入如下代码:\x0d\x0aPrivate Sub Command1_Click()\x0d\x0a If id.Text = "" Then\x0d\x0aMsgBox "用户名不能为空!", vbOKOnly + vbInformation, "友情提示"\x0d\x0aid.SetFocus\x0d\x0aExit Sub\x0d\x0aEnd If\x0d\x0aIf password.Text = "" Then\x0d\x0aMsgBox "
密码不能为空!", vbOKOnly + vbInformation, "友情提示"\x0d\x0apassword.SetFocus\x0d\x0aExit Sub\x0d\x0aEnd If\x0d\x0a\x0d\x0aDim strSQl As String\x0d\x0astrSQl = "select * from Users where users_name='" &Trim$(id.Text) &"' and password='" &Trim$(password.Text) &"' "\x0d\x0a\x0d\x0aDim str As New ADODB.Recordset\x0d\x0aSet str = New ADODB.Recordset\x0d\x0astr.CursorLocation = adUseClient\x0d\x0astr.Open strSQl, conn, adOpenStatic, adLockReadOnly\x0d\x0a\x0d\x0aWith str\x0d\x0aIf .State = adStateOpen Then .Close\x0d\x0a.Open strSQl\x0d\x0aIf .EOF Then\x0d\x0aTry_times = Try_times + 1\x0d\x0aIf Try_times >= 3 Then\x0d\x0aMsgBox "您已经三次尝试进入本系统,均不成功,系统将自动关闭", vbOKOnly + vbCritical, "警告"\x0d\x0aUnload Me\x0d\x0aElse\x0d\x0aMsgBox "对不起,用户名不存在或密码
错误 !", vbOKOnly + vbQuestion, "警告"\x0d\x0aid.SetFocus\x0d\x0aid.Text = ""\x0d\x0apassword.Text = ""\x0d\x0aEnd If\x0d\x0aElse\x0d\x0a\x0d\x0aUnload Me\x0d\x0a\x0d\x0a Form2.Show’登录进入的另一个界面\x0d\x0a\x0d\x0aEnd If\x0d\x0aEnd With\x0d\x0a\x0d\x0aEnd SubDim AAA As String
Private Sub Command1_Click()
Dim aa, bb
aa = "admin" '账号
bb = "admin888" '密码
AAA = Val(AAA) + 1 '记录登录次数
If Val(AAA) >= 3 Then '等于大于3次,提示并退出程序
MsgBox "你已经错误输入三次!"
End
End If
If Text1 = aa And Text2 = bb Then '如果输入正确
MsgBox "登录成功!"
Me.Hide
form2.Show '登录成功后,转到form2界面
Else '如果输入错误
MsgBox "账号或密码输入错误!"
End If
End Sub
Private Sub Form_Load()
Label1 = "欢迎光临!"
End Sub
评论列表(0条)