cdatabaseconnector.cls

来自「一个完整的非接触IC卡会员管理系统」· CLS 代码 · 共 54 行

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

'---------------------------------------------------------------------------
'作者
'类文名称   :CDataBaseConnector
'类文件     :CDataBaseConnector.cls
'创建时间   :2002-9-25
'类介绍     :这是一个接口类，实现和数据库连接的接口
'提供接口   :除属性接口外，该类还提供以下方法接口：
'公有接口   :
 '-----------------------------------------------------------------------------

Property Get Server() As String
    Server = "dqyang"
End Property
Property Get DataBase() As String
    DataBase = "dbbus"
End Property
Property Get DataBaseUser() As String
    DataBaseUser = "sa"
End Property
Property Get DataBasePassWord() As String
    DataBasePassWord = "123456"
End Property

Property Get DatabaseConnect() As ADODB.Connection
    Set DatabaseConnect = New ADODB.Connection
    With DatabaseConnect
        .ConnectionTimeout = 60000
        .CommandTimeout = 60000
        .CursorLocation = adUseClient
        .Open Me.DataBase, Me.DataBaseUser, Me.DataBasePassWord
    End With
End Property