📄 schoollist.asp
字号:
<%@ Language=VBScript %>
<!--#include file=globals.asp -->
<%
set rs = createobject("ADODB.recordset")
set rss = createobject("ADODB.recordset")
%>
<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"><img name="classlist_r1_c1" src="img/classlist_r1_c1.gif" width="133" height="45" border="0"></td>
<td><img name="classlist_r1_c4" src="img/classlist_r1_c4.gif" width="15" height="45" border="0"></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"> </td>
<td rowspan="7" valign="top"><img name="classlist_r2_c3" src="img/classlist_r2_c3.gif" width="5" height="594" border="0"></td>
<td colspan="8" bgcolor="#FFFFCC"><a href="/alumni/">中国 创网-校友录</a>>>><a href="schoollist.asp">学校列表</a>---<font color="red"><%=provincename%></font>注册学校列表
<%
sql="select count(*) as a from schoolinfo where schoolid like '"&provinceid&"%'"
rs.open SQL,schooldb,1,3
schoolcount=rs("a")
rs.close
%>
，共有<%=schoolcount%>所学校 </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"> </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">
<tr>
<%
sql="select * from province order by provinceid"
rs.open SQL,schooldb
i=0
while not rs.eof
if i mod 4 =0 then response.write "</tr><tr>"
sql1="select count(*) as schoolnum from schoolinfo where schoolid like '"&rs("provinceid")&"%'"
rss.open SQL1,schooldb,1,3
schoolnum=rss("schoolnum")
rss.close
%>
<td height="50" align="left" valign="top">
<table width="130" border="0" cellspacing="1" cellpadding="1">
<tr>
<td class="cn1" height="24" valign="top"><a href="local.asp?provinceid=<%=rs("provinceid")%>"><%=rs("provincename")%></a></td>
</tr>
<tr>
<td>共注册<%=schoolnum%>所学校</td>
</tr>
</table>
</td>
<%
i=i+1
rs.movenext
wend
rs.close
%>
</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>
</body>
</html>
<CENTER>
<p></p>
<!--#include file=end.htm-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -