clscon.cls

一个完整的图书管理系统

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "clsCon"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Option Explicit

Public c As ADODB.Connection

Public Sub connect(ByVal server As String)
On Error GoTo err1:
    Set c = New ADODB.Connection
    c.ConnectionString = "Provider=SQLOLEDB.1;User ID=sa;Persist Security Info=False;Initial Catalog=Library;Data Source=Lab2"
    c.Open
    c.CursorLocation = adUseClient
    Exit Sub
err1:
    MsgBox "请输入正确的服务器名称并保证其可用", vbExclamation, "千年图书管理系统"
End Sub