📄 bjmfx.asp
字号:
<%@ language=vbscript %>
<!--#include file="conn.asp"-->
<%
zfwj=request("zfwj")
xq=request("xq")
mf=request("mf")
s= request("s")
mzxs=request("mzxs1")
mc=request("mzxs")
sql="SELECT * from cxb where s='" + s + "' Order by "&mzxs&" desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,3
sqlmax="SELECT max("&mzxs&") from cxb where s like '%"&s&"%'"
set rsmax=server.createobject("adodb.recordset")
rsmax.Open Sqlmax,conn,1,1
sqlmin="SELECT min("&mzxs&") from cxb where s like '%"&s&"%'"
set rsmin=server.createobject("adodb.recordset")
rsmin.Open Sqlmin,conn,1,1
sqlavg="SELECT avg("&mzxs&") As pjf from cxb where s like '%"&s&"%'"
set rsavg=server.createobject("adodb.recordset")
rsavg.Open Sqlavg,conn,1,1
sqljg="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">="&mf&"*.6"
set rsjg=server.createobject("adodb.recordset")
rsjg.Open Sqljg,conn,1,1
sqljg140="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=140"
set rsjg140=server.createobject("adodb.recordset")
rsjg140.Open Sqljg140,conn,1,1
sqljg130="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=130 and "&mzxs&"<140"
set rsjg130=server.createobject("adodb.recordset")
rsjg130.Open Sqljg130,conn,1,1
sqljg120="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=120 and "&mzxs&"<130"
set rsjg120=server.createobject("adodb.recordset")
rsjg120.Open Sqljg120,conn,1,1
sqljg110="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=110 and "&mzxs&"<120"
set rsjg110=server.createobject("adodb.recordset")
rsjg110.Open Sqljg110,conn,1,1
sqljg100="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=100 and "&mzxs&"<110"
set rsjg100=server.createobject("adodb.recordset")
rsjg100.Open Sqljg100,conn,1,1
sqljg90="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=90 and "&mzxs&"<100"
set rsjg90=server.createobject("adodb.recordset")
rsjg90.Open Sqljg90,conn,1,1
sqljg80="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=80 and "&mzxs&"<90"
set rsjg80=server.createobject("adodb.recordset")
rsjg80.Open Sqljg80,conn,1,1
sqljg70="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=70 and "&mzxs&"<80"
set rsjg70=server.createobject("adodb.recordset")
rsjg70.Open Sqljg70,conn,1,1
sqljg60="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=60 and "&mzxs&"<70"
set rsjg60=server.createobject("adodb.recordset")
rsjg60.Open Sqljg60,conn,1,1
sqljg50="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=50 and "&mzxs&"<60"
set rsjg50=server.createobject("adodb.recordset")
rsjg50.Open Sqljg50,conn,1,1
sqljg40="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=40 and "&mzxs&"<50"
set rsjg40=server.createobject("adodb.recordset")
rsjg40.Open Sqljg40,conn,1,1
sqljg30="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=30 and "&mzxs&"<40"
set rsjg30=server.createobject("adodb.recordset")
rsjg30.Open Sqljg30,conn,1,1
sqljg20="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=20 and "&mzxs&"<30"
set rsjg20=server.createobject("adodb.recordset")
rsjg20.Open Sqljg20,conn,1,1
sqljg10="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&">=10 and "&mzxs&"<20"
set rsjg10=server.createobject("adodb.recordset")
rsjg10.Open Sqljg10,conn,1,1
sqljg0="SELECT count("&mzxs&") As pjf from cxb where s like '%"&s&"%' and "&mzxs&"<10"
set rsjg0=server.createobject("adodb.recordset")
rsjg0.Open Sqljg0,conn,1,1
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
%>
<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">
<%=s%></font></font></b></div>
<div align="center"><b>第<font color=red><%=xq%></font>学期单科成绩分析</b></div>
<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=black style='color:white'>
<td align=center>名次</td>
<td align=center>班级</td>
<td align=center>学号</td>
<td align=center>姓名</td>
<td align=center>性别</td>
<td align=center><%=mc%> </td>
<%
do while not rs.eof
i=i+1
xh=rs("xh")
xm=rs("xm")
xb=rs("xb")
zybj=rs("zybj")
%>
<%
If sColor = "silver" Then
sColor = "#cccccc"
Else
sColor = "silver"
End If
Response.Write("</tr>")
Response.Write("<tr bgcolor='" & sColor & "'>")
%>
<td align=center><font color="red"><%=i%></font> </td>
<td align=center><%=zybj%> </td>
<td align=center><%=xh%> </td>
<td align=center><%=xm%> </td>
<td align=center><%=xb%> </td>
<td align=center>
<%
if mzxs="fs10" then
if rs("fs10")>=mf*.6 then
%>
<font color=green><%=rs("fs10")%></font>
<%
else
%>
<font color=red><%=rs("fs10")%></font>
<%
end if
end if
%>
<%
if mzxs="fs11" then
if rs("fs11")>=mf*.6 then
%>
<font color=green><%=rs("fs11")%></font>
<%
else
%>
<font color=red><%=rs("fs11")%></font>
<%
end if
end if
%>
<%
if mzxs="fs12" then
if rs("fs12")>=mf*.6 then
%>
<font color=green><%=rs("fs12")%></font>
<%
else
%>
<font color=red><%=rs("fs12")%></font>
<%
end if
end if
%>
<%
if mzxs="fs13" then
if rs("fs13")>=mf*.6 then
%>
<font color=green><%=rs("fs13")%></font>
<%
else
%>
<font color=red><%=rs("fs13")%></font>
<%
end if
end if
%>
<%
if mzxs="fs14" then
if rs("fs14")>=mf*.6 then
%>
<font color=green><%=rs("fs14")%></font>
<%
else
%>
<font color=red><%=rs("fs14")%></font>
<%
end if
end if
%>
<%
if mzxs="fs15" then
if rs("fs15")>=mf*.6 then
%>
<font color=green><%=rs("fs15")%></font>
<%
else
%>
<font color=red><%=rs("fs15")%></font>
<%
end if
end if
%>
<%
if mzxs="fs16" then
if rs("fs16")>=mf*.6 then
%>
<font color=green><%=rs("fs16")%></font>
<%
else
%>
<font color=red><%=rs("fs16")%></font>
<%
end if
end if
%>
<%
if mzxs="fs17" then
if rs("fs17")>=mf*.6 then
%>
<font color=green><%=rs("fs17")%></font>
<%
else
%>
<font color=red><%=rs("fs17")%></font>
<%
end if
end if
%>
<%
if mzxs="fs18" then
if rs("fs18")>=mf*.6 then
%>
<font color=green><%=rs("fs18")%></font>
<%
else
%>
<font color=red><%=rs("fs18")%></font>
<%
end if
end if
%>
<%
if mzxs="fs19" then
if rs("fs19")>=mf*.6 then
%>
<font color=green><%=rs("fs19")%></font>
<%
else
%>
<font color=red><%=rs("fs19")%></font>
<%
end if
end if
%>
<%
if mzxs="fs110" then
if rs("fs110")>=mf*.6 then
%>
<font color=green><%=rs("fs110")%></font>
<%
else
%>
<font color=red><%=rs("fs110")%></font>
<%
end if
end if
%>
<%
if mzxs="fs111" then
if rs("fs111")>=mf*.6 then
%>
<font color=green><%=rs("fs111")%></font>
<%
else
%>
<font color=red><%=rs("fs111")%></font>
<%
end if
end if
%>
<%
if mzxs="fs112" then
if rs("fs112")>=mf*.6 then
%>
<font color=green><%=rs("fs112")%></font>
<%
else
%>
<font color=red><%=rs("fs112")%></font>
<%
end if
end if
%>
<%
if mzxs="fs113" then
if rs("fs113")>=mf*.6 then
%>
<font color=green><%=rs("fs113")%></font>
<%
else
%>
<font color=red><%=rs("fs113")%></font>
<%
end if
end if
%>
<%
if mzxs="fs114" then
if rs("fs114")>=mf*.6 then
%>
<font color=green><%=rs("fs114")%></font>
<%
else
%>
<font color=red><%=rs("fs114")%></font>
<%
end if
end if
%>
<%
if mzxs="fs115" then
if rs("fs115")>=mf*.6 then
%>
<font color=green><%=rs("fs115")%></font>
<%
else
%>
<font color=red><%=rs("fs115")%></font>
<%
end if
end if
%>
<%
if mzxs="fs116" then
if rs("fs116")>=mf*.6 then
%>
<font color=green><%=rs("fs116")%></font>
<%
else
%>
<font color=red><%=rs("fs116")%></font>
<%
end if
end if
%>
<%
if mzxs="fs117" then
if rs("fs117")>=mf*.6 then
%>
<font color=green><%=rs("fs117")%></font>
<%
else
%>
<font color=red><%=rs("fs117")%></font>
<%
end if
end if
%>
<%
if mzxs="fs118" then
if rs("fs118")>=mf*.6 then
%>
<font color=green><%=rs("fs118")%></font>
<%
else
%>
<font color=red><%=rs("fs118")%></font>
<%
end if
end if
%>
<%
if mzxs="fs119" then
if rs("fs119")>=mf*.6 then
%>
<font color=green><%=rs("fs119")%></font>
<%
else
%>
<font color=red><%=rs("fs119")%></font>
<%
end if
end if
%>
<%
if mzxs="fs20" then
if rs("fs20")>=mf*.6 then
%>
<font color=green><%=rs("fs20")%></font>
<%
else
%>
<font color=red><%=rs("fs20")%></font>
<%
end if
end if
%>
<%
if mzxs="fs21" then
if rs("fs21")>=mf*.6 then
%>
<font color=green><%=rs("fs21")%></font>
<%
else
%>
<font color=red><%=rs("fs21")%></font>
<%
end if
end if
%>
<%
if mzxs="fs22" then
if rs("fs22")>=mf*.6 then
%>
<font color=green><%=rs("fs22")%></font>
<%
else
%>
<font color=red><%=rs("fs22")%></font>
<%
end if
end if
%>
<%
if mzxs="fs23" then
if rs("fs23")>=mf*.6 then
%>
<font color=green><%=rs("fs23")%></font>
<%
else
%>
<font color=red><%=rs("fs23")%></font>
<%
end if
end if
%>
<%
if mzxs="fs24" then
if rs("fs24")>=mf*.6 then
%>
<font color=green><%=rs("fs24")%></font>
<%
else
%>
<font color=red><%=rs("fs24")%></font>
<%
end if
end if
%>
<%
if mzxs="fs25" then
if rs("fs25")>=mf*.6 then
%>
<font color=green><%=rs("fs25")%></font>
<%
else
%>
<font color=red><%=rs("fs25")%></font>
<%
end if
end if
%>
<%
if mzxs="fs26" then
if rs("fs26")>=mf*.6 then
%>
<font color=green><%=rs("fs26")%></font>
<%
else
%>
<font color=red><%=rs("fs26")%></font>
<%
end if
end if
%>
<%
if mzxs="fs27" then
if rs("fs27")>=mf*.6 then
%>
<font color=green><%=rs("fs27")%></font>
<%
else
%>
<font color=red><%=rs("fs27")%></font>
<%
end if
end if
%>
<%
if mzxs="fs28" then
if rs("fs28")>=mf*.6 then
%>
<font color=green><%=rs("fs28")%></font>
<%
else
%>
<font color=red><%=rs("fs28")%></font>
<%
end if
end if
%>
<%
if mzxs="fs29" then
if rs("fs29")>=mf*.6 then
%>
<font color=green><%=rs("fs29")%></font>
<%
else
%>
<font color=red><%=rs("fs29")%></font>
<%
end if
end if
%>
<%
if mzxs="fs120" then
if rs("fs120")>=mf*.6 then
%>
<font color=green><%=rs("fs120")%></font>
<%
else
%>
<font color=red><%=rs("fs120")%></font>
<%
end if
end if
%>
<%
if mzxs="fs121" then
if rs("fs121")>=mf*.6 then
%>
<font color=green><%=rs("fs121")%></font>
<%
else
%>
<font color=red><%=rs("fs121")%></font>
<%
end if
end if
%>
<%
if mzxs="fs122" then
if rs("fs122")>=mf*.6 then
%>
<font color=green><%=rs("fs122")%></font>
<%
else
%>
<font color=red><%=rs("fs122")%></font>
<%
end if
end if
%>
<%
if mzxs="fs123" then
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -