<%sub Table_show(tablename)%>
<table border="1" cellspacing="0" cellpadding="3" style='border-collapse:collapse;' bordercolor="#006699">
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from "&tablename
rs.open sql,conn,1,1
%>
<tr>
<%for i=0 to rs.fields.count-1%>
<td><%=rs.fields(i).name%></td>
<%next%>
</tr>
<%do while not rs.eof%>
<tr>
<%for i=0 to rs.fields.count-1%>
<td><%=rs(i)%></td>
<%next%>
</tr>
<%rs.movenext
loop
rs.close
set rs=nothing%>
</table>
<%end sub%>
<table border="1" cellspacing="0" cellpadding="3" style='border-collapse:collapse;' bordercolor="#006699">
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from "&tablename
rs.open sql,conn,1,1
%>
<tr>
<%for i=0 to rs.fields.count-1%>
<td><%=rs.fields(i).name%></td>
<%next%>
</tr>
<%do while not rs.eof%>
<tr>
<%for i=0 to rs.fields.count-1%>
<td><%=rs(i)%></td>
<%next%>
</tr>
<%rs.movenext
loop
rs.close
set rs=nothing%>
</table>
<%end sub%>
博客展示了一段代码,通过创建ADODB记录集对象,使用SQL语句查询指定表的数据,并将查询结果以表格形式展示,包含表头和数据行,最后关闭记录集并释放对象。
2710

被折叠的 条评论
为什么被折叠?



