set rs=nothing
conn.close
set conn=nothing
sub showContent
dim i
i=1
%>
<%do while not rs.eof%>
<tr>
<td><%dim picc,vname,vnclass
picc=rs("pic")
vname=rs("name")
vnclass=rs("nclass")%><%
sql="update Special set pic='"&picc&"' where name='"&vname&"' and nclass='"&vnclass&"' "
conn.execute sql
%></td>
</tr>
<% i=i+1
if i>=MaxPerPage then exit do
rs.movenext
loop
%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="21" bgcolor="#F7F7F7" align="center">
<%
end sub
function showpage(totalnumber,maxperpage,filename)
dim n
if totalnumber mod maxperpage=0 then
n= totalnumber maxperpage
else
n= totalnumber maxperpage+1
end if
if CurrentPage<2 then
response.write ""
else
response.write "<a href="&filename&"?page=1>首页</a> "
response.write "<a href="&filename&"?page="&CurrentPage-1&">上一页</a> "
end if
if n-currentpage<1 then
response.write ""
else
response.write "<a href="&filename&"?page="&(CurrentPage+1)&">"
response.write "下一页</a> <a href="&filename&"?page="&n&">尾页</a>"
end if
response.write " 页次：</font><b><font color=red>"&CurrentPage&"</font>/"&n&"</b>页</font> "
response.write " 共<b>"&totalnumber-1&"</b>个软件 <b>"&maxperpage&"</b>个软件/页"
end function
%>
</td>
</tr>
</table>
</body>
</html>
