asp 簡單數據庫連接類

2019-11-02 15:14:05

字體：大中小

來源：轉載

供稿：網友

Class Cls_DB
Private ConnStr
Private DBpath,DBLink,DBi
==============================
函數名：DB_Conn
作    用：數據庫連接函數
參    數：
==============================
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 Then
   Call AspErr()
End If
&nbs

精選搞笑動態圖片[www.62-6.com/1/dttp/]

p;End Sub

==============================
函數名：DB_Open
作    用：創建讀取對象
參    數：
==============================
Public Sub DB_Open()
Call DB_Conn()
Set Rs=Server.Createobject("Adodb.RecordSet")
End Sub

==============================
函數名：DB_Close
作    用：關閉讀取對象
參    數：
==============================
Public Sub DB_Close()
Set Rs=Nothing
If IsObject(Conn) Then Conn.Close
Set Conn = Nothing
End Sub

=============================
函數名：AspErr
  作    用：連接報錯
參    數：
=============================
Private Sub AspErr()
DBLink = Request.ServerVariables("url")
DBLink = Split(DBLink,"/")
For DBi = 0 To Ubound(DBLink)-1
   DBpath = DBpath&DBLink(DBi)&"/"
Next
Response.Write "<body style='font-size:12px'>"
Response.Write "錯誤號：" & Err.Number & "<br />"
Response.Write "錯誤描述：" & Err.Description & "<br />"
Response.Write "錯誤來源：" & Err.Source & "<br />"
Response.Write "</body>"
Err.Clear
Response.End
End Sub
End Class