announce_manage.asp
来自「ASP,版本,HUANYING NI DE XIAZAI ! LIANXIFAN」· ASP 代码 · 共 80 行
ASP
80 行
<!--#include file="conn.asp"-->
<!--#include file="Cookies.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style1 {
font-family: "华文行楷";
font-size: 36px;
color: #0000FF;
}
.style2 {font-family: "宋体"}
.style3 {
font-size: 36;
color: #0000FF;
}
.style4 {color: #FF0000}
-->
</style>
</head>
<body>
<h1 align="center" class="style1">网站公告管理
</h1>
<%
dim k
Set rs =Server.CreateObject("ADODB.Recordset")
sql="select * from announce"
rs.open sql,conn,1,1
k=0
%>
<body>
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FF9933" width="720" height="13">
<tr>
<td width="100%" height="13">
<div align="center">
<table width="84%" height="45" border="1">
<tr>
<th width="91" scope="col"><font size="2">编号</font></th>
<th width="290" scope="col"><font size="2">标题</font></th>
<th width="126" scope="col"><font size="2">发布时间</font></th>
<th width="149" scope="col"> </th>
</tr>
<%do while not rs.eof%>
<tr>
<th scope="row"><font size="2"><%=k+1%></font></th>
<td><font size="2"><%=rs(3)%></font></td>
<td><font size="2" color="#C0C0C0"><%=rs(2)%></font></td>
<td><div align="center"><a href="delannounce.asp?id=<%=rs(0)%>" class="style4">删除</a> <a href="editannounce.asp?id=<%=rs(0)%>" class="style3">修改</a></div></td>
</tr>
<%
rs.movenext
k=k+1
loop
%>
</table>
<p><a href="addannounce.asp" class="style2">添加公告</a></p>
</div></td>
</tr>
</table>
</center>
</div>
</body>
<%
rs.close
set rs=nothing
closedb
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?