📄 showannounce.asp
字号:
<!--#include file="conn.asp"-->
<script language="JavaScript">
function closewindow()
{
window.close();
}
</script>
<%
dim id,rs,sql
id=trim(request("id"))
if id="" then
call list()
response.end
end if
Set rs =Server.CreateObject("ADODB.Recordset")
sql="select * from announce where announce_id="& id
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "没有新闻"
response.end
end if
%>
<body topmargin="3">
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FF9933" width="521" height="162">
<tr>
<td width="519" height="162">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="99%">
<tr>
<td width="69%">
<p align="right"> </td>
<td width="31%">
<p align="right">
<font size="2">
</font>
<font style="FONT-SIZE: 15px; COLOR: #000066; FONT-FAMILY: 宋体">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体">
<a class="yellow" href="javascript:closewindow();" target="_self" style="text-decoration: none; font-weight:700"> </a></span></font></td>
</tr>
<tr>
<td colspan="2">
<p align="center"><span style="font-size: 14pt; font-weight: 700"><%=rs("tile")%></span></td>
</tr>
<tr>
<td height="18" colspan="2"><%=rs("announce")%> </td>
</tr>
<tr>
<td height="23" colspan="2"><font size="2"> </font></td>
</tr>
<tr>
<td colspan="2">
<p align="right">
<b>
<font style="FONT-SIZE: 15px; COLOR: #000066; FONT-FAMILY: 宋体">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体">
<a class="yellow" href="javascript:closewindow();" target="_self" style="text-decoration: none">
<font color="#808080">关闭窗口</font></a></span></font><font size="2" color="#808080"><br>
</font></b></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
<%
rs.close
set rs=nothing
closedb
%>
</body>
<%
sub list()
dim k
Set rs =Server.CreateObject("ADODB.Recordset")
sql="select * from announce"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "没有新闻"
response.end
end if
k=0
%>
<body>
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FF9933" width="521" height="13">
<tr>
<td width="521" height="13">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="99%">
<tr>
<td width="8%" colspan="2"> </td>
<td width="64%"> </td>
<td width="28%"> </td>
</tr>
<tr>
<td width="2%"> </td>
<td width="6%" height="20">
<p align="center"><font size="2">编号</font></td>
<td width="64%" height="20"><font size="2">标题</font></td>
<td width="28%" height="20"><font size="2">发布时间</font></td>
</tr>
<%do while not rs.eof%><span style="font-size: 9pt">
<tr>
<td width="2%"> </td>
<td width="6%" height="20">
<p align="center">
<font size="2"><%=k+1%></font></td>
<td width="64%" height="20"><a href="javascript:win=open('showannounce.asp?id=<%=rs(0)%>','offer','width=560,height=450,status=no,menubar=yes,scrollbars=yes,top=0,left=0'); win.focus()">
<font size="2"><%=rs(3)%></font></a></td>
<td width="28%" height="20"><font size="2" color="#C0C0C0"><%=rs(2)%></font></td>
</tr>
<%
rs.movenext
k=k+1
loop
%>
<tr>
<td width="100%" colspan="4">
<p align="right">
<b>
<font style="FONT-SIZE: 15px; COLOR: #000066; FONT-FAMILY: 宋体">
<span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体">
<a class="yellow" href="javascript:closewindow();" target="_self" style="text-decoration: none">
<font color="#808080">关闭窗口</font></a></span></font></b></td>
</tr>
<tr>
<td width="100%" colspan="4"> </td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
</body>
<%
rs.close
set rs=nothing
closedb
end sub%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -