Version 1.0 Class
Begin
MultiUse = -1 'True
Persistable = 0 'NotPersistable
DataBindingBehavior = 0 'vbNone
DataSourceBehavior = 0 'vbNone
MTSTransactionMode = 0 'NotAnMTSObject
End
Attribute VB_Name = "ClsDB"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
'xxx
'xxx
Option Explicit

Private Const CONN_STRING As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
Public DB_PATH As String

'數據庫連接
Public dbConn As New ADODB.Connection

'表明當前數據庫的連接狀態:False－未連接；True－已連接
Public dbStatus As Boolean



Public Function openDB() As Boolean
    Dim connString As String
    connString = "driver={SQL Server};server=" + Trim(Server) + ";uid=" + Trim(User) + ";pwd=" + Trim(Password) + ";database=ERP"
    
    dbConn.Open connString
    
    If Err.Number <> 0 Then MsgBox Err.Description
     GoTo errHandler
    
    openDB = True
    Exit Function
    
errHandler:
    openDB = False
    
End Function

Public Function closeDB() As Integer
    dbConn.Close
    
    dbStatus = False
End Function

Public Function exeSql(sqlStr As String, queryResult As ADODB.Recordset, Optional enableWrite As Boolean = True) As Boolean
On Error GoTo errHandler:
    Dim ret
    Set queryResult = New ADODB.Recordset
    
    If enableWrite Then
        queryResult.Open sqlStr, dbConn, adOpenStatic, adLockOptimistic
    Else
        queryResult.Open sqlStr, dbConn, adOpenStatic, adLockReadOnly
    End If
    
    exeSql = True
    Exit Function
    
errHandler:
    '    MsgBox Err.Description
    exeSql = False
    Exit Function
End Function