UaoI5AzS.rar
<!--#include file = "conn.asp"-->
<%
provinces=request("provinces")
faculty=request("faculty")
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<link href="css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.STYLE1 {font-size: 14px}
.STYLE3 {color: #FFFFFF}
-->
</style>
</head>
<%
Set rc=Server.CreateObject("ADODB.Recordset")
sql="Select * from achievement_main"
rc.open sql,conn,1,1
%>
<body bgcolor="#333333" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!--#include file="top_.asp" -->
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="175" align="center" valign="top" bgcolor="#E7E7E7">
<!--#include file="left1.asp" --></td>
<td width="705" align="center" valign="top"><div align="center"><span class="STYLE1"></span><span class="STYLE1"></span><span class="STYLE1"></span><span class="STYLE1"><%=provinces%><%=faculty%></span>
<table width="501" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#666666" class="font" colspan="0">
<tr align="center" >
<td width="56" rowspan="2" bgcolor="#E48C19" class="p12"><div align="right" class="STYLE3">招生专业</div></td>
<td width="37" rowspan="2" bgcolor="#E48C19" class="p12"><div align="right" class="STYLE3">层次</div></td>
<td width="37" rowspan="2" bgcolor="#E48C19" class="p12"><div align="right" class="STYLE3">学制</div></td>
<td height="23" colspan="3" bgcolor="#E48C19" class="p12"><div align="right" class="STYLE3">
<div align="center">2004年</div>
</div></td>
<td colspan="3" bgcolor="#E48C19" class="p12"><div align="center" class="STYLE3">2005年</div></td>
<td colspan="3" bgcolor="#E48C19" class="p12"><div align="center" class="STYLE3">2006年</div></td>
</tr>
<tr align="center">
<td width="38" height="20" bgcolor="#E48C19" class="p12"><div align="center" class="STYLE3">
<div align="right">最高分</div>
</div></td>
<td width="38" bgcolor="#E48C19" class="p12"><div align="center" class="STYLE3">
<div align="right">最低分</div>
</div></td>
<td width="42" bgcolor="#E48C19" class="p12"><div align="center" class="STYLE3">
<div align="right">平均分</div>
</div></td>
<td width="39" bgcolor="#E48C19" class="p12"><div align="center" class="STYLE3">
<div align="right">最高分</div>
</div></td>
<td width="41" bgcolor="#E48C19" class="p12"><div align="center" class="STYLE3">
<div align="right">最低分</div>
</div></td>
<td width="42" bgcolor="#E48C19" class="p12"><div align="center" class="STYLE3">
<div align="right">平均分</div>
</div></td>
<td width="39" bgcolor="#E48C19" class="p12"><div align="center" class="STYLE3">
<div align="right">最高分</div>
</div></td>
<td width="37" bgcolor="#E48C19" class="p12"><div align="center" class="STYLE3">
<div align="right">最低分</div>
</div></td>
<td width="42" bgcolor="#E48C19" class="p12"><div align="center" class="STYLE3">
<div align="right">平均分</div>
</div></td>
</tr>
<%
do while not rc.eof
if rc("省份") = provinces and rc("科类") = faculty then
%>
<tr height="25" align="center">
<td bgcolor="#ECF7C8" class="STYLE1"><%=rc("招生专业")%></td>
<td bgcolor="#ECF7C8" class="STYLE1"><%=rc("层次")%></td>
<td bgcolor="#ECF7C8" class="STYLE1"><%=rc("学制")%></td>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="Select * from achievement_years"
rs.open sql,conn,1,1
do while not rs.eof
if rs("省份") = provinces and rs("科类") = faculty and rs("年份") = "2004" and rs("招生专业") = rc("招生专业") then
%>
<td bgcolor="#ECF7C8" class="STYLE1"><%=rs("最高分")%></td>
<td bgcolor="#ECF7C8" class="STYLE1"><%=rs("最低分")%></td>
<td bgcolor="#ECF7C8" class="STYLE1"><%=rs("平均分")%></td>
<% end if
if rs("省份") = provinces and rs("科类") = faculty and rs("年份") = "2005" and rs("招生专业") = rc("招生专业") then
%>
<td bgcolor="#ECF7C8" class="STYLE1"><%=rs("最高分")%></td>
<td bgcolor="#ECF7C8" class="STYLE1"><%=rs("最低分")%></td>
<td bgcolor="#ECF7C8" class="STYLE1"><%=rs("平均分")%></td>
<% end if
if rs("省份") = provinces and rs("科类") = faculty and rs("年份") = "2006" and rs("招生专业") = rc("招生专业")then
%>
<td bgcolor="#ECF7C8" class="STYLE1"><%=rs("最高分")%></td>
<td bgcolor="#ECF7C8" class="STYLE1"><%=rs("最低分")%></td>
<td bgcolor="#ECF7C8" class="STYLE1"><%=rs("平均分")%></td>
<% end if
rs.movenext
loop
%>
</tr>
<%
end if
rc.movenext
loop
%>
</table>
</div></td>
</tr>
</table>
</body>
</html>