📄 edit.asp
字号:
<!--#include file="../manage/check-0.asp"-->
<!--#include file="../conn/conn.asp"-->
<%
dim conn,rs
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select * From sia_news Order By id DESC", conn, 3, 2
%>
<%if rs.eof and rs.bof then%>
<title>发现错误！</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../conn/css.css" rel="stylesheet" type="text/css">
</head>
<table width="40%" border="0" cellspacing="10" cellpadding="0" align="center" class="table">
<tr>
<td>
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolordark="#FFFFFF" bordercolorlight="#000000">
<tr>
<td> </td>
</tr>
<tr>
<td align="center"><b><font color="#FF0000">没有任何记录!!!</font></b></td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center"><a href="add.asp">点击这里添加新记录</a></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
<%else%>
<%
order=0
count=rs.RecordCount
pagesize=5
pagecount=count\(pagesize+1)+1
page=request.QueryString("page")
if page="" then
page=1
end if
%><html>
<head>
<title>西亚购物系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../conn/css.css" rel="stylesheet" type="text/css">
<body bgcolor="#FFFFFF" text="#000000">
<form name="del" method="post" action="del.asp">
<p> </p>
<table width="650" align="center" bordercolordark="#FFFFFF" bordercolorlight="#000000">
<tr valign="middle" bgcolor="#CCCCCC">
<td height="25" colspan="5" align="center"><a href="add.asp">添加记录</a><font color="#1478eb">
</font>|<font color="#1478eb"> </font><a href="edit.asp">管理记录</a></td>
</tr>
<tr valign="middle" bgcolor="#f1f1f1">
<td width="10%" height="25" align="center">ID</td>
<td height="25" align="center">新 闻 标 题</td>
<td width="10%" align="center">添加时间</td>
<td width="10%" height="25" align="center">阅读人次</td>
<td width="10%" height="25" align="center">删 除</td>
</tr>
<%
if not rs.eof then
rs.Move (page-1)*pagesize
cc=(page-1)*pagesize
do while (not rs.eof) and (order<pagesize)
cc=cc+1
order=order+1
%>
<tr valign="middle" bgcolor="#f1f1f1">
<td height="25" align="center"><%=cc%></td>
<td height="25"><a href="index.asp?id=<%=rs("id")%>" OnClick='return openAdminWindow(this.href);'><%=rs("title")%></a>
<script language=""javascript"">function openAdminWindow(url) { popupWin = window.open(url,'new_page','scrollbars=yes,width=350,height=430'); return false;}</script></td>
<td align="center"><%=rs("date")%></td>
<td height="25" align="center"><%=rs("visits")%></td>
<td height="25" align="center"> <input type="checkbox" name="sel<%=cc%>">
<input type=hidden name=id<%=cc%> value=<%=rs("id")%>></td>
</tr>
<%
rs.movenext
loop
end if
%>
<tr align="center" valign="middle" bgcolor="#f1f1f1">
<td height="25" colspan="5"> <%if page>1 then%> <a href="edit.asp?page=1">第一页</a> <a href="edit.asp?page=<%=page-1%>">上
页</a> <%end if%> <%if (page-pagecount)<0 then%> <a href="edit.asp?page=<%=(page+1)%>">下
页</a> <a href="edit.asp?page=<%=pagecount%>">最后页</a>
<%end if%> </td>
<tr align="center" valign="middle" bgcolor="#f1f1f1">
<td height="25" colspan="5"> <input type=hidden name=coun value=<%=cc%>>
<input type="submit" class="textbox-1" value="确定"> <input type="reset" class="textbox-1" value="重写">
</td>
</tr>
</table>
</form>
</body>
</html>
<%end if
rs.close
set rs=nothing%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -