jsnnz.asp

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

<%
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 jsxxb where (dm like '%"&key&"%' or xm like '%"&key&"%' or bm like '%"&key&"%') and xb like '%"&key1&"%'" 
end if
if topic="1" then
sql="SELECT * from jsxxb where dm like '%"&key&"%' and xb like '%"&key1&"%'" 
end if
if topic="2" then
sql="SELECT * from jsxxb where xm like '%"&key&"%' and xb like '%"&key1&"%'" 
end if
if topic="3" then
sql="SELECT * from jsxxb where bm 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>