db.cls

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

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

Property Get Path() As String
    Path = App.Path & "\"
End Property

Property Get DataBase() As String
'    If sSystem = "Test" Then
'        DataBase = "ICDATA_1.mdb"
'    Else
        DataBase = "ICDATA.mdb"
'    End If
End Property

Property Get DatabaseConnect() As ADODB.Connection
    Set DatabaseConnect = New ADODB.Connection
    With DatabaseConnect
        .ConnectionTimeout = 0
        .CommandTimeout = 60000
        .CursorLocation = adUseClient
        .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                            "Data Source= " & Me.Path & Me.DataBase & ";Jet OLEDB:Database password=addlinkmoney69"
        .Open
    End With
End Property