📄 bjfx.asp
字号:
<%@ language=vbscript %>
<!--#include file="conn.asp"-->
<%
dm=request("dm")
zybj= request("zybj")
if Session.Contents("gws")=true or Session.Contents("zybj")=zybj or Session.Contents("dm")=true or Session.Contents("dm")=dm then
bjbh= request("bjbh")
bjbh="b"+cstr(bjbh)
mc=request("mc")
sj=request("sj")
mf=request("mf")
sql="SELECT * from "&bjbh&" Order by "&sj&" desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,3
sqlmax="SELECT max("&sj&") from "&bjbh&""
set rsmax=server.createobject("adodb.recordset")
rsmax.Open Sqlmax,conn,1,1
sqlmin="SELECT min("&sj&") from "&bjbh&" where "&sj&">0"
set rsmin=server.createobject("adodb.recordset")
rsmin.Open Sqlmin,conn,1,1
sqlavg="SELECT avg("&sj&") As pjf from "&bjbh&""
set rsavg=server.createobject("adodb.recordset")
rsavg.Open Sqlavg,conn,1,1
sqljg="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">="&mf&"*.6"
set rsjg=server.createobject("adodb.recordset")
rsjg.Open Sqljg,conn,1,1
sqljg140="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=140"
set rsjg140=server.createobject("adodb.recordset")
rsjg140.Open Sqljg140,conn,1,1
sqljg130="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=130 and "&sj&"<140"
set rsjg130=server.createobject("adodb.recordset")
rsjg130.Open Sqljg130,conn,1,1
sqljg120="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=120 and "&sj&"<130"
set rsjg120=server.createobject("adodb.recordset")
rsjg120.Open Sqljg120,conn,1,1
sqljg110="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=110 and "&sj&"<120"
set rsjg110=server.createobject("adodb.recordset")
rsjg110.Open Sqljg110,conn,1,1
sqljg100="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=100 and "&sj&"<110"
set rsjg100=server.createobject("adodb.recordset")
rsjg100.Open Sqljg100,conn,1,1
sqljg90="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=90 and "&sj&"<100"
set rsjg90=server.createobject("adodb.recordset")
rsjg90.Open Sqljg90,conn,1,1
sqljg80="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=80 and "&sj&"<90"
set rsjg80=server.createobject("adodb.recordset")
rsjg80.Open Sqljg80,conn,1,1
sqljg70="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=70 and "&sj&"<80"
set rsjg70=server.createobject("adodb.recordset")
rsjg70.Open Sqljg70,conn,1,1
sqljg60="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=60 and "&sj&"<70"
set rsjg60=server.createobject("adodb.recordset")
rsjg60.Open Sqljg60,conn,1,1
sqljg50="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=50 and "&sj&"<60"
set rsjg50=server.createobject("adodb.recordset")
rsjg50.Open Sqljg50,conn,1,1
sqljg40="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=40 and "&sj&"<50"
set rsjg40=server.createobject("adodb.recordset")
rsjg40.Open Sqljg40,conn,1,1
sqljg30="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=30 and "&sj&"<40"
set rsjg30=server.createobject("adodb.recordset")
rsjg30.Open Sqljg30,conn,1,1
sqljg20="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=20 and "&sj&"<30"
set rsjg20=server.createobject("adodb.recordset")
rsjg20.Open Sqljg20,conn,1,1
sqljg10="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">=10 and "&sj&"<20"
set rsjg10=server.createobject("adodb.recordset")
rsjg10.Open Sqljg10,conn,1,1
sqljg0="SELECT count("&sj&") As pjf from "&bjbh&" where "&sj&">0 and "&sj&"<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">
<%=zybj%></font></font></b></div>
<div align="center"><font color=red><%=mc%></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")
if sj="fs10" then
if rs("fs10")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs11" then
if rs("fs11")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs12" then
if rs("fs12")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs13" then
if rs("fs13")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs14" then
if rs("fs14")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs15" then
if rs("fs15")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs16" then
if rs("fs16")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs17" then
if rs("fs17")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs18" then
if rs("fs18")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs19" then
if rs("fs19")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs110" then
if rs("fs110")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs111" then
if rs("fs111")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs112" then
if rs("fs112")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs113" then
if rs("fs113")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs114" then
if rs("fs114")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs115" then
if rs("fs115")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs116" then
if rs("fs116")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs117" then
if rs("fs117")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs118" then
if rs("fs118")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs119" then
if rs("fs119")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs20" then
if rs("fs20")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs21" then
if rs("fs21")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs22" then
if rs("fs22")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs23" then
if rs("fs23")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs24" then
if rs("fs24")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs25" then
if rs("fs25")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs26" then
if rs("fs26")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs27" then
if rs("fs27")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs28" then
if rs("fs28")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs29" then
if rs("fs29")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs120" then
if rs("fs120")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs121" then
if rs("fs121")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs122" then
if rs("fs122")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs123" then
if rs("fs123")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs124" then
if rs("fs124")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs125" then
if rs("fs125")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs126" then
if rs("fs126")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs127" then
if rs("fs127")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs128" then
if rs("fs128")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs129" then
if rs("fs129")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs30" then
if rs("fs30")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs31" then
if rs("fs31")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs32" then
if rs("fs32")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs33" then
if rs("fs33")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs34" then
if rs("fs34")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs35" then
if rs("fs35")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs36" then
if rs("fs36")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs37" then
if rs("fs37")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs38" then
if rs("fs38")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs39" then
if rs("fs39")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs130" then
if rs("fs130")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs131" then
if rs("fs131")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs132" then
if rs("fs132")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs133" then
if rs("fs133")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs134" then
if rs("fs134")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs135" then
if rs("fs135")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs136" then
if rs("fs136")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs137" then
if rs("fs137")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs138" then
if rs("fs138")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs139" then
if rs("fs139")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs40" then
if rs("fs40")=0 then
ksjs=0
else
ksjs=1
end if
end if
if sj="fs41" then
if rs("fs41")=0 then
ksjs=0
else
ksjs=1
end if
end if
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -