最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
asp 简单数据库连接类
时间:2022-07-02 22:36:04 编辑:袖梨 来源:一聚教程网
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
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 "
Response.Write "错 误 号:" & Err.Number & "
"
Response.Write "错误描述:" & Err.Description & "
"
Response.Write "错误来源:" & Err.Source & "
"
Response.Write ""
Err.Clear
Response.End
End Sub
End Class
相关文章
- boss智能门锁如何设置密码 04-29
- 王者荣耀世界橘右京厉害吗 04-29
- 《青云劫攻略天赋技能,成就无敌仙侠》(解锁潜能,掌握绝学,成就仙侠传奇) 04-29
- 桃源深处有人家藏经室悟证一至七日通关答案 04-29
- 怎么击败《Saros》中的“破碎崛起”先知 Boss 04-29
- 宫小攻略技能推荐2023(玩转宫小,轻松游戏攻略指南) 04-29