tinfo.asp
来自「《动态网页设计基础教程》,胡杰,科学出版社」· ASP 代码 · 共 98 行
ASP
98 行
<!-- #include file="adoconn.asp" -->
<html>
<head>
<link rel="stylesheet" href="comCSS.css">
<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>
<base target="_self">
<meta name="Microsoft Border" content="t, default">
</head>
<body ><!--msnavigation--><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td>
<p align="left"> </p>
</td></tr><!--msnavigation--></table><!--msnavigation--><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><!--msnavigation--><td valign="top">
<%
Dim sql
Dim reccount
Dim fieldi,recordi
Dim t1,t2,t3,r1,r2
Dim ps,mypagesize,ys,mypage
Dim maxcount
Select case session("Kind")
case "教师"
sql="select * from Teachers where TDepartment='" & session("Department") & "'"
case "学生"
sql="select T.* from Teachers T,ClassofTeacher C where T.Tid=C.Tid AND C.ClassNo='" & session("ClassNo") & "'"
end select
Set rs=GetRecordset(sql)
IF not rs.eof then
Reccount=rs.RecordCount
END IF
%>
<form method="post">
<table border=0 cellspacing="0">
<tr>
<td><font face="华文行楷" size="4" color="#FF0000"><b><%=(t2)%>教师信息列表 </b></font> [ 记录总数:<%=Reccount%>]</td>
</table>
<div align="left">
<table border="1" width="809">
<tr bgcolor=#ccccc7>
<td width="39" align="center">
<p align="center"><font color="#000080"><b>姓名</b></font></p>
</td>
<td width="32" align="center">
<p align="right"><font color="#000080"><b>性别</b></font></p>
</td>
<td width="70" align="center">
<p align="center"><font color="#000080"><b>出生日期</b></font></p>
</td>
<td width="86" align="center">
<p align="center"><font color="#000080"><b>所在部门</b></font></p>
</td>
<td width="56" align="center"><font color="#000080"><b>职称</b></font></td>
<td width="63" align="center"><font color="#000080"><b>职务</b></font></td>
</tr>
<%for recordi=1 to Reccount
if rs.Eof then Exit for
if recordi mod 2=0 then
color="#ddddd7"
else
color="#eeeeef"
end if
response.write ("<tr bgcolor=" + color +">")
%>
<td width="39"><a href="Evaluating.asp?TeacherID=<%=rs(0)%>&Tname=<%=rs(1)%>&Tdepartment=<%=rs(6)%>"><% =rs(1) %></a></td>
<td width="32"><% =rs(2) %></td>
<td width="70"><% =rs(3) %></td>
<td width="86"><% =rs(6) %></td>
<td width="56"><% =rs(7) %></td>
<td width="63"><% =rs(8) %></td>
<%response.write ("</tr>")%>
<% rs.movenext%>
<%next%>
</table>
</div>
</form>
<%set Adoconn=nothing %>
<a href="javascript:history.back(2)">返回</a>
<!--msnavigation--></td></tr><!--msnavigation--></table></body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?