📄 find_class3.asp
字号:
<%@ Language=VBScript %>
<!--#include file=globals.asp -->
<%userid=session("userid")
provinceid=trim(request.form("provinceid"))
areaid=trim(request("areaid"))
schooltypeid=int(trim(request("schooltypeid")))
keyword=trim(request("keyword"))
if keyword="" then
response.redirect "error.asp?info=请输入学校名的关键字！"
end if
%>
<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-->
<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><b class="cn">:</b><span class="cn">请按照下面的步骤查找和创建您的班级！</span></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>
<%
if Request("Page")<>"" then
Page = CLng(Request("Page"))
end if
If Page < 1 Then
Page = 1
end if
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td height="26" width="20" valign="middle"><img src="school_images/topic_inco1.gif" width="15" height="15"></td>
<%
PageSize=5
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select count(*) as a from schoolinfo where schooltypeid="&schooltypeid&" and schoolid like '"&areaid&"%' and schoolname like '%"&keyword&"%'"
rs.open SQL,schooldb,1,3
count=rs("a")
PageCount=CInt(rs("a")/PageSize+0.5)
rs.Close
%>
<td height="20" valign="middle">根据您的关键字搜索到 <%=count%> 所学校，请选择加入：</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<form name="form1" method="post" action="find_class4.asp">
<%
if page=1 then
SQL="select top 5 * from schoolinfo where schooltypeid="&schooltypeid&" and schoolid like '"&areaid&"%' and schoolname like '%"&keyword&"%' order by schoolid "
else
SQL="select top 5 * from schoolinfo where schooltypeid="&schooltypeid&" and schoolid like '"&areaid&"%' and schoolname like '%"&keyword&"%' and schoolid not in (Select top "&Cstr(PageSize*(page-1))&" schoolid from schoolinfo where schooltypeid="&schooltypeid&" and schoolid like '"&areaid&"%' and schoolname like '%"&keyword&"%' order by schoolid ) order by schoolid"
end if
rs.open SQL,schooldb
while not rs.eof
schoolname=replace(rs("schoolname"),keyword,"<font color=red>"&keyword&"</font>")
%>
<tr>
<td height="28" bgcolor="#EBEBEB">
<input type="radio" name="schoolid" value="<%=rs("schoolid")%>">
<%=schoolname%></td>
</tr>
<%
rs.movenext
wend
rs.close
%>
<tr>
<td height="28" bgcolor="#CCCCCC" align="center" class="topic">当前页数<%=page%>/<%=pagecount%>页
| <a href="find_class3.asp?page=1&&areaid=<%=areaid%>&schooltypeid=<%=schooltypeid%>&keyword=<%=keyword%>">第一页</a>
| <a href="find_class3.asp?page=<%=page-1%>&areaid=<%=areaid%>&schooltypeid=<%=schooltypeid%>&keyword=<%=keyword%>">上一页</a>
| <a href="find_class3.asp?page=<%=page+1%>&areaid=<%=areaid%>&schooltypeid=<%=schooltypeid%>&keyword=<%=keyword%>">下一页</a>
| <a href="find_class3.asp?page=<%=pagecount%>&areaid=<%=areaid%>&schooltypeid=<%=schooltypeid%>&keyword=<%=keyword%>">末页</a>
| </td>
</tr>
<% if count=0 then
response.write "</center><font color=red>对不起，没有你要找的学校！</font></cener>"
end if
%>
<tr>
<td height="30" bgcolor="#F6F6F6"> 你要加入的班级是哪一级的？（以入学年份为准）：
<select name=enterdate>
<option value="0" selected>请选择…</option>
<option value=1970>1970年</option>
<option value=1971>1971年</option>
<option value=1972>1972年</option>
<option value=1973>1973年</option>
<option value=1974>1974年</option>
<option value=1975>1975年</option>
<option value=1976>1976年</option>
<option value=1977>1977年</option>
<option value=1978>1978年</option>
<option value=1979>1979年</option>
<option value=1980>1980年</option>
<option value=1981>1981年</option>
<option value=1982>1982年</option>
<option value=1983>1983年</option>
<option value=1984>1984年</option>
<option value=1985>1985年</option>
<option value=1986>1986年</option>
<option value=1987>1987年</option>
<option value=1988>1988年</option>
<option value=1989>1989年</option>
<option value=1990>1990年</option>
<option value=1991>1991年</option>
<option value=1992>1992年</option>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -