📄 js_con.bas
字号:
Attribute VB_Name = "jscon"
Public js As ADODB.Connection
Public rstjs As ADODB.Recordset
Public cmmjs As ADODB.Command
Public Sub js_con()
Set js = New ADODB.Connection
js.CursorLocation = adUseClient
js.Open "provider=microsoft.jet.OLEDB.4.0;Data source=" & VB.App.Path & "\db4.mdb"
Set rstjs = New ADODB.Recordset
Set rstjs.ActiveConnection = js
rstjs.Open "select*from 教师", js, adOpenStatic, adLockBatchOptimistic
Set cmmjs = New ADODB.Command
Set cmmjs.ActiveConnection = js
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -