展会信息港展会大全

asp 简单数据库连接类 android软件开发教程
来源:互联网   发布日期:2016-03-01 11:05:01   浏览:1974次  

导读:Class Cls_DB Private ConnStr Private DBpath,DBLink,DBi ============================== 函 数 名:DB_Conn 作 用:数据库连接函数 参 数: ============================== Private Sub DB_Conn() On Error Resume Next Set Conn = Server.CreateObject(...

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 "<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

赞助本站

人工智能实验室

相关热词: 开发 编程 android

AiLab云推荐
展开

热门栏目HotCates

Copyright © 2010-2024 AiLab Team. 人工智能实验室 版权所有    关于我们 | 联系我们 | 广告服务 | 公司动态 | 免责声明 | 隐私条款 | 工作机会 | 展会港