分析 源码,求助
我做了一个登陆界面,有点问题。数据库为name=11,password=11,第一次输入11,12,告诉我“密码错误”,接着输入11、11,程序提示出错。
代码:(如何解决)
Dim con As Connection
Dim rst As Recordset
Private Sub cmdOK_Click()
If Trim(txtName.Text = "") Then
MsgBox "没有这个用户,请重新输入用户名!", vbOKOnly + vbExclamation, "警告"
txtPwd.Text = ""
ElseIf txtPwd.Text = "" Then
MsgBox "密码不能为空!", vbOKOnly + vbExclamation, "警告"
Else
rst.Open ("Select * from login where Name='" & Trim(txtName.Text) & "'")
If rst.EOF = True Then
MsgBox "没有这个用户,请重新输入用户名!", vbOKOnly + vbExclamation, "警告"
txtName.Text = ""
txtPwd.Text = ""
Else
If Trim(rst.Fields(1)) = Trim(txtPwd.Text) Then
MsgBox ("ok")
Else
MsgBox "输入密码不正确,请重新输入!", vbOKOnly + vbExclamation, "警告"
txtPwd.Text = ""
End If
End If
End If
End Sub
Private Sub Form_Load()
Set con = New ADODB.Connection
Set rst = New ADODB.Recordset
With con
.Provider = "Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db3.mdb;Persist Security Info=False"
.Open
End With
rst.CursorLocation = adUseClient
rst.CursorType = adOpenDynamic
rst.LockType = adLockOptimistic
rst.ActiveConnection = con
End Sub
Private Sub Cmdexit_Click()
End
End Sub