📄 index.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn/conn.asp" -->
<%
Set rs_file = Server.CreateObject("ADODB.Recordset")
sql_file = "SELECT * FROM tb_img ORDER BY ID DESC"
rs_file.open sql_file,conn,1,3
%>
<html>
<head>
<title>单表单文件上传到数据库</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
}
.style3 {color: #C60001}
.style10 {color: #669999}
-->
</style></head>
<body>
<table width="410" height="88" border="0" cellpadding="-2" cellspacing="-2" background="images/top.gif">
<tr valign="top">
<td width="800" valign="bottom"><table width="410" height="17" border="0" cellpadding="-2" cellspacing="-2">
<tr>
<td width="6%" align="center" valign="middle"> </td>
<td width="70%" align="center"><div align="left"></div></td>
<td width="24%"><div align="center"><span class="style3"><a href="Img.asp">·上传文件·</a></span></div></td>
</tr>
</table></td>
</tr>
</table>
<table width="410" border="0" cellpadding="-2" cellspacing="-2">
<tr>
<td width="817" valign="top"><%if rs_file.eof then%>
<table align="center"><tr><td>无上传文件!</td></tr></table>
<%else%>
<table width="100%" border="1" align="right" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#CCCCCC" bordercolorlight="#FFFFFF">
<tr>
<td width="76%" height="27"><div align="center">ID</div></td>
<td width="24%" height="27"><div align="center">查看</div></td>
</tr>
<%'分页'
rs_file.pagesize=5
page=CLng(Request("page"))
if page<1 then page=1
rs_file.absolutepage=page
for i=1 to rs_file.pagesize %>
<tr>
<td align="center"> <%=(rs_file(0))%></td>
<td><div align="center">
<A HREF="#" onClick="window.open('Img_see.asp?FileName=<%=rs_file(0) %>')">
<img src="images/download.gif" width="22" height="22" border="0"></A>
</div></td>
</tr>
<% rs_file.movenext
if rs_file.eof then exit for
next %>
</table></td>
</tr>
</table>
<table width="411" border="0" cellspacing="-2" cellpadding="-2">
<tr>
<td>
<% if page<>1 then %>
<a href=<%=path%>?page=1>第一页</a>
<a href=<%=path%>?page=<%=(page-1)%>>上一页</a> <%end if
if page<>rs_file.pagecount then %>
<a href=<%=path%>?page=<%=(page+1)%>>下一页</a>
<a href=<%=path%>?page=<%=rs_file.pagecount%>>最后一页</a> <%end if %>
</td>
</tr>
</table>
<%end if%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -