|
我想写这么个函数 1.数据都存在一个access数据库里
2.写个函数 例如 function GetAge(name as string)
3.连接数据库 把数据读出来 关闭数据库...关闭连接
上面的模仿网上的教程写好了,但是如果同时读多个人的发现很卡,我怀疑是反复连接、关闭数据库引起的,我这方面还是小白,请各位老师指教
附上代码
- Function 填入(name As String, item As String)
- '定义变量
- Dim rsCon As ADODB.Connection
- Dim rsData As ADODB.Recordset
- Dim szConnect As String
- Dim szSQL As String
- Dim value As String
- '连接数据
- Set rsCon = New ADODB.Connection
- Set rsData = New ADODB.Recordset
- szConnect = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
- "Data Source=C:\Users\Sui\Desktop\Excel\数据库.accdb"
-
- szSQL = "select " & item & " from 人员信息 where(姓名='" & name & "')"
- rsCon.Open szConnect
- rsData.Open szSQL, rsCon, adOpenKeyset, adLockOptimistic
- '读取数据
- If Not rsData.EOF Then
- value = rsData.Fields.item(0)
- Else
- MsgBox "读取失败"
- End If
- '关闭数据库 清楚缓存
- rsData.Close
- Set rsData = Nothing
- rsCon.Close
- Set rsCon = Nothing
- 填入 = CStr(value)
- End Function
复制代码
|
|