📄 total.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="xuanke.asp" -->
<!--#include file="include/is_admin.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>预约统计</title>
<style type="text/css">
<!--
@import url("style.css");
body {
background-image: url(image/back.jpg);
}
-->
</style>
</head>
<%
'打开预约数据库--------------
set rs_preengage=server.CreateObject("adodb.recordset")
'取得预约总数-----------------
sql = "select count(*) as total from preengage "
rs_preengage.open sql,xuanke_conn,3,2
preengage_total=rs_preengage("total")
rs_preengage.close
'打开用户资料数据库---------------
Set rs_student = Server.CreateObject("ADODB.Recordset")
'用户性别统计
sql = "select count(*) as male from student where sex = '男'"
rs_student.Open sql,xuanke_conn,3,2
rs_student_male = rs_student("male")
rs_student.close
sql = "select count(*) as female from student where sex = '女'"
rs_student.Open sql,xuanke_conn,3,2
rs_student_female = rs_student("female")
rs_student.close
rs_student_total = rs_student_male + rs_student_female
%>
<body>
<div align="center">
<table width="706" height="281" border="0" class="table_big">
<tr>
<td valign="top"><div align="center">
<!--#include file="include/admin_head.asp" -->
<br>
<!-- 预约统计表格 -->
<table width="380" border="0" class="table_small">
<tr>
<td colspan="4" background="image/type_bg.gif"> </td>
</tr>
<tr>
<td colspan="4" class="text_title"><div align="left">预选数统计</div></td>
</tr>
<tr>
<td colspan="4" class="table_title"> </td>
</tr>
<tr class="text">
<td width="81"><div align="left">已选课题人次：</div></td>
<td width="160"><div align="left"><%= preengage_total %></div></td>
<tr>
<td colspan="4" class="table_title"> </td>
</tr>
<%
set rs_course_show=server.CreateObject("adodb.recordset")
'取得预约总数-----------------
sql = "select course.*,class.* from course,class where cno=courseno "
rs_course_show.open sql,xuanke_conn,3,2
rs_course_show.movefirst
'循环显示课程信息-----------------
while (not rs_course_show.eof or rs_course_show.bof)
%>
<tr>
<%
dim rs_pre
dim rs_pre_total
Set rs_pre = Server.CreateObject("ADODB.Recordset")
sql = "SELECT preengage.*,class.* FROM preengage,class where p_csno=id and p_cno ='" & rs_course_show("cno")&"'"
rs_pre.Open sql,xuanke_conn,3,2
If (rs_pre.RecordCount = -1) Then
rs_pre_total=0
rs_pre.movefirst
While (Not rs_pre.EOF)
rs_pre_total = rs_pre_total + 1
rs_pre.MoveNext
Wend
else
rs_pre_total = rs_pre.RecordCount
End If
%>
<td class="text"><div align="left"><%= rs_course_show("cname") %></div></td>
<td class="text"><div align="left"><%= rs_course_show("classdesc") %></div></td>
<td width="121" class="text"><div align="left"><%= rs_pre_total %> 人</div></td>
<%
rs_course_show.movenext
wend
%>
</tr>
<tr class="text">
<td colspan="4"> </td>
</tr>
<tr class="text">
<td colspan="4"><div align="left"></div><div align="left"></div></td>
</tr>
</table>
<br>
<!-- 用户统计表格 -->
<table width="380" border="0" class="table_small">
<tr>
<td colspan="4" background="image/type_bg.gif"> </td>
</tr>
<tr>
<td colspan="4" class="text_title"><div align="left">已注册统计</div></td>
</tr>
<tr>
<td colspan="4" class="table_title"> </td>
</tr>
<tr class="text">
<td><div align="left">用户总数：</div></td>
<td colspan="3"><div align="left"><%= rs_student_total %></div></td>
</tr>
<tr class="text">
<td width="75"><div align="left">男性比例：</div></td>
<td width="108"><div align="left"><%= (FormatNumber(rs_student_male/rs_student_total,4))*100 & "%" %></div></td>
<td width="74"><div align="left">女性比例：</div></td>
<td width="101"><div align="left"><%= (FormatNumber(rs_student_female/rs_student_total,4))*100 & "%" %></div></td>
</tr>
<tr class="text">
<td colspan="4"> </td>
</tr>
</table>
<!--#include file="include/foot.asp" -->
</div></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -