📄 newslist.asp
字号:
<!--#include file=function.asp-->
<%CheckAdmin3%>
<!--#include file="conn.asp"-->
<%
'开始删除操作
if request("del")="true" then
conn.execute "delete * from Activity where o_id=" & request("id")
url="newslist.asp?page=" & request("page")
response.redirect url
end if
%>
<html>
<head>
<LINK href="../style.css" rel=stylesheet type=text/css>
<title>OWEN 活动管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body topmargin="0" leftmargin="0" bgcolor="#9999CC">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="15%" valign="top" bgcolor="#9999CC" style="border-right: 1 solid #000000">
<!--#include file="left.asp"-->
</td>
<td width="85%" valign="top" bgcolor="#D8D8EB"><br>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr align="center" bgcolor="#FFFFFF">
<td height="24" colspan="5">活动项目表</td>
</tr>
<tr align="center" bgcolor="#BDBDDD">
<td width="4%" height="24">ID</td>
<td width="44%">标题</td>
<td width="29%">日期</td>
<td width="6%">点击</td>
<td width="17%">管理</td>
</tr>
<%
sql="select * from Activity order by o_id desc"
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,1
do while not rs.eof
%>
<tr align="center" bgcolor="#FFFFFF">
<td height="22"><%=rs("o_id") %></td>
<td><a href="../shownews.asp?o_id=<%=rs("o_id")%>" target="_blank"><%=rs("o_title") %></a></td>
<td><%=rs("o_date") %></td>
<td><%=rs("hits") %></td>
<td bgcolor="#FFFFFF"><a href="adminnews.asp?modio_title=<%=rs("o_title")%>&o_content=<%=rs("o_content")%>&check=<%=rs("check")%>&a=m">修改</a>
<a href="adminnews.asp?delnews=<%=rs("o_title")%>&a=d">删除</a></td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</table>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -