16,553
社区成员
发帖
与我相关
我的任务
分享
Public Class Form1
Dim conn As ADODB.Connection
Dim reco As ADODB.Recordset
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sql As String
Dim connstr As String
connstr = "provider=microsoft.jet.oledb.4.0;data source=user_login.mdb"
sql = "select * from account where 用户名=xx"
conn.Open(connstr)
reco.Open(sql, conn, 1, 1)
If reco.Recordset.eof And reco.Recordset.bof Then
MsgBox("用户不存在!", 16)
Else
If TextBox1.Text = reco.Recordset("密码").value Then
MsgBox("登录成功!", 64)
Else
MsgBox("密码错误!", 32)
End If
End If
reco.Recordset.Close()
End Sub
End Class
Public Class Form1
Dim conn As ADODB.Connection
Dim reco As ADODB.Recordset
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sql As String
Dim connstr As String
set conn =new ADODB.Connection //没有实例化
set reco =new ADODB.RecordSet
connstr = "provider=microsoft.jet.oledb.4.0;data source=user_login.mdb"
sql = "select * from account where 用户名=xx"
conn.Open(connstr)
reco.Open(sql, conn, 1, 1)
If reco.Recordset.eof And reco.Recordset.bof Then
MsgBox("用户不存在!", 16)
Else
If TextBox1.Text = reco.Recordset("密码").value Then
MsgBox("登录成功!", 64)
Else
MsgBox("密码错误!", 32)
End If
End If
reco.Recordset.Close()
End Sub
End Class