<%
dim conn
dim connstr
connstr="DBQ="+server.mappath("db/db.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION") '建立连接对象
conn.open connstr '打开连接
set rs=server.createobject("adodb.recordset") '建立记录集对象
sql="select * from your_table" '查询语句
rs.open sql,conn,1,1 '打开记录集
if not rs.bof and rs.eof then '判断数据库是否为空
do while not rs.eof '循环输出记录内容
response.write rs("title")
rs.movenext '记录向下移动
loop
else
response.write("没有记录")
end if
rs.close '关闭记录集
set rs=nothing '释放记录集所占资源
conn.close '关闭连接对象
set conn=nothing '释放连接对象所占资源
%>
<%
dim conn
dim connstr
connstr="DBQ="+server.mappath("db/db.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION") '建立连接对象
conn.open connstr '打开连接
set rs=server.createobject("adodb.recordset") '建立记录集对象
sql="select * from your_table" '查询语句
if not rs.bof and rs.eof then '判断数据库是否为空
do while not rs.eof '循环输出记录内容
response.write rs("title")
rs.movenext '记录向下移动
loop
else
response.write("没有记录")
end if
rs.close '关闭记录集
set rs=nothing '释放记录集所占资源
conn.close '关闭连接对象
set conn=nothing '释放连接对象所占资源
%>
<%
dim conn
dim connstr
connstr="DBQ="+server.mappath("db/db.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
set rs=server.createobject("adodb.recordset")
sql="select * from your_table"
if not rs.bof and rs.eof then
do while not rs.eof
response.write rs("title")
rs.movenext
loop
else
response.write("没有记录")
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>