📄 admin_right.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="chkuser.asp"-->
<!--#include file="md5.asp"-->
<% if not administrator then
Response.Write("您不是管理员或无此权限，请不要进入管理中心，3秒后系统将自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='4; URL=admin_login.asp'>")
Response.end()
end if %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户管理</title>
<link href="../main.css" rel="stylesheet" type="text/css">
</head>
<body>
<% call main() %>
</body>
</html>
<%sub main()%>
<table cellpadding=0 cellspacing=0 border=0 width=450 align=center>
<tr>
<td>
<table cellpadding=3 cellspacing=1 border=0 width=100%>
<tr >
<td><font color="#000000">欢迎<b>您</b>进入管理页面</font>
</td>
</tr>
<tr bgcolor="#e0e0e0">
<td width="100%" valign=top>
<%
if request("action") = "del" then
call del()
elseif request("action")="edit" then
call edit()
elseif request("action")="savedit" then
call savedit()
elseif request("action")="add" then
call add()
elseif request("action")="save" then
call save()
else
call list()
end if
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%end sub%>
<% sub del()
sql = " delete from [admin] where id="&request("id")
conn.execute(sql)
Response.Write("删除成功，2秒后系统将自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_right.asp'>")
end sub%>
<% sub edit()
sql = "select * from [admin] where id="&request("id")
set rs= Server.CreateObject("adodb.recordset")
rs.open sql,conn,0,1
%>
<table width="500">
<tr><td>
<form name="mainfrm" method="post" action="admin_right.asp?action=savedit">
<table width="500" border="0">
<tr>
<td>用户名:<%= rs("name") %></td>
<td><input name="submit" type="submit" value="确定"><input name="id" type="hidden" value="<%= rs("id") %>"></td>
</tr>
<tr>
<td>密码问题:<%= rs("question") %></td>
<td><input type="checkbox" name="poweruser" value="1">
新闻管理权限 </td>
</tr>
<tr>
<td>密码答案:<%= rs("answer") %></td>
<td><input type="checkbox" name="administrator" value="1">
用户管理权限</td>
</tr>
</table>
</form>
</td></tr></table>
<% rs.close
set rs = nothing
end sub %>
<% sub savedit()
sql = " select * from [admin] where id="&request.form("id")
set rs = Server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
if rs.eof and rs.bof then
Response.Write("参数错误,2秒后系统自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_right.asp'>")
else
dim flagp,flaga
if Request.Form("poweruser")=1 then
flagp = 1
else
flagp=0
end if
if Request.Form("administrator")=1 then
flaga = 1
else
flaga=0
end if
rs("flag")=flagp&"|"&flaga
rs.update
rs.close
set rs = nothing
Response.Write("更新成功,2秒后系统自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_right.asp'>")
end if
end sub
%>
<% sub list()%>
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td>
<a href="admin_right.asp?action=add">添加管理员</a>
</td>
</tr>
<tr>
<td>注意事项： <br>
在下面，您将看到目前所有的管理员。您可以修改其权限或删除目前存在的管理员。
</td>
</tr>
</table>
<%
dim pgsz,total,pageno,ScrollAction
dim pagebegin,pagend,position,rowcount
PgSz=5
dim totalPut
dim CurrentPage, TotalPages
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
set rs= server.createobject ("adodb.recordset")
sql = " select * from [admin] order by id"
rs.open sql,conn,1,3
if rs.eof and rs.bof then
Response.Write("目前数据库为空。")
else
RS.PageSize = Cint(PgSz)
Total=INT(RS.recordcount / PgSz * -1)*-1 ''计算可显示页面的总数
PageNo=Request("pageno")
if PageNo="" Then
PageNo=1
else
PageNo=PageNo+1
PageNo=PageNo-1
end if
ScrollAction=Request("ScrollAction")
if ScrollAction="上一页" Then
PageNo=PageNo-1
end if
if ScrollAction="下一页" Then
PageNo=PageNo+1
end if
if PageNo<1 Then
PageNo=1
end if
RS.AbsolutePage=PageNo
position=RS.PageSize*PageNo
pagebegin=position-RS.PageSize+1
if position < RS.RecordCount then
pagend=position
else
pagend= RS.RecordCount
end if
Response.Write "<font color=ffffff>共有["&RS.RecordCount&"]用户,显示["&pagebegin&"-"&pagend&"]</font>"
RowCount = RS.PageSize
Do While Not RS.EOF and rowcount > 0
%>
<hr width=60% align=left color=black height=1>
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td height="20"><font size="2">序号：<b><font color=red><%=rs("id")%></font></b></font></td>
</tr>
<tr>
<td height="20"><font color="#000000" size="2">用户名：<%=rs("name")%></font></td>
</tr>
<tr align="left" valign="bottom">
<td height="20"><font color="#000000" size="2"><a href="admin_right.asp?action=edit&id=<%=rs("id")%>">编辑</a>
| <a href="admin_right.asp?action=del&id=<%=rs("id")%>">删除</a></font></td>
</tr>
</table>
<%
RowCount =RowCount -1
RS.MoveNext
Loop
rs.close
set rs=nothing
%>
<form method="post" action="admin_right.asp">
<input type="HIDDEN" name="pageno" value="<%=PageNo %>">
<%
if PageNo > 1 Then
response.write "<input type=submit name=ScrollAction value=上一页 style=background-color:e0e0e0;color:000000;border: 1 double>"
end if
if RowCount = 0 and PageNo <>Total then
response.write "<input type=submit name=ScrollAction value=下一页 style=background-color:e0e0e0;color:000000;border: 1 double>"
end if
%>
</FORM>
<%
end if
end sub%>
<% sub add()
%>
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><form name="main" method="post" action="admin_right.asp?action=save">
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" align="center"> </td>
</tr>
<tr>
<td width="120" height="23" align="left" valign="middle">用户名 </td>
<td width="330" height="23" align="left" valign="middle">
<input name="name" type="text" id="name" size="20" maxlength="50"></td>
</tr>
<tr>
<td width="120" height="23" align="left" valign="middle"> 密 码
</td>
<td width="330" height="23" align="left" valign="middle">
<input name="pass" type="password" id="content2" value="" size="20"></td>
</tr>
<tr>
<td width="120" height="23" align="left" valign="middle">密码问题</td>
<td width="330" height="23" align="left" valign="middle">
<input name="question" type="text" id="question"></td>
</tr>
<tr>
<td width="120" height="23" align="left" valign="middle">密码答案</td>
<td width="330" height="23" align="left" valign="middle">
<input name="answer" type="text" id="answer"></td>
</tr>
<tr>
<td width="120" height="23" align="left" valign="middle">新闻管理权限</td>
<td width="330" height="23" align="left" valign="middle">
<input type="checkbox" name="poweruser" value="1"></td>
</tr>
<tr>
<td width="120" height="23" align="left" valign="middle">用户管理权限</td>
<td width="330" height="23" align="left" valign="middle">
<input type="checkbox" name="administrator" value="1"></td>
</tr>
<tr>
<td height="25" colspan="2" align="center"> <input type="submit" name="Submit" value="提交"> <input name="reset" type="reset" id="reset" value="重置">
</td>
</tr>
</table>
</form></td>
</tr>
</table>
<% end sub %>
<% sub save()
if Request.Form("poweruser")=1 then
flagp= 1
else
flagp=0
end if
if Request.Form("administrator")=1 then
flaga = 1
else
flaga=0
end if
dim flag
flag = flagp&"|"&flaga
sql = " insert into admin (name,pass,question,answer,flag) values ('"&request("name")&"','"&md5(request("pass"))&"','"&request("question")&"','"&md5(request("answer"))&"','"&flag&"') "
conn.execute(sql)
Response.Write("添加成功,2秒后系统自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_right.asp'>")
end sub%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -