📄 my_zx.asp
字号:
<!--#include file="conn.asp"-->
<HEAD><TITLE>学生注销</TITLE>
<META http-equiv=Content-Language content=zh-cn>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="images/style.css" type=text/css rel=stylesheet>
</HEAD>
<BODY bgColor=#2f66bf >
<DIV align=center>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#111111 cellSpacing=0
cellPadding=0 width=763 border=0>
<TBODY>
<TR>
<TD width="100%"><!--#include file="head.asp"--></TD></TR></TBODY></TABLE>
<TABLE dir=ltr cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD vAlign=top>
<DIV align=center>
<TABLE height=830 cellSpacing=0 cellPadding=0 width=763 border=0>
<TBODY>
<TR>
<TD width=763 background=images/head_13.jpg height=15></TD></TR>
<TR>
<TD vAlign=top align=middle width=763
background=images/head_14.jpg height=49>
<TABLE id=AutoNumber3 style="BORDER-COLLAPSE: collapse"
borderColor=#111111 cellSpacing=0 cellPadding=0 width=763
border=0><TBODY>
<TR>
<TD width=11 rowSpan=4> </TD>
<TD width=741></TD>
<TD width=11 rowSpan=4> </TD></TR>
<TR>
<TD width=741></TD></TR>
<TR>
<TD width=741> </TD></TR>
<TR>
<TD width=741></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD width=763 background=images/head_16.jpg height=11></TD></TR>
<TR>
<TD width=763 background=images/head_11.jpg height=726>
<DIV align=center>
<TABLE id=table8 height="101%" cellSpacing=0 cellPadding=0
width="100%" border=0>
<TBODY>
<TR>
<TD vAlign=top align=middle width=187>
<!-- #include file="left.asp" -->
</TD>
<TD vAlign=top>
<TABLE id=table9 height=30 cellSpacing=0 cellPadding=0
width=571 border=0>
<TBODY>
<TR>
<TD width=12 background=images/sousuo_1.jpg> </TD>
<TD width=115 background=images/sousuo_2.jpg>
<TABLE id=table12 height=18 cellSpacing=0 cellPadding=0
width="100%" border=0>
<TBODY>
<TR>
<TD vAlign=top><FONT color=#ffffff><SPAN
style="FONT-SIZE: 12px"> 学 生 搜
索</SPAN></FONT></TD></TR></TBODY></TABLE></TD>
<TD background=images/sousuo_2.jpg> </TD>
<TD vAlign=top width=133
background=images/sousuo_2.jpg>
<FORM style="MARGIN: 0px" name="form1" action="search.asp" method="post">
<TABLE cellSpacing=0 cellPadding=0 width=390 border=0>
<TBODY>
<TR>
<TD width=56></TD>
<TD vAlign=top width=144><SPAN lang=zh-cn>
<SELECT class=smallSel size=1 name="searchid">
<OPTION value="Userid" selected name="typeid">=按登陆学号=</OPTION>
<OPTION value="UserName" name="typeid">=按学生姓名=</OPTION>
<OPTION value="Sex" name="typeid">=按学生性别=</OPTION>
<OPTION value="Birthday" name="typeid">=按出生年月=</OPTION>
<OPTION value="Banji" name="typeid">=按学生班级=</OPTION>
</SELECT></SPAN>
</TD>
<TD vAlign=top width=113>
<input name="searchkey" type="text" onfocus="this.value=''" size="10" maxlength="10" value=关键字>
</TD>
<TD width=77><DIV align=center>
<INPUT type=image src="images/sousuo_4.jpg" border=0 name=Submit value="开始查找" onclick="return checkk();"></DIV></TD></TR></TBODY></TABLE></FORM></TD></TD>
<TD width=15
background=images/sousuo_5.jpg> </TD></TR></TBODY></TABLE>
<TABLE id=table15 height=131 cellSpacing=0 cellPadding=0
width=568 border=0>
<TBODY>
<TR>
<TD width=146 background=images/bjbg_1.jpg height=35>
<!--#include file="md5.asp"-->
<TABLE id=table16 height=20 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=middle><FONT style="FONT-SIZE: 12px"
color=#ff0000>学 生 注 销</FONT></TD></TR></TBODY>
</TABLE></TD>
<TD width=422 height=35><IMG height=35 src="images/bjbg_2.jpg" width=422 border=0></TD></TR>
<TR>
<TD align=middle width=568 background=images/bjbg_3.jpg colSpan=2>
<table id=table28 height=162 align="center" cellSpacing=0 cellPadding=0 width=557 height=135 border=0>
<%
if request("edit")="ok" then call edit()
if request.cookies("userid")<>"" then
set rs=conn.execute("select * from [user] where UserId='"&request.cookies ("userid")&"'")
%>
<tr><td>
<form name="myzx" action="my_zx.asp" method="post">
<table width="80%" border="1" cellpadding="4" cellspacing="0" bordercolor="#C0C0C0" align=center bordercolordark="#FFFFFF">
<tr>
<td width="28%" align="right">注销学号</td>
<td width="72%"><%=rs("UserID")%><input type=hidden name="userid" value="<%=rs("UserID")%>"></td>
</tr>
<tr>
<td width="28%" align="right">学生姓名</td>
<td width="72%"><%=rs("UserName")%><input type=hidden value="<%=rs("UserName")%>"></td>
</tr>
<tr><td colspan=2 align=center>
<input type="submit" name="Submit" value="确认注销">
<input name="Submit2" type="reset" value="不要注销">
<input type=hidden name=edit value="ok">
</td></tr>
</table>
</form>
<%
rs.close
set rs=nothing
else response.Write" 还没有登陆怎么注销！"
end if
%>
</td></tr>
</TABLE>
<TR>
<TD width=568 colSpan=2 height=16><IMG height=16 src="images/bjbg_6.jpg" width=568 border=0></TD>
</TR>
</TABLE>
</TABLE></TD></TABLE>
<DIV align=center>
<CENTER>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#111111 height=76
cellSpacing=0 cellPadding=0 width=763 border=0>
<TBODY>
<TR>
<TD width=763 background=images/xiabg_3.jpg height=76>
<DIV align=center>
<TABLE id=table34 cellSpacing=0 cellPadding=0 width="98%" border=0>
<TBODY>
<TR>
<TD align=middle><FONT color=#051547><SPAN
style="FONT-SIZE: 12px">CopyRingt 2006
清水河源工作室</SPAN></FONT></TD>
</TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></CENTER></DIV>
<DIV></DIV></BODY>
<%
sub edit()
if submit="确认注销" then
response.write "<script language='javascript'>"
response.write "alert('同学，真的要注销了吗？');"
response.write "location.href='javascript:history.go(-1)';"
response.write "</script>"
response.end
end if
if submit2="不要注销" then
response.write "<script language='javascript'>"
response.write "location.href='javascript:history.go(-1)';"
response.write "</script>"
response.end
end if
if request.cookies("userid")<>"" then set rs=conn.execute("select * from [user] where UserId='"&request.cookies("userid")&"'")
if ucase(request.cookies("userid"))<>ucase(request.form("userid")) then
response.write "<script language='javascript'>"
response.write "alert('出错了，同学，您无权进行此操作。');"
response.write "location.href='javascript:history.go(-1)';"
response.write "</script>"
response.end
end if
conn.execute("delete from [user] where UserId='"&request.cookies("userid")&"' ")
response.write "<script language='javascript'>"
response.write "alert('操作成功，您已经注销您的学号。\n\n挥挥手不要带走一片云彩吆！');"
Session.abandon
response.cookies("userid")=""
response.write "location.href='index.asp';"
response.write "</script>"
response.end
end sub
conn.close
set conn=nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -