📄 find_class5.asp
字号:
<%@ Language=VBScript %>
<!--#include file=globals.asp -->
<%userid=session("userid")
realname=session("realname")
curclassid=trim(session("curclassid"))
if curclassid="" then
curclassid=trim(request.form("classid"))
end if
userstatus=trim(request.form("userstatus"))
if userstatus="" then
userstatus="成员"
end if
if userid="" then
response.redirect "error.asp?info=对不起，您已经掉线了，请重新申请！"
end if
set rs = createobject("ADODB.recordset")
set rss = createobject("ADODB.recordset")
sql="select * from userjoinclassinfo where userid='"&userid&"' and classid='"&curclassid&"'"
rs.open SQL,schooldb
if not rs.eof then
response.redirect "error.asp?info=对不起，您已经是这个班的成员了！"
end if
rs.close
sql="select * from classinfo where classid='"&curclassid&"'"
rs.open SQL,schooldb
if not rs.eof then
classname=rs("classname")
else
response.redirect "error.asp?info=对不起，该班级不存在！"
end if
rs.close
sql="select * from userjoinclassinfo"
rs.open SQL,schooldb,1,3
rs.addnew
rs("logintimes")=0
rs("joindate")=now()
rs("lastlogintime")=now()
rs("userid")=userid
rs("classid")=curclassid
rs("userstatus")=userstatus
rs.update
rs.close
schoolid=left(curclassid,8)
sql="select * from schoolinfo where schoolid='"&schoolid&"'"
rs.open SQL,schooldb
if not rs.eof then
schoolname=rs("schoolname")
end if
rs.close
sql="select * from usercommunicationinfo where userid='"&userid&"'"
rs.open SQL,schooldb
if not rs.eof then
mailto=rs("email")
end if
rs.close
sql="select * from userjoinclassinfo where classid='"&curclassid&"'"
rs.open SQL,schooldb
while not rs.eof
if userid<>rs("userid") then
sql1="select * from userinfo where userid='"&userid&"'"
rss.open SQL1,schooldb
if not rss.eof then
currealname=rss("realname")
end if
rss.close
sql1="select * from usercommunicationinfo where userid='"&rs("userid")&"'"
rss.open SQL1,schooldb
if not rss.eof then
curemail=rss("email")
end if
rss.close
Set MailObject = nothing
end if
rs.movenext
wend
rs.close
Session.Abandon
%>
<html>
<head>
<title>中国 创网－校友录-加入班级成功！</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="keywords" content="同学、同学录、校友、老师、学校、班级、交流">
<STYLE type=text/css>
</STYLE>
<LINK href="scss.css" rel=stylesheet>
</head>
<body bgcolor="#FFFFFF" text="#000000" topmargin="5"><CENTER>
<!--#include file=top2.htm-->
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="760" align="center">
<!-- fwtable fwsrc="Untitled" fwbase="classlist.gif" fwstyle="Dreamweaver" fwdocid = "742308039" fwnested="0" -->
<tr>
<td><img src="spacer.gif" width="7" height="1" border="0"></td>
<td><img src="spacer.gif" width="121" height="1" border="0"></td>
<td><img src="spacer.gif" width="5" height="1" border="0"></td>
<td><img src="spacer.gif" width="15" height="1" border="0"></td>
<td><img src="spacer.gif" width="9" height="1" border="0"></td>
<td><img src="spacer.gif" width="7" height="1" border="0"></td>
<td><img src="spacer.gif" width="105" height="1" border="0"></td>
<td><img src="spacer.gif" width="255" height="1" border="0"></td>
<td><img src="spacer.gif" width="101" height="1" border="0"></td>
<td><img src="spacer.gif" width="100" height="1" border="0"></td>
<td><img src="spacer.gif" width="28" height="1" border="0"></td>
<td><img src="spacer.gif" width="7" height="1" border="0"></td>
<td><img src="spacer.gif" width="1" height="1" border="0"></td>
</tr>
<tr>
<td colspan="3" background="img/classlist_r1_c1.gif"> </td>
<td background="img/classlist_r1_c4.gif"> </td>
<td colspan="2" background="img/classlist_r1_c5.gif"> </td>
<td colspan="3" background="img/classlist_r1_c5.gif"> </td>
<td colspan="3"><img name="classlist_r1_c10" src="img/classlist_r1_c10.gif" width="135" height="45" border="0"></td>
<td><img src="spacer.gif" width="1" height="45" border="0"></td>
</tr>
<tr>
<td rowspan="7" background="img/classlist_r2_c1.gif"> </td>
<td rowspan="7" valign="top">
<!--#include file=ad.asp -->
</td>
<td rowspan="7" valign="top" background="img/classlist_r2_c3.gif"> </td>
<td colspan="8" bgcolor="#FFFFCC"><a href="/alumni/">中国 创网－校友录</a>>>>创建学校>>>>填写资料</td>
<td rowspan="8" background="img/classlist_r2_c12.gif"> </td>
<td><img src="spacer.gif" width="1" height="25" border="0"></td>
</tr>
<tr>
<td colspan="4"><img name="classlist_r3_c4" src="img/classlist_r3_c4.gif" width="136" height="35" border="0"></td>
<td colspan="4" background="img/classlist_r3_c8.gif" valign="bottom">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" class="topic"><span class="cn">欢迎您！</span><font color="#FF0000"><b><%=userid%></b></font></td>
</tr>
</table>
</td>
<td><img src="spacer.gif" width="1" height="35" border="0"></td>
</tr>
<tr>
<td colspan="4"><img name="classlist_r4_c4" src="img/classlist_r4_c4.gif" width="136" height="10" border="0"></td>
<td colspan="3"><img name="classlist_r4_c8" src="img/classlist_r4_c8.gif" width="456" height="10" border="0"></td>
<td rowspan="5"> </td>
<td><img src="spacer.gif" width="1" height="10" border="0"></td>
</tr>
<tr>
<td rowspan="4" colspan="2"> </td>
<td colspan="5" rowspan="2" valign="top">
<div align="center">
<center>
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td align="center" valign="top" bgcolor="#F6F6F6"> <br>
<br>
<table width="98%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td height="40" valign="bottom" align="center"> </td>
</tr>
</table>
<br>
<table width="510" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" class="cn" height="30"><font color="#CC0000">
恭喜您！您已经注册成为班级:<%=schoolname%> <%=classname%>的一名成员了！</font></td>
</tr>
</table>
<br>
<table width="500" border="0" cellspacing="1" cellpadding="1">
<form name="form1" method="post" action="ClassLogin.asp">
<tr>
<td class="cn" height="28">请您使用用户名和密码登录同学录您的班级－－－－</td>
</tr>
<tr>
<td align="center" height="30" valign="bottom">
<div align="left">用户名：
<input type="text" name="userid" size="20">
</div>
</td>
</tr>
<tr>
<td align="center" height="30" valign="bottom">
<div align="left">密 码：
<input type="password" name="password" size="0" maxlength="12">
</div>
</td>
</tr>
<tr>
<td height="40" align="center">
<div align="left">
<input type="submit" name="Submit" value="登录">
</div>
</td>
</tr>
</form>
</table>
<br>
<br>
<table width="510" border="0" cellspacing="1" cellpadding="1">
<tr align="center">
<td><a href="index.asp"><font color="#000000">返回同学录首页</font></a></td>
</tr>
</table>
<br>
<br>
<br>
</td>
</tr>
</table>
</center>
</div>
</td>
<td><img src="spacer.gif" width="1" height="23" border="0"></td>
</tr>
<tr>
<td><img src="spacer.gif" width="1" height="402" border="0"></td>
</tr>
<tr>
<td colspan="5">
<table width="100%" border="1" cellspacing="0" cellpadding="0" height="63">
<tr>
<td bgcolor="EAFBFF" bordercolor="EAFBFF"> <font color="#006699">如果您确认校友录中不存在您的学校，请直接点击<a href="find_class1.asp">创建学校</a><br>
提示：学校重复建设将会给您的校友使用校友录带来不便！ </font></td>
</tr>
</table>
</td>
<td><img src="spacer.gif" width="1" height="71" border="0"></td>
</tr>
<tr>
<td colspan="5"> </td>
<td><img src="spacer.gif" width="1" height="28" border="0"></td>
</tr>
<tr>
<td><img name="classlist_r9_c1" src="img/classlist_r9_c1.gif" width="7" height="7" border="0"></td>
<td><img name="classlist_r9_c2" src="img/classlist_r9_c2.gif" width="121" height="7" border="0"></td>
<td><img name="classlist_r9_c3" src="img/classlist_r9_c3.gif" width="5" height="7" border="0"></td>
<td colspan="2"><img name="classlist_r9_c4" src="img/classlist_r9_c4.gif" width="24" height="7" border="0"></td>
<td colspan="5"><img name="classlist_r9_c6" src="img/classlist_r9_c6.gif" width="568" height="7" border="0"></td>
<td><img name="classlist_r9_c11" src="img/classlist_r9_c11.gif" width="28" height="7" border="0"></td>
<td><img src="spacer.gif" width="1" height="7" border="0"></td>
</tr>
</table>
</center>
</div>
<br>
<br>
<CENTER>
<p></p>
<!--#include file=end.htm--> </body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -