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 + -
显示快捷键?