?? clsdb.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 = "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
'DB_PATH = dbPath
'dbConn.Open CONN_STRING & DB_PATH
'MsgBox Err.Description
Dim connString As String
connString = "driver={SQL Server};server=" + Trim(Server) + ";uid=" + Trim(User) + ";pwd=" + Trim(Password) + ";database=CallerMIS"
dbConn.Open connString
If Err.Number <> 0 Then MsgBox Err.Description: GoTo errHandler
'dbStatus = True
openDB = True
Exit Function
errHandler:
openDB = False
End Function
Public Function closeDB() As Integer
dbConn.Close
'xxx
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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -