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