bmxqfx.asp

原代码学生信息管理系统（原代码）不够的的话我给原程序 QQ3810091

sql="select * from cxb where s like '%"&s&"%' Order by fs55 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs55")
  mzxs1="fs55"

elseif jlh=7 then
sql="select * from cxb where s like '%"&s&"%' Order by fs56 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs56")
  mzxs1="fs56"

elseif jlh=8 then
sql="select * from cxb where s like '%"&s&"%' Order by fs57 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs57")
  mzxs1="fs57"

elseif jlh=9 then
sql="select * from cxb where s like '%"&s&"%' Order by fs58 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs58")
  mzxs1="fs58"

elseif jlh=10 then
sql="select * from cxb where s like '%"&s&"%' Order by fs59 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs59")
  mzxs1="fs59"

elseif jlh=11 then
sql="select * from cxb where s like '%"&s&"%' Order by fs150 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs150")
    mzxs1="fs150"

elseif jlh=12 then
sql="select * from cxb where s like '%"&s&"%' Order by fs151 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs151")
  mzxs1="fs151"

elseif jlh=13 then
sql="select * from cxb where s like '%"&s&"%' Order by fs152 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs152")
  mzxs1="fs152"

elseif jlh=14 then
sql="select * from cxb where s like '%"&s&"%' Order by fs153 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs153")
  mzxs1="fs153"

elseif jlh=15 then
sql="select * from cxb where s like '%"&s&"%' Order by fs154 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs154")
  mzxs1="fs154"

elseif jlh=16 then
sql="select * from cxb where s like '%"&s&"%' Order by fs155 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs155")
  mzxs1="fs155"

elseif jlh=17 then
sql="select * from cxb where s like '%"&s&"%' Order by fs156 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs156")
  mzxs1="fs156"

elseif jlh=18 then
sql="select * from cxb where s like '%"&s&"%' Order by fs157 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs157")
  mzxs1="fs157"

elseif jlh=19 then
sql="select * from cxb where s like '%"&s&"%' Order by fs158 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs158")
  mzxs1="fs158"

elseif jlh=20 then
sql="select * from cxb where s like '%"&s&"%' Order by fs159 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs159")
  mzxs1="fs159"


end if 



end if
if mc="6" then
 if jlh=0 then
 sql="select * from cxb where s like '%"&s&"%' Order by fs60+fs61+fs62+fs63+fs64+fs65+fs66+fs67+fs68+fs69+fs160+fs161+fs162+fs163+fs164+fs165+fs166+fs167+fs168+fs169 desc"
  rs.open sql,conn,3,3 
 
elseif jlh=1 then
sql="select * from cxb where s like '%"&s&"%' Order by fs60 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs60")
   mzxs1="fs60"

elseif jlh=2 then
sql="select * from cxb where s like '%"&s&"%' Order by fs61 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs61")
   mzxs1="fs61"

elseif jlh=3 then
sql="select * from cxb where s like '%"&s&"%' Order by fs62 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs62")
   mzxs1="fs62"

elseif jlh=4 then
sql="select * from cxb where s like '%"&s&"%' Order by fs63 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs63")
   mzxs1="fs63"

elseif jlh=5 then
sql="select * from cxb where s like '%"&s&"%' Order by fs64 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs64")
   mzxs1="fs64"

elseif jlh=6 then
sql="select * from cxb where s like '%"&s&"%' Order by fs65 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs65")
   mzxs1="fs65"

elseif jlh=7 then
sql="select * from cxb where s like '%"&s&"%' Order by fs66 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs66")
   mzxs1="fs66"

elseif jlh=8 then
sql="select * from cxb where s like '%"&s&"%' Order by fs67 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs67")
   mzxs1="fs67"

elseif jlh=9 then
sql="select * from cxb where s like '%"&s&"%' Order by fs68 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs68")
   mzxs1="fs68"

elseif jlh=10 then
sql="select * from cxb where s like '%"&s&"%' Order by fs69 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs69")
   mzxs1="fs69"

elseif jlh=11 then
sql="select * from cxb where s like '%"&s&"%' Order by fs160 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs160")
   mzxs1="fs160"

elseif jlh=12 then
sql="select * from cxb where s like '%"&s&"%' Order by fs161 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs161")
   mzxs1="fs161"

elseif jlh=13 then
sql="select * from cxb where s like '%"&s&"%' Order by fs162 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs162")
   mzxs1="fs162"

elseif jlh=14 then
sql="select * from cxb where s like '%"&s&"%' Order by fs163 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs163")
   mzxs1="fs163"

