📄 viewteacher.asp
字号:
<html>
<head>
<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>New Page 2</title>
<TITLE><%=title%></TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<link rel="stylesheet" type="text/css" href="css/index1.css">
<link rel="stylesheet" type="text/css" href="css/toolbar2.css">
<META content="Microsoft FrontPage 4.0" name=GENERATOR>
<base target="_blank">
<meta name="Microsoft Theme" content="sumipntg 011, default">
</head>
<body leftMargin="0" topMargin="0" background="_themes/sumipntg/sumtextb.jpg" bgcolor="#FFFFFF" text="#000066" link="#3333CC" vlink="#666699" alink="#990099"><!--mstheme--><font face="宋体">
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("CSTUDY.mdb")
set rootrs= server.createobject("adodb.recordset")
id=request("userid")
mySQL = "SELECT * FROM teacher where ID="& id &""
set rootrs=conn.execute(mySQL)
title=rootrs("name")
%>
<!--mstheme--></font><TABLE align=center border=0 cellPadding=0 cellSpacing=0 class=c width=760 height="164">
<tr>
<td height="28" width="25%" valign="top" align="center"><!--mstheme--><font face="宋体">
<p align="left">
现在位置：<font face="华文行楷" size="4"><a href="index.asp">首页</a>— <%=title%>老师</font></p>
<!--mstheme--></font></td>
<td height="28" width="70%" valign="middle" align="center"><!--mstheme--><font face="宋体">
<%=title%><b><font size="4" face="华文行楷">老师资料</font></b>
<!--mstheme--></font></td>
</tr>
<tr>
<td height="78" width="25%" valign="top" align="center"><!--mstheme--><font face="宋体"><!--mstheme--></font><TABLE border=1 bgcolor="#e6e5b8" cellPadding=5 cellSpacing=0 width="141" height="64" align="left" bordercolordark="#003366" bordercolorlight="#C0C0C0"> <TBODY>
<TR align=middle>
<TD height="89" align="center" bgcolor="#A8B8E0" width="211" background="image/A-bg.gif" valign="top"><!--mstheme--><font face="宋体">
<FORM action=check.asp method=post name=form_reg onsubmit="return checkdata()">
<p align="left"><span lang="zh-cn">用户</span>：
<input type="text" name="username" size="11" class="td1"><br><br>
<span lang="zh-cn">
密码：</span>
<input type="password" name="pwd" size="11" class="td1" ><br><br>
<span lang="zh-cn">
身份： </span><select name="identity" class="td1" style="padding-top: 5" size="1">
<option value="student" selected>我是学生</option>
<option value="teacher">我是教师</option>
</select>
<p>
<input type="Image" name="submit" border="0" src="image/AnN-DenLu.gif" width="52" height="18">
<a href="newuser.asp"><img src="image/AnN-ZhuCe.gif" width="52" height="18" border="0" ></a> </form>
<!--mstheme--></font></TD>
</TR>
</TBODY>
</TABLE><!--mstheme--><font face="宋体"><!--mstheme--></font></td>
<td height="289" width="70%" valign="bottom" align="center" rowspan="2"><!--mstheme--><font face="宋体"><!--mstheme--></font><table border=1 bgcolor="#e6e5b8"
cellPadding=5 cellSpacing=0 width="573" height="283" bordercolordark="#003366" bordercolorlight="#C0C0C0">
<tr>
<td height="20" width="229" valign="middle" align="left" background="image/A-bg.gif" ><!--mstheme--><font face="宋体">
<font color="#FF0000">姓名：</font><a href="mailto:<%=rootrs("email")%>"><%=rootrs("name")%> </a>
<!--mstheme--></font></td>
<td height="246" width="318" valign="middle" align="center" rowspan="4" background="image/A-bg.gif"><!--mstheme--><font face="宋体">
<%if rootrs("or")=0 then
response.write "暂无照片"
else%>
<img src="image/<%=rootrs("ID")%>" border=1 width="169" height="214">
<%end if%>
<!--mstheme--></font></td>
</tr>
<tr>
<td height="20" width="229" valign="middle" align="left" background="image/A-bg.gif" ><!--mstheme--><font face="宋体">
<font color="#FF0000">年龄：</font><%=rootrs("age")%>
<!--mstheme--></font></td>
</tr>
<tr>
<td height="20" width="229" valign="middle" align="left" background="image/A-bg.gif"><!--mstheme--><font face="宋体">
<font color="#FF0000">职称：</font><%=rootrs("position")%>
<!--mstheme--></font></td>
</tr>
<tr>
<td height="165" width="229" valign="top" align="left" background="image/A-bg.gif"><!--mstheme--><font face="宋体">
<br> <font color="#FF0000">简介： </font> <%=rootrs("introduction")%>
<!--mstheme--></font></td>
</tr>
<tr>
<td height="13" width="559" valign="middle" align="center" colspan="2" background="image/A-bg.gif"><!--mstheme--><font face="宋体">
<%SQL = "SELECT * FROM tutorial where teacher="& id &""
set rs=conn.execute(sql)%>
<font color="#FF0000">
负责章节：</font> <%Do While Not rs.Eof%>
<a href="viewtutorial.asp?id=<%=rs("ID")%>">
<% response.write rs("title")%>
</a> ；
<%rs.MoveNext
Loop
rs.close
set rs=nothing
rootrs.close
set rootrs=nothing
conn.Close
set conn=nothing
%>
</table><!--mstheme--><font face="宋体">
<p> <!--mstheme--></font></td>
</tr>
<tr>
<td height="126" width="25%" valign="middle" align="center"><!--mstheme--><font face="宋体">
<p align="left"><img border="0" src="image/logo.gif">
<!--mstheme--></font></td>
</tr>
</table><!--mstheme--><font face="宋体"><!--mstheme--></font></BODY>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -