大虾帮我写几句代码
请问出数据库中调用标题、时间、作者、内容从而使之成为一张网页的代码怎么写也就是通常用shownews.asp?new_id=1语句调用的网页，它是怎么生成的！！
2005-03-14 20:41
2005-03-15 09:58
<!--#include file="conn.asp"--> <% set rs1=server.CreateObject("adodb.recordset") sql="select top 12 * from chanpin order by id desc" rs1.open sql,conn,1 %> <% dim id id=Request.QueryString("id") Set rs=Server.CreateObject("ADODB.Recordset") sql="select * from chanpin where id="& id &"" rs.open sql,conn,3,3 %> <html> <head> <title>other.jpg</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <!--Fireworks MX 2004 Dreamweaver MX 2004 target. Created Tue May 25 16:06:33 GMT+0800 2004--> <style type="text/css"> <!-- body { margin-top: 0px; } --> </style> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_goToURL() { //v3.0 var i, args=MM_goToURL.arguments; document.MM_returnValue = false; for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'"); } //--> </script>
<link href="sina.css" rel="stylesheet" type="text/css"> </head> <SCRIPT language=javascript> <!--
function check_input() { if (Frm.keyword.value=="") { alert("关键字不能为空，请重新填写！"); return false; } return true; } //--> </SCRIPT> <body bgcolor="#ffffff"> <table width="778" border="0" align="center" cellpadding="0" cellspacing="0"> <!-- fwtable fwsrc="duan.png" fwbase="other.jpg" fwstyle="Dreamweaver" fwdocid = "1016162604" fwnested="0" --> <tr> <td><img src="pic/other/spacer.gif" width="14" height="1" border="0" alt=""></td> <td><img src="pic/other/spacer.gif" width="178" height="1" border="0" alt=""></td> <td><img src="pic/other/spacer.gif" width="428" height="1" border="0" alt=""></td> <td><img src="pic/other/spacer.gif" width="144" height="1" border="0" alt=""></td> <td><img src="pic/other/spacer.gif" width="14" height="1" border="0" alt=""></td> <td><img src="pic/other/spacer.gif" width="1" height="1" border="0" alt=""></td> </tr>
<tr> <td rowspan="7" background="pic/current/left14.jpg"> </td> <td rowspan="4"><img name="other_r1_c2" src="pic/other/other_r1_c2.jpg" width="178" height="130" border="0" alt=""></td> <td colspan="2"><img src="pic/other/other_r1_c3.jpg" alt="" name="other_r1_c3" width="572" height="30" border="0" usemap="#other_r1_c3Map"></td> <td rowspan="7" background="pic/current/right14.jpg"> </td> <td><img src="pic/other/spacer.gif" width="1" height="30" border="0" alt=""></td> </tr> <tr> <td colspan="2"><img name="other_r2_c3" src="pic/other/other_r2_c3.jpg" width="572" height="36" border="0" alt=""></td> <td><img src="pic/other/spacer.gif" width="1" height="36" border="0" alt=""></td> </tr> <tr> <td><img name="other_r3_c3" src="pic/other/other_r3_c3.jpg" width="428" height="24" border="0" alt=""></td> <td><img name="other_r3_c4" src="pic/other/other_r3_c4.jpg" width="144" height="24" border="0" alt=""></td> <td><img src="pic/other/spacer.gif" width="1" height="24" border="0" alt=""></td> </tr> <tr> <form name="form1" method="post" action="ceshi.asp"> <td background="pic/other/other_r4_c3.jpg"> 用户名: <input name="name" type="text" size="16"> 密码: <input type="password" name="password" size="16"> <input type="submit" name="Submit" value="提交"> <input type="reset" name="Submit2" onClick="MM_goToURL('parent','code/member/ok.asp');return document.MM_returnValue" value="注册"> </td> </form> <td><img src="pic/other/other_r4_c4.jpg" alt="" name="other_r4_c4" width="144" height="40" border="0" usemap="#other_r4_c4Map"></td> <td><img src="pic/other/spacer.gif" width="1" height="40" border="0" alt=""></td> </tr> <tr> <td valign="top" background="pic/current/left178.jpg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><img src="pic/current/menubut178.jpg" width="178" height="27"></td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="94" valign="top" background="pic/current/menu178.jpg"><table width="178" border="0" cellspacing="0" cellpadding="0"> <tr> <td> </td> <td align="center"> </td> <td align="center"></td> <td align="left"> </td> </tr> <% do while not rs1.eof%> <tr> <td width="28"> </td> <td width="19" align="center"><img src="pic/current/jiantou.gif" width="7" height="5"></td> <td width="16" align="center"></td> <td width="115" align="left"><a href="showcenter.asp?id=<%=rs1("id")%>"><%=rs1("mingzi")%></a></td> </tr> <%rs1.movenext loop%> </table></td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><img src="pic/current/menudi178.jpg" width="178" height="18"></td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="13" background="pic/current/lw178.jpg"> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><img src="pic/current/dibian.jpg" width="178" height="23"></td> </tr> </table></td> <td colspan="2" align="left" valign="top" bgcolor="#FFFFFF"> <table width="572" border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <td><img src="img/line.gif" width="572" height="1"></td> </tr> </table> <table width="572" border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <td> <table width="50%" border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <td><br> <form name="Frm" method="post" action="searchshow.asp" onSubmit="return check_input()"> <div align="center">产品检索 <input type="text" name="keyword" value=""> <input type="submit" name="Submit" value=" 搜 索 "> </div> </form> </td> </tr> </table> <table width="100%" border="0" cellspacing="8" cellpadding="0" align="center"> <tr valign="top"> <td width="100%"> <div align="center"> <table width="96%" border="0" cellspacing="0" cellpadding="0" align="left"> <tr> <td width="20%"><font color="#FF0000">[ 产品图片 ]<font color="#000000">：</font></font></td> <td width="80%"> <div align="center"><img src="<%=rs("tupian")%>" border="1"></div> </td> </tr> </table> </div> </td> </tr> <tr valign="middle"> <td height="20" bgcolor="#e8ecec"> <div align="center"> <table width="71%" border="0" cellspacing="0" cellpadding="0" align="left"> <tr> <td width="33%"><font color="#FF0000">[ 产品名称 ]</font>：</td> <td width="67%"> <div align="center"><b><%=rs("mingzi")%></b></div> </td> </tr> </table> </div> </td> </tr> <tr> <td height="21" bgcolor="#e8ecec"> <div align="left"><font color="#FF0000">[ 产 品 介 绍 ]</font>：</div> </td> </tr> <tr> <td><font class="pt9"> <%=rs("neirong")%></font></td> </tr> <tr bgcolor="#e8ecec"> <td height="20"> <div align="left"><font color="#FF0000">[ 产 品 参 数 ]</font></div> </td> </tr> <tr> <td class="p1112"> <div align="left"> <% if rs("tupian1")="" then response.Write"" else response.Write"<img src="& rs("tupian1")&">" end if %> <font class="pt9"><%=rs("canshu")%></font> </div> </td> </tr> </table> </td> </tr> </table> <table width="572" border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <td><img src="img/line.gif" width="572" height="1"></td> </tr> </table> <% rs.close set rs=nothing set conn=nothing %> </td> <td><img src="pic/other/spacer.gif" width="1" height="429" border="0" alt=""></td> </tr> <tr> <td colspan="3"><img src="pic/other/other_r6_c2.jpg" alt="" name="other_r6_c2" width="750" height="55" border="0" usemap="#other_r6_c2Map"></td> <td><img src="pic/other/spacer.gif" width="1" height="55" border="0" alt=""></td> </tr> <tr> <td colspan="3" bgcolor="#E5E5E5"> </td> <td><img src="pic/other/spacer.gif" width="1" height="45" border="0" alt=""></td> </tr> </table> <map name="other_r1_c3Map"> <area shape="rect" coords="1,2,96,31" href="index.asp"> <area shape="rect" coords="97,2,188,31" href="product.asp"> <area shape="rect" coords="188,1,287,30" href="news.asp"> <area shape="rect" coords="288,2,383,28" href="gq.asp"> <area shape="rect" coords="384,2,479,30" href="adbbs/"> <area shape="rect" coords="480,1,571,28" href="#"> </map> <map name="other_r4_c4Map"> <area shape="rect" coords="74,1,145,40" href="code/manage/index.asp"> <area shape="rect" coords="1,2,74,41" href="javascript:window.external.AddFavorite('http://www.atst.cn/','中国广告外设网')"> </map> <map name="other_r6_c2Map"> <area shape="rect" coords="196,12,255,31" href="index.asp"> <area shape="rect" coords="285,12,346,32" href="product.asp"> <area shape="rect" coords="383,11,446,31" href="news.asp"> <area shape="rect" coords="485,11,548,32" href="gq.asp"> <area shape="rect" coords="586,11,647,32" href="adbbs/"> <area shape="rect" coords="679,12,738,31" href="down.asp"> </map> </body> </html>
2005-03-15 09:58
2005-03-15 16:39
2005-03-15 17:45
2005-03-15 18:24
2005-03-15 18:35
2005-03-15 19:15
2005-03-15 19:22
2005-03-16 13:37