elseif jlh=15 then
sql="select * from cxb where s like '%"&s&"%' Order by fs164 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs164")
   mzxs1="fs164"

elseif jlh=16 then
sql="select * from cxb where s like '%"&s&"%' Order by fs165 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs165")
   mzxs1="fs165"

elseif jlh=17 then
sql="select * from cxb where s like '%"&s&"%' Order by fs166 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs166")
   mzxs1="fs166"

elseif jlh=18 then
sql="select * from cxb where s like '%"&s&"%' Order by fs167 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs167")
   mzxs1="fs167"

elseif jlh=19 then
sql="select * from cxb where s like '%"&s&"%' Order by fs168 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs168")
   mzxs1="fs168"

elseif jlh=20 then
sql="select * from cxb where s like '%"&s&"%' Order by fs169 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs169")
   mzxs1="fs169"



end if 


end if
if mc="7" then
 if jlh=0 then
 sql="select * from cxb where s like '%"&s&"%' Order by fs70+fs71+fs72+fs73+fs74+fs75+fs76+fs77+fs78+fs79+fs170+fs171+fs172+fs173+fs174+fs175+fs176+fs177+fs178+fs179 desc"
  rs.open sql,conn,3,3  

elseif jlh=1 then
sql="select * from cxb where s like '%"&s&"%' Order by fs70 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs70")
    mzxs1="fs70"

elseif jlh=2 then
sql="select * from cxb where s like '%"&s&"%' Order by fs71 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs71")
    mzxs1="fs71"

elseif jlh=3 then
sql="select * from cxb where s like '%"&s&"%' Order by fs72 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs72")
    mzxs1="fs72"

elseif jlh=4 then
sql="select * from cxb where s like '%"&s&"%' Order by fs73 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs73")
    mzxs1="fs73"

elseif jlh=5 then
sql="select * from cxb where s like '%"&s&"%' Order by fs74 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs74")
    mzxs1="fs74"

elseif jlh=6 then
sql="select * from cxb where s like '%"&s&"%' Order by fs75 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs75")
    mzxs1="fs75"

elseif jlh=7 then
sql="select * from cxb where s like '%"&s&"%' Order by fs76 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs76")
    mzxs1="fs76"

elseif jlh=8 then
sql="select * from cxb where s like '%"&s&"%' Order by fs77 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs77")
    mzxs1="fs77"

elseif jlh=9 then
sql="select * from cxb where s like '%"&s&"%' Order by fs78 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs78")
    mzxs1="fs78"

elseif jlh=10 then
sql="select * from cxb where s like '%"&s&"%' Order by fs79 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs79")
    mzxs1="fs79"

elseif jlh=11 then
sql="select * from cxb where s like '%"&s&"%' Order by fs170 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs170")
    mzxs1="fs170"

elseif jlh=12 then
sql="select * from cxb where s like '%"&s&"%' Order by fs171 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs171")
    mzxs1="fs171"

elseif jlh=13 then
sql="select * from cxb where s like '%"&s&"%' Order by fs172 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs172")
    mzxs1="fs172"

elseif jlh=14 then
sql="select * from cxb where s like '%"&s&"%' Order by fs173 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs173")
    mzxs1="fs173"

elseif jlh=15 then
sql="select * from cxb where s like '%"&s&"%' Order by fs174 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs174")
    mzxs1="fs174"

elseif jlh=16 then
sql="select * from cxb where s like '%"&s&"%' Order by fs175 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs175")
    mzxs1="fs175"

elseif jlh=17 then
sql="select * from cxb where s like '%"&s&"%' Order by fs176 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs176")
    mzxs1="fs176"

elseif jlh=18 then
sql="select * from cxb where s like '%"&s&"%' Order by fs177 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs177")
    mzxs1="fs177"

elseif jlh=19 then
sql="select * from cxb where s like '%"&s&"%' Order by fs178 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs178")
    mzxs1="fs178"

elseif jlh=20 then
sql="select * from cxb where s like '%"&s&"%' Order by fs179 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs179")
    mzxs1="fs179"



end if 


end if
if mc="8" then
 if jlh=0 then
 sql="select * from cxb where s like '%"&s&"%' Order by fs80+fs81+fs82+fs83+fs84+fs85+fs86+fs87+fs88+fs89+fs180+fs181+fs182+fs183+fs184+fs185+fs186+fs187+fs188+fs189 desc"
  rs.open sql,conn,3,3  

elseif jlh=1 then
sql="select * from cxb where s like '%"&s&"%' Order by fs80 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs80")
    mzxs1="fs80"

elseif jlh=2 then
sql="select * from cxb where s like '%"&s&"%' Order by fs81 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs81")
    mzxs1="fs81"

