📄 viewteacher1.asp
字号:
<!--#include file="conn.asp"-->
<%
dim b_teacher
b_teacher=trim(request("b_teacher"))
set rs=server.createobject("adodb.recordset")
sql="select * from teacher where b_teacher='"&b_teacher&"'"
rs.open sql,conn,1,1
number=rs.recordcount
sum=0
do while not rs.eof
sum=sum+rs("b_tatol")
rs.movenext
loop
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>专职教师评测结果</title>
<link rel=stylesheet href="style.css" type="text/css">
</head>
<body>
<div align="center">
<center>
<table border="0" width="400" cellpadding="3">
<tr>
<td width="388" colspan="2">您所查看的<%=b_teacher%>的评测结果如下：</td>
</tr>
</center>
<tr>
<td width="115">
<p align="right">参评人数：</p>
</td>
<center>
<td width="267"><%=number%></td>
</tr>
</center>
<tr>
<td width="115">
<p align="right">总 分：</td>
<center>
<td width="267"><%=sum%></td>
</tr>
</center>
<tr>
<td width="115">
<p align="right">平均分：</td>
<center>
<td width="267"><%=sum/number%></td>
</tr>
<tr>
<td width="115"></td>
<td width="267"></td>
</tr>
</table>
</center>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -