nnzk.asp

来自「学生成绩管理是学校管理的重要组成部分。成绩不仅关系到学生成绩升迁」· ASP 代码 · 共 36 行

<%
key1 = "男"


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

if topic="0"then
sql="SELECT * from cxb where (xh like '%"&key&"%' or xm like '%"&key&"%' or s like '%"&key&"%'or zybj like '%"&key&"%') and xb like '%"&key1&"%'" 
end if
if topic="1" then
sql="SELECT * from cxb where xh like '%"&key&"%' and xb like '%"&key1&"%'" 
end if
if topic="2" then
sql="SELECT * from cxb where xm like '%"&key&"%' and xb like '%"&key1&"%'" 
end if
if topic="3" then
sql="SELECT * from cxb where s like '%"&key&"%' and xb like '%"&key1&"%'" 
end if
if topic="4" then
sql="SELECT * from cxb where zybj like '%"&key&"%' and xb like '%"&key1&"%'"
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>