📄 showb.asp

📁 用ASP写的二手市场程序
💻 ASP
字号:
<html>

<head>
<style type="text/css">
<!--
body {font-family: "宋体,MS Sans Serif"; font-size:  12px; line-height: 17px;}
td {font-family: "宋体,MS Sans Serif"; font-size:  12px; line-height: 17px;}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<title>闽东二手交易中心</title>


<link rel="stylesheet" type="text/css" href="new.css">
</head><body bgcolor="#FFFFFF" text="#000000" link="#333333" vlink="#000000"
alink="#000000" background="bg.gif" >
<a name="top"><p><a href=../index.html><font face="Arial Unicode MS" >To index page</font></a> <a href=editer.asp><font face="Arial Unicode MS" >To editer page</font></a> <a href=allshow.asp><font face="Arial Unicode MS" >To allshow page</font></a> <a href=copy.asp><font face="Arial Unicode MS" >Copy data.mdb</font></a></P>
<%   connstr = "DBQ="+server.mappath("data2.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
   Set DataConn = Server.CreateObject("ADODB.Connection")
   dataconn.open connstr
   Set rs = dataconn.execute("select * from data order by id desc") %>
<table border=1 align="center" width="100%"><tr>
<% for i = 0 to rs.fields.count-1 %>
<td align="center"><b><% = rs(i).name %></b></td>
<% next %>
<% do while not rs.eof %>
<tr>
<%
     response.write "<td align='center'><a href='delb.asp?id="+cstr(rs("id"))+"'>"+cstr(rs("id"))+"</a></td>" 
          	   response.write "<td align='center'>"+Rs("num")+"</td>"
          	   response.write "<td align='center'>"+Rs("buyorsell")+"&nbsp;</td>"
     response.write "<td>"+cstr(rs("goods"))+"</a>&nbsp;</td>" 
          	   response.write "<td>"+Rs("content")+"&nbsp;</td>"
          	   response.write "<td align='center'>"+cstr(Rs("date"))+"</td>"
          	   response.write "<td align='center'>"+Rs("time")+"</td>"
     response.write "<td align='center'>"+cstr(rs("kind"))+"</a></td>" 
          	   response.write "<td align='center'>"+Rs("name")+"&nbsp;</td>"
     response.write "<td align='center'>"+cstr(rs("email"))+"</a>&nbsp;</td>" 
          	   response.write "<td align='center'>"+Rs("amount")+"&nbsp;</td>"
          	   response.write "<td align='center'>"+Rs("price")+"&nbsp;</td>"
          	   response.write "<td align='center'>"+Rs("city")+"&nbsp;</td>"
          	   response.write "<td align='center'>"+Rs("degree")+"&nbsp;</td>"
          	   response.write "<td align='center'>"+Rs("province")+"&nbsp;</td>"
          	   response.write "<td align='center'>"+Rs("trademode")+"&nbsp;</td>"
          	   response.write "<td align='center'>"+Rs("telephone")+"&nbsp;</td>"
          	   response.write "<td align='center'>"+Rs("bbcall")+"&nbsp;</td>"
          	   response.write "<td align='center'>"+Rs("icq")+"&nbsp;</td>"
          	   response.write "<td align='center'>"+Rs("oicq")+"&nbsp;</td>"
          	   response.write "<td align='center'>"+Rs("buydate")+"&nbsp;</td>"

%>
</tr>
<%
rs.movenext
loop
rs.close
dataconn.close
%>
</table>
<p align=left><b><font face="Arial Unicode MS" >^ </font></b><font face="tahoma" ><a href="#top">Back to top</a></font></p>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -