📄 admin_cslist.asp
字号:
<!--#include file="conn.asp"-->
<%
if session("admin_name")="" then
response.redirect "default.asp"
end if
gjc=request("gjc")
%>
<%
'开始删除操作
if request("del")="true" then
id=request("id")
conn.execute "delete * from search where id=" & id
url="admin_cslist.asp"
response.redirect url
end if
%>
<script language="JavaScript">
function CheckForm()
{
if(document.addgjc.gjc.value.length == 0)
{
alert("请输入关键词.");
document.addgjc.gjc.focus();
return false;
}
if(document.addgjc.cs.value.length == 0)
{
alert("请输入数字.");
document.addgjc.cs.focus();
return false;
}
return true;
}
</script>
<%
'开始添加
gjc=trim(request("gjc"))
ename=trim(request("ename"))
fname=trim(request("fname"))
cs=request("cs")
if request("action")="add" then
'开始检测是否重复登陆
set rs=server.createobject("ADODB.Recordset")
sql="select * from search where gjc='"&gjc&"' order by cs desc"
rs.open sql, conn, 1, 1
if not(rs.eof or rs.bof)then
response.write"<SCRIPT language=JavaScript>alert('对不起，您所添加的关键词已经存在, 请核实！');"
response.write"javascript:history.go(-1)</SCRIPT>"
rs.close
set rs=nothing
response.end
end if
conn.execute "insert into search (gjc,ename,fname,cs)values('"&gjc&"','"&ename&"','"&fname&"', '"&cs&"')"
response.write "<script language='javascript'>"
response.write "alert('关键词添加成功！');"
response.write "window.document.location.href='admin_cslist.asp';"
response.write "</script>"
Response.End
end if
%>
<html>
<head>
<title>后台管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<body bgcolor="#FFFFCC" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="1" cellpadding="2" vspace="0" hspace="0" bgcolor="#FFFFFF">
<tr bgcolor="#FFCC33">
<td height="27" bgcolor="#FFCC33" background="images/admin_bg_1.gif">.:: 网站搜索关键词管理 <input type="button" name="Submit2" value="添加搜索关键词" onClick="location.href='admin_cslist.asp?a=add'"></td>
</tr>
</table>
<%if request("a")="add" then%>
<table border="0" cellspacing="1" cellpadding="3" width="100%" align="center">
<form action="admin_cslist.asp" method="post" name="addgjc" onSubmit="return CheckForm();">
<tr>
<td bgcolor="#BBD1E8" width="25%" >简体
</td>
<td bgcolor="#BBD1E8" width="21%" >
<input type="text" name="gjc" size="26">
</td>
</tr>
<tr>
<td bgcolor="#BBD1E8" width="25%" >繁体
</td>
<td bgcolor="#BBD1E8" width="21%" >
<input type="text" name="fname" size="26">
</td>
</tr>
<tr>
<td bgcolor="#BBD1E8" width="25%" >英文
</td>
<td bgcolor="#BBD1E8" width="21%" >
<input type="text" name="ename" size="26">
</td>
</tr>
<tr>
<td bgcolor="#BBD1E8" width="25%" >排序（数字越大排列越前）
</td>
<td bgcolor="#BBD1E8" width="21%" >
<input type="text" name="cs" size="26">
</td>
</tr>
<tr bgcolor="#D6DFF7">
<td height="35" colspan="4">
<div align="center">
<input type="submit" name="Submit" value="添加" class="Submit">
<input type="reset" name="Submit" value="重填" class="Submit">
<input type="hidden" name="action" value="add">
</div>
</td>
</tr>
</form>
</table>
<%end if%>
<table border="0" cellspacing="1" cellpadding="2" width="100%" align="center" background="images/admin_bg_1.gif">
<%
page=clng(request("page"))
sql="select * from search order by cs desc"
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.open sql, conn, 1, 2
if rs.eof and rs.bof then
response.Write("暂时没有记录")
else
%>
<tr>
<td bgcolor="#6699CC" height="22" width="5%">ID</td>
<td bgcolor="#6699CC" width="23%">关键词</td>
<td bgcolor="#6699CC" width="9%">搜索次数</td>
<td bgcolor="#6699CC" colspan="2" >操作</td>
</tr>
<%
rs.PageSize=50
if page=0 then page=1
pages=rs.pagecount
if page > pages then page=pages
rs.AbsolutePage=page
for j=1 to rs.PageSize
%>
<tr bgcolor="#B0CBE6">
<td height="22" width="5%" ><%=rs("id")%></td>
<td width="23%"><%=rs("gjc")%></td>
<td width="9%"><%=rs("cs")%></td>
<td width="10%"><a href="admin_csedit.asp?id=<%=rs("id")%>">[查看|编辑]</a></td>
<td width="9%"> <a href="admin_cslist.asp?del=true&id=<%=rs("id")%>&gjc=<%=rs("gjc")%>&page=<%=cstr(pagecount)%>">[删除]</a>
</td>
</tr>
<%
rs.movenext
if rs.eof then exit for
next
%>
</table>
<table border="0" cellspacing="0" cellpadding="0" width="100%" align="center">
<tr><td height="35" colspan="9" bgcolor="#D6DFF7">
<form method=Post action="admin_cslist.asp">
<%if Page<2 then
response.write "首页 上一页 "
else
response.write "<a href=admin_cslist.asp?page=1><font color=white>首页</font></a> "
response.write "<a href=admin_cslist.asp?page=" & Page-1 & "><font color=white>上一页</font></a> "
end if
if rs.pagecount-page<1 then
response.write "下一页 尾页"
else
response.write "<a href=admin_cslist.asp?page=" &(page+1)& ">"
response.write "<font color=white>下一页</font></a> <a href=admin_cslist.asp?page="&rs.pagecount&"><font color=white>尾页</font></a>"
end if
response.write " 页次：<strong><font color=red>"&Page&"</font>/"&rs.pagecount&"</strong>页 "
response.write " 共<b><font color='#FF0000'>"&rs.recordcount&"</font></b>条记录 <b>"&rs.pagesize&"</b>条记录/页"
response.write " 转到：<input type='text' name='page' size=4 maxlength=10 class=input value="&page&">"
response.write " <input class=input type='submit' value=' Goto ' name='cndok'></span></p>"
%>
</form> </td>
</tr>
<%
end if
rs.close
set rs=nothing
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -