⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 duo5.asp

📁 一个不完整的硬件报价管理系统
💻 ASP
字号:
<% Response.Buffer=True %> 
<%
 Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("jobs.mdb")
%>
<% set rs=server.createobject("adodb.recordset")  
sql="select * from shengka order by id desc"   
rs.open sql,conn,1,1 
if not isempty(request("page")) then   
pagecount=cint(request("page"))   
else   
pagecount=1   
end if
rs.pagesize=1
rs.AbsolutePage=pagecount%>
<html>
<STYLE type=text/css>
TD {
	COLOR: #000; FONT-FAMILY: 宋体; FONT-SIZE: 12px
}
.GR {
	COLOR: #666
}
</STYLE>
<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="#ffffff" bordercolordark="#FFFFFF">
    <tr bordercolor="#CCCCCC"> 
      <td width="270" height="17" valign="bottom"> 
        <p align="left">今日硬件报价</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"><font size="2">今 日 声 卡 报 价</font></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="duo5.asp?page=<%=cstr(pagecount+1)%>"> 
          <font color="#000000">下一页</font></a> 
          <% end if %>
          <% if rs.pagecount>1 and rs.pagecount=pagecount then %><a href="duo5.asp?page=<%=cstr(pagecount-1)%>"> 
          <font color="#000000">上一页</font></a> 
          <%end if%>
          <%if pagecount<>1 and rs.pagecount<>pagecount then%><a href="duo5.asp?page=<%=cstr(pagecount-1)%>"> 
          <font color="#000000">上一页</font></a> <a href="duo5.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 + -