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=ERP"
    dbConn.Open connString
    
    'dbConn.Open "Provider=OraOLEDB.Oracle;Data Source=zhangjie;User ID=tetra;Password=tetra;"
    'dbConn.Open "ODBC;DATABASE=sdh;UID=alarmcase;PWD=alarmcase;DSN=Oracle_AlarmCase"
    'dbConn.Open "Provider=OraOLEDB.Oracle;Data Source=sdh;User ID=bjtel0709;Password=bjtel0709;"
    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
    'sqlStr = "insert into fault_experience(networkType,faultName,faultType,isIntService,vendor,faultLocation,faultSourName,faultSourType,alarmList,faultDesc,localPhen,processor,experience,startTime,stopTime) values( '网络类型','故障名称55','故障类型','是否中断业务','故障源所属厂家','故障源位置','故障源名称','故障源类型','告警列表','故障描述','本地现象','处理人员','处理经验','2003-07-25 15:15:00','2003-07-25 15:15:00' ) "
    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