📄 user.asp
字号:
<!--#include file=../conn.asp-->
<!--#include file=usercookies.asp-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户管理</title>
<link rel="stylesheet" type="text/css" href="../1.css">
</head>
<body>
<div align="center">
<center>
<table border="1" cellPadding="3" cellSpacing="0" class="tableBorder" width="100%" style="border-collapse: collapse" bordercolor="#99CCFF">
<tr>
<form action="deluser.asp" method="post">
<th align="left" height="23" width="30%" style="border-right-style: solid; border-right-width: 1" bgcolor="#FFFFFF">
<span style="font-size: 9pt; font-weight:400">删除<font color="#FF0000">指定用户</font>的求职资料</span></th>
<th align="left" height="23" width="20%" bgcolor="#FFFFFF">
<span style="font-size: 9pt">
<span style="font-weight: 400">用户名:</span><input name="username" size="11" maxlength="20"> </span></th>
<th align="left" height="23" width="9%" bgcolor="#FFFFFF">
<input border="0" src="../img/x_1.gif" name="I1" type="image"></th>
<th align="left" height="23" width="41%" bgcolor="#FFFFFF">
<p align="center"><span style="background-color: #99CCFF">
<a onclick='{if(confirm("此操作将没有登陆过的用户和姓名没有填写的用户删除,建议你执行此操作前先备份数据库,以免出错!")){return true;}return false;}' href="deldlsjnone.asp"><font size="2">清除数据库中的<font color="#FF0000">垃圾用户</font></font></a></span></th>
</form>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="1" cellPadding="3" cellSpacing="0" class="tableBorder" width="100%" style="border-collapse: collapse; border-top-width: 0; border-bottom-width:0" bordercolor="#99CCFF">
<tr>
<form action="deldata.asp" method="post">
<th align="left" height="23" width="30%" style="border-top-style: none; border-top-width: medium; border-right-style:solid; border-right-width:1; border-bottom-style:none; border-bottom-width:medium" bgcolor="#FFFFFF" bordercolor="#99CCFF">
<span style="font-size: 9pt; font-weight:400">删除<font color="#FF0000">多少天</font>没有登陆的用户</span></th>
<th align="left" height="23" width="20%" style="border-top-style: none; border-top-width: medium; border-bottom-style:none; border-bottom-width:medium" bgcolor="#FFFFFF">
<span style="font-size: 9pt">
<input name="data" size="6" value="365" maxlength="10"><span style="font-weight: 400">天没有登陆</span> </span></th>
<th align="left" height="23" width="9%" style="border-top-style: none; border-top-width: medium; border-bottom-style:none; border-bottom-width:medium" bgcolor="#FFFFFF">
<input border="0" src="../img/x_1.gif" name="I2" type="image"></th>
<th align="left" height="23" width="41%" style="border-top-style: none; border-top-width: medium; border-bottom-style:none; border-bottom-width:medium" bgcolor="#FFFFFF">
<span style="font-size: 9pt; font-weight:400">
(只能为<font color="#F06000">数字</font>)</span></th>
</form>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="1" cellpadding="3" cellspacing="0" style="border-collapse: collapse; " bordercolor="#99CCFF" width="100%" height="27">
<form action="deldlcs.asp" method="post">
<tr>
<td width="30%" height="27" style="border-top-style: none; border-top-width: medium">
删除<font color="#FF0000">登陆次数</font>少于几次的用户</td>
<td height="27" style="border-top-style: none; border-top-width: medium" width="20%">
只<span style="font-size: 9pt">登陆了<input name="dlcs" size="6" value="5" maxlength="10">次</span></td>
<td width="9%" height="27" style="border-top-style: none; border-top-width: medium">
<input border="0" src="../img/x_1.gif" name="I2" type="image"></td>
<td width="41%" height="27" style="border-top-style: none; border-top-width: medium">
<span style="font-size: 9pt">
(只能为<font color="#F06000">数字</font>)</span></td>
</tr>
</form>
</table>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="50%" height="20"><form method="POST" action="">每页显示的记录数:<input type="text" name="usersize" size="3" value="50">
<input border="0" src="../img/x_1.gif" name="I2" type="image"></form></td>
<td width="50%" height="20"><form method="POST" action="">快速查找用户:<input type="text" name="username1" size="10">
<input border="0" src="../img/x_1.gif" name="I2" type="image">(输入用户名)</form>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-top-width:0" bordercolor="#111111" width="100%">
<tr>
<td width="34%" style="border-top-style: none; border-top-width: medium; border-right-style:none; border-right-width:medium" height="20" bgcolor="#99CCFF">
<p align="left"> </p></td>
<td width="33%" style="border-top-style: none; border-top-width: medium; border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium" height="20" bgcolor="#99CCFF">
<p align="center"><b><font color="#666666">个人会员管理</font></b></td>
<td width="33%" style="border-top-style: none; border-top-width: medium; border-left-style:none; border-left-width:medium" height="20" bgcolor="#99CCFF">
<%
dim total,sql,rs,y_BornDate,k,Pagesize,Allrecord,Allpage,ThisPage,usersize,xueli
k=0
sql="select count(id) from [person]"
total=conn.execute(sql)(0)
%>
<p align="center"><font color="#FFFFFF">目前个人会员总数:</font><font style="font-size: 9pt" color="#FF0000"><%=total%></font></td>
</tr>
</table>
<%
if request("page")="" then
ThisPage=1
else
ThisPage=request("page")
end if
dim cmdTemp
Set cmdTemp = Server.CreateObject("ADODB.Command")
set rs = server.CreateObject ("adodb.recordset")
if request("username1")="" then
sql="select id,username,jobid,name,age,xingbie,x_suozaidi,xueli,dlcs,dlsj,llcs from [person] order by id desc"
else
sql="select id,username,jobid,name,age,xingbie,x_suozaidi,xueli,dlcs,dlsj,llcs from [person] where UserName like '%"&request("UserName1")&"%'"
end if
cmdTemp.CommandText = sql
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = conn
rs.Open cmdTemp, , 1, 1
set cmdTemp=nothing
If rs.eof or rs.bof Then
response.write "没有用户数据!"
response.end
end if
if request("usersize")="" then
rs.Pagesize=50
else
rs.Pagesize=trim(request("usersize"))
end if
Pagesize=rs.Pagesize
Allrecord=rs.Recordcount
Allpage=rs.Pagecount
if ThisPage<1 then
ThisPage=1
end if
rs.move (ThisPage-1)*Pagesize
%>
</center>
</div>
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-width:0; border-collapse: collapse; " bordercolor="#111111" width="100%">
<tr>
<td width="100%" style="border-style:none; border-width:medium; " bgcolor="#FFFFFF" height="20">
<p align="left"><%call fenye%>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%">
<tr>
<td width="100" height="20" bgcolor="#E6F2FF" style="border-bottom-style: none; border-bottom-width: medium; border-left-style:solid; border-left-width:1" align="center">
用户名</td>
<td width="102" height="20" bgcolor="#E6F2FF" style="border-bottom-style: none; border-bottom-width: medium" align="center">
姓名</td>
<td width="52" height="20" bgcolor="#E6F2FF" style="border-bottom-style: none; border-bottom-width: medium" align="center">
性别</td>
<td width="70" height="20" bgcolor="#E6F2FF" style="border-bottom-style: none; border-bottom-width: medium" align="center">
学历</td>
<td width="55" height="20" bgcolor="#E6F2FF" style="border-bottom-style: none; border-bottom-width: medium" align="center">
年龄</td>
<td width="69" height="20" bgcolor="#E6F2FF" style="border-bottom-style: none; border-bottom-width: medium" align="center">
户籍</td>
<td height="20" bgcolor="#E6F2FF" style="border-bottom-style: none; border-bottom-width: medium" align="center" width="62">
<p align="left">
登陆次数</td>
<td height="20" bgcolor="#E6F2FF" style="border-bottom-style: none; border-bottom-width: medium" align="center" width="83">
<p>
简历查看</td>
<td height="20" bgcolor="#E6F2FF" style="border-bottom-style: none; border-bottom-width: medium" align="center" width="135">
<p align="left">
最后登陆时间</td>
<td width="190" height="20" bgcolor="#E6F2FF" style="border-bottom-style: none; border-bottom-width: medium; border-right-style:solid; border-right-width:1" align="center">
<p align="left"> </td>
</tr>
<%do while not rs.eof%>
<tr>
<td width="100" height="22" style="border-bottom-style: none; border-bottom-width: medium; border-left-style:solid; border-left-width:1" align="center" bordercolor="#CCCCCC" background="../img/bg.gif">
<a target="_blank" href="1.asp?jobid=<%=rs("jobid")%>">
<font color="#22446A"><%=rs("username")%></font></a></td>
<td width="102" height="22" style="border-bottom-style: none; border-bottom-width: medium" align="center" bordercolor="#CCCCCC" background="../img/bg.gif">
<a target="_blank" href="1.asp?jobid=<%=rs("jobid")%>">
<font color="#22446A"><%=trim(rs("name"))%></font></a></td>
<td width="52" height="22" style="border-bottom-style: none; border-bottom-width: medium" align="center" bordercolor="#CCCCCC" background="../img/bg.gif">
<%if rs("xingbie")<>false then%>男<%else%>女<%end if%></td>
<td width="70" height="22" style="border-bottom-style: none; border-bottom-width: medium" align="center" bordercolor="#CCCCCC" background="../img/bg.gif">
<%
xueli=rs("xueli")
if xueli=0 then
response.write "高中"
elseif xueli=1 then
response.write "中专"
elseif xueli=2 then
response.write "大专"
elseif xueli=3 then
response.write "本科"
elseif xueli=4 then
response.write "硕士"
elseif xueli=5 then
response.write "博士"
end if
%></td>
<td width="55" height="22" style="border-bottom-style: none; border-bottom-width: medium" align="center" bordercolor="#CCCCCC" background="../img/bg.gif">
<%=rs("age")%>岁</td>
<td width="69" height="22" style="border-bottom-style: none; border-bottom-width: medium" align="center" bordercolor="#CCCCCC" background="../img/bg.gif">
<%=rs("x_suozaidi")%></td>
<td height="22" style="border-bottom-style: none; border-bottom-width: medium" align="center" width="62" bordercolor="#CCCCCC" background="../img/bg.gif">
<%=rs("dlcs")%>次</td>
<td height="22" style="border-bottom-style: none; border-bottom-width: medium" align="center" width="83" bordercolor="#CCCCCC" background="../img/bg.gif">
<%=rs("llcs")%>次</td>
<td height="22" style="border-bottom-style: none; border-bottom-width: medium" align="left" width="135" bordercolor="#CCCCCC" background="../img/bg.gif">
<%=rs("dlsj")%></td>
<td width="190" height="22" style="border-bottom-style: none; border-bottom-width: medium; border-right-style:solid; border-right-width:1" align="left" bordercolor="#CCCCCC" background="../img/bg.gif">
<p align="center"><font color="#666666">
<a onclick='{if(confirm("此操作将删除用户{{{“<%=trim(rs("name"))%>”}}}!建议你执行此操作前先备份数据库,以免出错!")){return true;}return false;}' href="deluser.asp?username=<%=rs("jobid")%>">
<img border="0" src="images/del.gif" alt="删除"></a> <a href="edituser.asp?username=<%=rs("jobid")%>"><img border="0" src="images/edit.gif" alt="编辑"></a> </font>
<a href="adminqunfa.asp?username=<%=rs("username")%>&oo=person">
<img border="0" src="images/email.gif" alt="发送邮件"></a></td>
</tr>
<%
k=k+1
if k>=Pagesize then exit do
rs.movenext
loop
%>
</table>
</center>
</div>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-top-width: 0; border-left-width:0; border-right-width:0" bordercolor="#111111" width="100%" height="2">
<tr>
<td width="100%" style="border-top-style: none; border-top-width: medium; border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium" bgcolor="#FFFFFF" height="20">
<p align="left"><%call fenye%>
</td>
</tr>
</table>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<%sub fenye%>
<p >每页显示<b><font color="#F06000"><%=Pagesize%></font></b>条记录 总共<font color="#F06000"><b><%=Allpage%></b></font>页 目前第<b><font color="#F06000"><%=ThisPage%></font></b>页
<font face="宋体">【</font><a href=?page=1&usersize=<%=request("usersize")%>>首页</a><font face="宋体">】</font> <%if ThisPage<2 then%>上一页<%else%><a href=?page=<%=ThisPage-1%>&usersize=<%=request("usersize")%>>上一页</a><%end if%> <%if Allpage-ThisPage<1 then%>下一页<%else%><a href=?page=<%=ThisPage+1%>&usersize=<%=request("usersize")%>>下一页<%end if%></a>
<font face="宋体">【</font><a href=?page=<%=Allpage%>&usersize=<%=request("usersize")%>>尾页</a><font face="宋体">】</font></p>
<%end sub%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -