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

📄 comment.asp

📁 毕业设计_新闻管理系统(ASP)+论文.rar(1.32M)
💻 ASP
字号:
<%@ LANGUAGE="VBSCRIPT"%>
<!-- #include file="ADOVBS.INc" -->
<%
set conn=server.createObject("ADODB.Connection")
dbpath=server.mappath("news.mdb")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbpath
set rs=server.createobject("adodb.recordset")


sqltext="Select * from news where newsid="&request("newsid")
rs.open sqltext,conn,adOpenkeyset,adlockoptimistic,adcmdtext
skipid=request("newsid")
a=trim(rs("key1"))
b=trim(rs("key1"))
c=trim(rs("lookfrom"))
d=trim(rs("reporter"))
%>
<html>
<head>
<title>具体内容</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.big {  font-size: 14px; color: #000000; word-spacing: normal}
.botton {  color: #000000; background-color: #FFFFF8; font-size: 12px}
.yjtitle {  line-height: 40px}
-->
</style>
<link rel="stylesheet" href="3508.css">
</head>
<body bgcolor="#FFFFF8">
<table width="706" border="0" cellspacing="0" cellpadding="0" align="center" height="18" bgcolor="#FFCC99">
  <tr> 
    <td width="260"><a href="default.asp">首页</a>【本站导航】 新闻</td>
    <td width="40">◆<a href="more.asp?class='A'">娱乐</a> </td>
    <td width="40">◆<a href="more.asp?class='B'">游戏</a></td>
    <td width="40">◆<a href="more.asp?class='C'">体育</a></td>
    <td width="40">◆<a href="more.asp?class='D'">军事</a></td>
    <td width="40">◆<a href="more.asp?class='E'">科技</a></td>
    <td width="40">◆<a href="more.asp?class='F'">房产</a></td>
    <td width="40">◆<a href="more.asp?class='G'">财经</a></td>
    <td width="40">◆<a href="more.asp?class='H'">教育</a></td>
    <td width="40">◆<a href="more.asp?class='I'">笑话</a></td>
    <td width="40">◆<a href="more.asp?class='J'">天气</a></td>
    <td width="40">◆<a href="more.asp?class='K'">旅游</a></td>
    <td width="44">◆<a href="more.asp?class='L'">其他</a></td>
   
  </tr>
</table>
<table width="705" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td width="703">&nbsp;</td>
  </tr>
</table>
<table width="705" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#ECFFEC" height="274">
  <tr> 
    <td colspan="2" align="right" height="16" width="703">&nbsp;</td>
  </tr>
  <tr> 
    <td colspan="2" align="center" height="105" width="703"> 
      <table width="640" border="0" cellspacing="0" cellpadding="0">
        <tr align="center"> 
          <td height="36" width="640"> 
            <h2><span class="yjtitle"><%=rs("title")%></span></h2>
          </td>
        </tr>
        <tr align="right" valign="top"> 
          <td height="35" width="640"><%=rs("accessory")%></td>
        </tr>
        <tr> 
          <td width="640"><span class="big">  <%=rs("content")%></span></td>
        </tr>
        <tr> 
          <td width="640">&nbsp;</td>
        </tr>
      </table>
    </td>
  </tr>
  <%
rs.close
set rs=nothing
set rs=server.createobject("adodb.recordset")
sqltext="select newsid,title,newsdate from news where key1+key2 like '%"&a&"%' and key1+key2 like '%"&b&"%'"
rs.open sqltext,conn,adOpenkeyset,adlockoptimistic,adcmdtext
if not(rs.bof and rs.eof) then%> 
  <tr> 
    <td colspan="2" height="34" width="703"> 
      <table width="70%" align="center" cellpadding="0" cellspacing="0" border="0">
        <tr> 
          <td>【相关内容】</td>
        </tr>
        <%
i=0
while not rs.eof and i<=5%> <%
if rs("newsid")=cdbl(skipid) then
	rs.movenext
else
%> 
        <tr> 
          <td>  ◆<a href="comment.asp?newsid=<%=rs("newsid")%>"><%=rs("title")%></a> 
          </td>
        </tr>
        <%
rs.movenext
i=i+1
end if
wend
%> 
      </table>
    </td>
  </tr>
  <%end if%> 
  <tr> 
    <td height="16" bgcolor="006600" colspan="2" width="703"></td>
  </tr>
  <tr> 
    <td width="487" height="52">&nbsp; </td>
    <td align="right" width="214" height="52"> <%
if trim(c)<>"" then
	response.write "《"&c&"》"
end if
%>   <%=d%></td>
  </tr>
  <tr bgcolor="#FFFFFF" align="right"> 
    <td height="51" colspan="2" width="703">   
          <input type="submit" name="click" value="关闭窗口" class="botton" onclick="javascript:window.close()"> 
    </td> 
  </tr> 
</table> 
 
</body> 

⌨️ 快捷键说明

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