Class Cls_DB
Private ConnStr, Conn, Rs
Private Sub DB_Conn()
On Error Resume Next
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(SiteDB)
Conn.Open ConnStr
If Err.Number <> 0 Then Call AspErr()
End Sub
Public Sub DB_Open()
Call DB_Conn()
Set Rs = Server.CreateObject("ADODB.Recordset")
End Sub
Public Sub DB_Close()
Set Rs = Nothing
If IsObject(Conn) Then Conn.Close
Set Conn = Nothing
End Sub
Private Sub AspErr()
Dim DBLink, DBpath, DBi
DBLink = Split(Request.ServerVariables("URL"), "/")
For DBi = 0 To UBound(DBLink) - 1
DBpath = DBpath & DBLink(DBi) & "/"
Next
Response.Write ""
Response.Write "錯誤號:" & Err.Number & "
"
Response.Write "錯誤描述:" & Err.Description & "
"
Response.Write "錯誤來源:" & Err.Source & "
"
Response.Write ""
Err.Clear
Response.End
End Sub
End Class
<%
Set DB = New Cls_DB
DB.DB_Open
DB.Rs.Open "SELECT * FROM news", DB.Conn, 1, 1
' ...
DB.DB_Close
%>
SiteDB,耦合度高。Recordset。參考 ID 66971 的雙資料庫支援,並加入 Execute(sql, params)、Query(sql, params)、ExecuteScalar(sql, params) 等封裝方法。