Public Function cls_sqlmm(ByVal UserName As String, ByVal password As String) As Boolean
Dim sql As String
Dim rs As ADODB.Recordset
sql = "select 用户名,密码 from 密码库 where 用户名='" + UserName + "' and 密码='" + password + "'"
If getsql(sql) Is Nothing Then
cls_sqlmm = False
Else
cls_sqlmm = True
End If
End Function
Public my_boolean As Boolean
Public Function getsql(ByVal sql As String)
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open sql, "provider=microsoft.jet.oledb.4.0;data source=d:\pw\hh\hh.mdb;user id=;password=;", adOpenStatic, adLockReadOnly
getsql = rs
rs.Close
End Function
Dim sql As String
Dim rs As ADODB.Recordset
sql = "select 用户名,密码 from 密码库 where 用户名='" + UserName + "' and 密码='" + password + "'"
If getsql(sql) Is Nothing Then
cls_sqlmm = False
Else
cls_sqlmm = True
End If
End Function
Public my_boolean As Boolean
Public Function getsql(ByVal sql As String)
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open sql, "provider=microsoft.jet.oledb.4.0;data source=d:\pw\hh\hh.mdb;user id=;password=;", adOpenStatic, adLockReadOnly
getsql = rs
rs.Close
End Function
解决方案 »
- VB 超简单问题
- 如果想在消息中加入变量该怎么办?
- 请问如何在vb中使用ssl进行连接和传送数据
- 请教:如何将文本文件转换为pdf格式文件?
- 急:如何在picture控件中随意画图形,就跟画图中的铅笔似的
- VB控制word打印的问题!
- 一个access数据库文件的关键字是怎么设置的?
- 一个vb小问题,望各位大虾不吝指教!
- 在VB中怎么样使VScroll 和HScroll 帮定在picturebox 中,求助?
- vb如何用正则表达式把几大段字符里所有正好是8位的数字提取出来
- 在webBrowser里,我点击某个超连接,如何得到我点击连接的文本内容啊??
- 请教:我在使用winsock的时候使用ADODB.Stream发送文件,那接收的时候可以使用ADODB.Stream吗?
Private WithEvents rs As adodb.RecordsetSet conn = New adodb.Connection
Dim dbfilename As String
dbfilename = App.Path & "\article.mdb"
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbfilename & ";Persist Security Info=False;"放到模块中或者form_load中,你的代码没有问题,每次调用 getsql函数,需要重新连接数据库,性能差
If getsql(sql) Is Nothing Then
cls_sqlmm = False
Else
cls_sqlmm = True
End If
中总是一个结果getsql(sql) Is Nothing
不知道什么原因
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open sql, "provider=microsoft.jet.oledb.4.0;data source=d:\pw\hh\hh.mdb;user id=;password=;", adOpenStatic, adLockReadOnly
if rs.eof then
getsql =false
else
getsql =true
end if
set rs=nothing
End Function
Public Function getsql(ByVal sql As String) as objectgetsql未负值时,getsql等于nothing