杭州交通信息网国足最新赛事:asp与数据库的连接
来源：百度文库 编辑：杭州交通信息网 时间：2024/04/29 10:30:06
<%
response.buffer = true
dim conn,connstr,dbpath
Dim rs,sql
Set Conn=Server.CreateObject("ADODB.Connection")
dbpath = "Database/data.mdb"
connstr ="Provider = Microsoft.Jet.OLEDB.4.0; Data Source ="& Server.MapPath(dbpath)
Conn.Open connstr
Function CloseDatabase
Conn.Close()
Set Conn = Nothing
End Function
%>
这段代码的详细注释，谢谢各位大虾了！
response.buffer = true
dim conn,connstr,dbpath
Dim rs,sql
Set Conn=Server.CreateObject("ADODB.Connection")
dbpath = "Database/data.mdb"
connstr ="Provider = Microsoft.Jet.OLEDB.4.0; Data Source ="& Server.MapPath(dbpath)
Conn.Open connstr
Function CloseDatabase
Conn.Close()
Set Conn = Nothing
End Function
%>
这段代码的详细注释，谢谢各位大虾了！
response.buffer = true '自动刷新页面
dim conn,connstr,dbpath
Dim rs,sql '声明变量
Set Conn=Server.CreateObject("ADODB.Connection")
dbpath = "Database/data.mdb" '数据库路径
connstr ="Provider = Microsoft.Jet.OLEDB.4.0; Data Source ="& Server.MapPath(dbpath) '建立数据库连接
Conn.Open connstr
Function CloseDatabase
Conn.Close()
Set Conn = Nothing
End Function
'关闭数据库
标准的CONN文件
是数据库连接的代码
首先要定义一个CONN
然后把数据库跟CONN连接起来
最后一段是关闭CONN的语法,用来关闭连接的