elseif jlh=3 then
sql="select * from cxb where s like '%"&s&"%' Order by fs82 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs82")
    mzxs1="fs82"

elseif jlh=4 then
sql="select * from cxb where s like '%"&s&"%' Order by fs83 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs83")
    mzxs1="fs83"

elseif jlh=5 then
sql="select * from cxb where s like '%"&s&"%' Order by fs84 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs84")
    mzxs1="fs84"

elseif jlh=6 then
sql="select * from cxb where s like '%"&s&"%' Order by fs85 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs85")
    mzxs1="fs85"

elseif jlh=7 then
sql="select * from cxb where s like '%"&s&"%' Order by fs86 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs86")
    mzxs1="fs86"

elseif jlh=8 then
sql="select * from cxb where s like '%"&s&"%' Order by fs87 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs87")
    mzxs1="fs87"

elseif jlh=9 then
sql="select * from cxb where s like '%"&s&"%' Order by fs88 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs88")
    mzxs1="fs88"

elseif jlh=10 then
sql="select * from cxb where s like '%"&s&"%' Order by fs89 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs89")
    mzxs1="fs89"

elseif jlh=11 then
sql="select * from cxb where s like '%"&s&"%' Order by fs180 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs180")
    mzxs1="fs180"

elseif jlh=12 then
sql="select * from cxb where s like '%"&s&"%' Order by fs181 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs181")
    mzxs1="fs181"

elseif jlh=13 then
sql="select * from cxb where s like '%"&s&"%' Order by fs182 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs182")
    mzxs1="fs182"

elseif jlh=14 then
sql="select * from cxb where s like '%"&s&"%' Order by fs183 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs183")
    mzxs1="fs183"

elseif jlh=15 then
sql="select * from cxb where s like '%"&s&"%' Order by fs184 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs184")
    mzxs1="fs184"

elseif jlh=16 then
sql="select * from cxb where s like '%"&s&"%' Order by fs185 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs185")
    mzxs1="fs185"

elseif jlh=17 then
sql="select * from cxb where s like '%"&s&"%' Order by fs186 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs186")
    mzxs1="fs186"

elseif jlh=18 then
sql="select * from cxb where s like '%"&s&"%' Order by fs187 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs187")
    mzxs1="fs187"

elseif jlh=19 then
sql="select * from cxb where s like '%"&s&"%' Order by fs188 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs188")
    mzxs1="fs188"

elseif jlh=20 then
sql="select * from cxb where s like '%"&s&"%' Order by fs189 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs189")
    mzxs1="fs189"


end if 


end if

 
 






if rs.eof then	
		response.write"<script language='javascript'>" 
		 response.write"alert('没有符合您要求的记录！');" 
		 response.write"history.go(-1);"
		 response.write"</script>" 
		 response.end
end if
	
total=rs.recordcount
if not isnumeric(request("page")) or isempty(request("page")) then
page=1
else
page=int(abs(request("page")))
end if
rs.pagesize=10
mypagesize=rs.pagesize
if total<>0 then
rs.absolutepage=page
end if

Dim js,zf
js=0
zf=0







%>
<html>
<head>
<title>总分成绩分析</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="config.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" background="bg01.gif">







<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>
          <div align="center"><b><font color=red><font face="华文行楷" size="6">
            <%=zybj%></font></font></b></div>      

          <div align="center"><b><font face="华文行楷" size="6" color=red>
<%=s%></font><br><font color=red>第<font color=black size="4">*<%=mc%>*</font>学期<br>
<%
if mzxs="" then
%>
<font color=green size="4">总分分析</font>
<%
else
%>
<font color=green size="4"><a href='mfbm.asp?s=<%=s%>&mzxs1=<%=mzxs1%>&mzxs=<%=mzxs%>&mc=<%=mc%>' target='_blank'><%=mzxs%>成绩分析</a></font>
<%
end if
%>
</font></b></div>      
<br>

        <div align="center"><b><font color="#0066FF">共有<font color=red><%=total%></font>位学生 
        </font></b></div>
    </td>
  </tr>
</table>

    <center>
	<table border=1 cellpadding=1 cellspacing=1>
	<tr bgcolor=silver style='color:black'>
    <td align=center>名次</td>
    <td align=center>班级</td>
    <td align=center>学号</td>
    <td align=center>姓名</td>
    <td align=center>性别</td> 
 <%
 if mc="1" then
 %>
    <td align=center><a  href='bmxqfx.asp?jlh=1&mc=1&s=<%=s%>'><%=rs1("fs10")%></a>　</td>
    <%
    
    if rs1("fs10")<>"" then
    js=js+1