📄 gai1.asp
字号:
<% Response.Buffer=True %>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("jobs.mdb")
%>
<% if request("del")<>"" then
conn.Execute("delete * from zhuban where id="&request("del"))
end if %>
<% set rs=server.createobject("adodb.recordset")
if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if
sql="select * from zhuban order by id desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write"<BR>"
response.write"=== 暂无记录 ==="
response.write"<BR><BR>"
response.write"[<a href='add1.asp' target='_blank'><font color='#000060'>添加主板信息</font></a>]"
response.end
rs.pagesize=1
end if
rs.AbsolutePage=pagecount%>
<html>
<STYLE type=text/css>
TD {
COLOR: #000; FONT-FAMILY: 宋体; FONT-SIZE: 12px
}
.GR {
COLOR: #000
}
</STYLE>
<SCRIPT>
function openwin(page,size)
{
window.open(page,"newuser","toolbar=no,location=no,directories=no,status=no,menubar=yes,scrollbars=yes,resizable=no,"+ size);
}
</SCRIPT>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>更多信息</title>
</head>
<body>
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" width="430" bordercolorlight="#fffffff" bordercolordark="#FFFFFF">
<tr bordercolor="#CCCCCC">
<td width="270" height="17" valign="bottom"> <p align="left">今日硬件报价 [<a href="gai1.asp?del=<%=rs("id")%>">删除该页数据</a>]
[<a href="javascript:openwin('add1.asp','top=10,left=80,width=500,height=320')">添加新数据</a>] </td>
<td width="154" height="17" valign="bottom">
<p align="center">共<font color="#0000AE"><%=rs.recordcount%></font>条信息</td>
</tr>
<center>
<tr bordercolor="#CCCCCC">
<td width="448" colspan="2" valign="bottom"><table width="100%" border="1" cellspacing="1" cellpadding="0">
<!--主板-->
<% do while not rs.eof %>
<tr>
<td colspan="3"><div align="center">今 日 主 板 报 价</div></td>
</tr>
<tr>
<td><div align="center">品牌</div></td>
<td><div align="center">型号</div></td>
<td><div align="center">价格</div></td>
</tr>
<tr>
<td width="79"><div align="center"><font color="#000000"><%=rs("pp1")%></font></div></td>
<td width="81"><div align="center"><font color="#000000"><%=rs("xh1")%></font></div></td>
<td width="82"><div align="center"><font color="#000000"><%=rs("jg1")%></font></div></td>
</tr>
<tr>
<td><div align="center"><font color="#000000"><%=rs("pp2")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("xh2")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("jg2")%></font></div></td>
</tr>
<tr>
<td><div align="center"><font color="#000000"><%=rs("pp3")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("xh3")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("jg3")%></font></div></td>
</tr>
<tr>
<td><div align="center"><font color="#000000"><%=rs("pp4")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("xh4")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("jg4")%></font></div></td>
</tr>
<tr>
<td><div align="center"><font color="#000000"><%=rs("pp5")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("xh5")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("jg5")%></font></div></td>
</tr>
<tr>
<td><div align="center"><font color="#000000"><%=rs("pp6")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("xh6")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("jg6")%></font></div></td>
</tr>
<tr>
<td><div align="center"><font color="#000000"><%=rs("pp7")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("xh7")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("jg7")%></font></div></td>
</tr>
<tr>
<td><div align="center"><font color="#000000"><%=rs("pp8")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("xh8")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("jg8")%></font></div></td>
</tr>
<tr>
<td><div align="center"><font color="#000000"><%=rs("pp9")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("xh9")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("jg9")%></font></div></td>
</tr>
<tr>
<td><div align="center"><font color="#000000"><%=rs("pp10")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("xh10")%></font></div></td>
<td><div align="center"><font color="#000000"><%=rs("jg10")%></font></div></td>
</tr>
<% n=n+1
rs.movenext
if n>=rs.pagesize then exit do
loop %>
</table></td>
</tr>
</center>
<tr bordercolor="#CCCCCC">
<td width="448" height="17" colspan="2" valign="bottom">
<p align="center">
<%if pagecount=1 and rs.pagecount<>pagecount then%><a href="duo1.asp?page=<%=cstr(pagecount+1)%>">
<font color="#000000">下一页</font></a>
<% end if %>
<% if rs.pagecount>1 and rs.pagecount=pagecount then %><a href="duo1.asp?page=<%=cstr(pagecount-1)%>">
<font color="#000000">上一页</font></a>
<%end if%>
<%if pagecount<>1 and rs.pagecount<>pagecount then%><a href="duo1.asp?page=<%=cstr(pagecount-1)%>">
<font color="#000000">上一页</font></a> <a href="duo1.asp?page=<%=cstr(pagecount+1)%>">
<font color="#000000">下一页</font></a>
<%end if%>
</td>
</tr>
</table>
</div>
<p align="center">【<a href="javascript:window.close()">关闭窗口</a>】</p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -