nnzkb.asp

学生成绩管理是学校管理的重要组成部分。成绩不仅关系到学生成绩升迁

<%
key2 = "男"


key1 = request.form("key1")
topic=request.form("topic")
if key="" and topic="" then
key1 = request("key1")
topic=request("topic")
end if

if topic="0"then
sql="SELECT * from "&key&" where (xh like '%"&key1&"%' or xm like '%"&key1&"%' or s like '%"&key1&"%'or zybj like '%"&key1&"%') and xb like '%"&key2&"%'" 
end if
if topic="1" then
sql="SELECT * from "&key&" where xh like '%"&key1&"%' and xb like '%"&key2&"%'" 
end if
if topic="2" then
sql="SELECT * from "&key&" where xm like '%"&key1&"%' and xb like '%"&key2&"%'" 
end if
if topic="3" then
sql="SELECT * from "&key&" where s like '%"&key1&"%' and xb like '%"&key2&"%'" 
end if
if topic="4" then
sql="SELECT * from "&key&" where zybj like '%"&key1&"%' and xb like '%"&key2&"%'"
end if


set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
totaln=rs.recordcount
ns=total-totaln
%>
     <div align="center"><b><font color="#0066FF">其中男生<font color=red><%=totaln%></font>人<b><font color="#0066FF">女生<font color=red><%=ns%></font>人</div> 
</font></font> 
</b></b>