📄 sitelink.asp
字号:
<!--#include file="mdb_path_info.asp"-->
<HTML><HEAD><TITLE>后台管理 </TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="admin.css" type=text/css rel=stylesheet>
</HEAD>
<BODY leftMargin=0 topMargin=0>
<table width="100%" border="0" cellspacing="2">
<tr>
<td class="b1" valign="top">
<%
dim isedit
select case request("action")
case "saveadd"
call SaveAdd()
case "modify"
call SaveModify()
case "edit"
isEdit=True
call myform()
case "add"
isEdit=False
call myform()
case "del"
call del()
case "isActive"
call isActive()
case else
call Viewlist()
end select
sub del()
conn.execute("delete from SiteLink where id="&Trim(Request.QueryString("ID")))
call Viewlist()
end sub
sub isActive()
conn.execute("update MySiteLink set isActive=0")
conn.execute("update MySiteLink set isActive=true where ID="&Trim(Request.Form("isActive")))
call Viewlist()
end sub
sub SaveModify()
set rs=server.createobject("adodb.recordset")
sql="select * from SiteLink where ID="&request.form("ID")
rs.open sql,conn,1,3
rs("MySiteName")=request.form("MySiteName")
rs("MySiteURL")=request.form("MySiteURL")
rs("Logo")=request.form("Logo")
rs("Readme")=Trim(Request.Form("Readme"))
rs("isLogo")=Request.Form("islogo")
rs.update
rs.close
set rs=nothing
response.write"保存修改"
response.write"<li>修改成功!<li><a href=""SiteLink.asp"">返回列表</a></li>"
end sub
sub SaveAdd()
set rs=server.createobject("adodb.recordset")
sql="select * from SiteLink where (ID is null)"
rs.open sql,conn,1,3
rs.addnew
rs("MySiteName")=request.form("MySiteName")
rs("MySiteURL")=request.form("MySiteURL")
rs("Logo")=request.form("Logo")
rs("Readme")=Trim(Request.Form("Readme"))
rs("isLogo")=Request.Form("islogo")
rs("Hits")=0
rs("DateTime")=Now()
rs.update
rs.close
set rs=nothing
response.write"添加"
response.write"<li>添加成功!<li><a href=""SiteLink.asp"">返回列表</a></li>"
end sub
'=================================
sub ViewList()
%>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableBorder">
<tr class="tdbg1">
<th>ID</th>
<th>名称 [<a href="SiteLink.asp?action=add">添加</a>]</th>
<th width="90">人气</th>
<th width="90">LOGO</th>
<th width="90">编辑</th>
</tr>
<form action="SiteLink.asp" method="post" name="viewlist">
<% Set Rs=server.createobject("adodb.recordset")
sql="select * from SiteLink "
rs.open sql,conn,1,1
if not(rs.eof and rs.bof) then
do while not rs.eof
%>
<tr class="tdbg2">
<td align="center"><%=rs("ID")%></td>
<td><a href="<%=rs("MySiteURL")%>" target="_blank"><%=rs("MySiteName")%></a></td>
<td align="center"><%=rs("Hits")%></td>
<td align="center">
<% if rs("islogo")=1 then
Response.Write("是")
else
Response.Write("否")
end if %>
</td>
<td>
<%
Response.Write(" （<a href=""SiteLink.asp?action=edit&id="&rs("id")&""">修改</a> | ")
Response.Write("<a href=""SiteLink.asp?action=del&id="&rs("id")&""">删除</a> ）")
%>
</td>
</tr>
<% rs.movenext
loop
else
Response.Write("<tr><td colspan=""2"" bgcolor=""#FFFFFF"">没有找到任何记录！</td></tr>")
end if
rs.close
Set Rs=nothing %>
</form>
</table>
<%
end sub
'================================
sub myform
if isedit then
set rs=server.createobject("adodb.recordset")
sql = "select * from SiteLink where id="&Trim(Request.QueryString("id"))
rs.open sql,conn,1,1
msgTitle="修改"
else
msgTitle="添加"
end if
%>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableBorder">
<form action="SiteLink.asp" method="post" name="myform">
<tr>
<th colspan="2" class="tdbg1">
<% if isedit then
Response.Write("<input type=""Hidden"" name=""action"" value=""modify"">")
Response.Write("<input type=""Hidden"" name=""ID"" value="""&Trim(Request.QueryString("id"))&""">")
else
Response.Write("<input type=""Hidden"" name=""action"" value=""saveadd"">")
end if
Response.Write(msgTitle)
%>
</th>
</tr>
<tr class="tdbgleft">
<td align="center">网站名称</td>
<td > <input name="MySiteName" type="text" value="<% if isedit then response.write trim(rs("MySiteName"))%>" size="40" maxlength="50"> </td>
</tr>
<tr class="tdbgleft">
<td align="center">网站URL</td>
<td><input name="MySiteURL" type="text" value="<% if isedit then response.write trim(rs("MySiteURL"))%>" size="40" maxlength="50"> </td>
</tr>
<tr class="tdbgleft">
<td align="center">网站LOGO</td>
<td><input name="Logo" type="text" value="<% if isedit then response.write trim(rs("LOGO"))%>" size="40" maxlength="50"> </td>
</tr>
<tr class="tdbgleft">
<td align="center">网站简介<br> </td>
<td> <textarea name="Readme" cols="50" rows="7"><% if isedit then Response.Write(rs("Readme"))%></textarea>
</td>
</tr>
<tr class="tdbgleft">
<td align="center">链接方式</td>
<td>
<input type="radio" name="islogo" value="0" <%if isedit then
if rs("islogo")=0 then Response.Write "checked"
else
Response.Write "checked"
end if%>>文字连接
<input type="radio" name="islogo" value="1" <%if isedit then
if rs("islogo")=1 then Response.Write "checked"
end if%>>LOGO连接 </td>
</tr>
<tr class="tdbgleft">
<td align="center"> </td>
<td> <input type="submit" name="Submit" value="提交"> <input type="reset" name="Submit2" value="重置"></td>
</tr>
</form>
</table>
<%
if edit then rs.close:set rs=nothing
end sub %>
</td>
</tr>
</table>
</BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -