📄 teacherinfo.jsp
字号:
<%@ include file="conn.jsp"%>
<%@ include file="fenlei.jsp"%>
<%String id=request.getParameter("id");
if(id==null){
out.print("<script>alert('请不要捣乱');top.window.location.href='index.jsp';</script>");
}
sql="select * from scott.teacher where teacherid='"+id+"'";
rs=stmt.executeQuery(sql);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE>TD {
FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
BODY {
FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
A:link {
COLOR: #0033cc; TEXT-DECORATION: none
}
A:visited {
COLOR: #0033cc; TEXT-DECORATION: none
}
A:active {
COLOR: #ff0000; TEXT-DECORATION: none
}
A:hover {
COLOR: #000000; TEXT-DECORATION: underline
}
.header {
font-family: Tahoma, Verdana; font-size: 9pt; color: #FFFFFF; background-color: #69C37C
}
.category{
font-family: Tahoma, Verdana; font-size: 9pt; color: #000000; background-color: #EFEFEF
}
</STYLE>
<title>个人专集</title>
<script language="javascript">
function showdetail(id)
{
window.open("detail.jsp?id="+id,"detail","width=400,height=400,resizable=no,scrollbars=yes,menubar=no,status=no");
}
</script>
</head>
<body text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0>
<%
if((session.getValue("teacherid")==null)&&(session.getValue("admin")==null)){
%>
<%@ include file="head.jsp"%>
<%
}
if(!rs.next()){
out.print("<center>没有找到您要查看的教师</center>");
}else{
%>
<br>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=1 width="740" border=1>
<tr><td align="center" class="header" colspan=3>个人资料</td></tr>
<tr><td width=80 align="right"><b>所属<%=strfenlei1%>：</b></td><td width=420> <%=rs.getString("fenlei1")%></td>
<td align="center" valign="middle" rowspan=7 width=240>暂无照片
</td>
</tr>
<tr><td width=80 align="right"><b>所属<%=strfenlei2%>：</b></td><td width=420> <%=rs.getString("fenlei2")%></td></tr>
<tr><td width=80 align="right"><b>教师姓名：</b></td><td width=420> <%=rs.getString("teacher")%></td></tr>
<tr><td width=80 align="right"><b>E-Mail：</b></td><td width=420> <a href=mailto:<%=rs.getString("email")%>><%=rs.getString("email")%></a></td></tr>
<tr><td width=80 align="right"><b>个人主页：</b></td><td width=420> <a href=<%=rs.getString("homepage")%> target=_blank><%=rs.getString("homepage")%></a></td></tr>
<tr><td width=80 align="right"><b>QQ号码：</b></td><td width=420> <%=rs.getString("qq")%></td></tr>
<tr><td width=80 align="right"><b>通讯地址：</b></td><td width=420> <%=rs.getString("address")%></td></tr>
<tr><td width=80 align="right" valign="top"><b>个人简介：</b></td><td valign="top" colspan=2> <%=rs.getString("intro")%> </td></tr>
<%String intRowCount,sqlname;
String sql1="select * from scott.type";
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs1=stmt1.executeQuery(sql1);
while(rs1.next()){
sqlname="select count(mainid) from scott.main where idofteacher='"+id+"' and idoftype='"+rs1.getString("typeid")+"'";
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rt=stmt2.executeQuery(sqlname);
rt.next();
intRowCount=rt.getString(1);
rt.close();
%>
<tr><td align="center" class="header" colspan=3>已在本站发布的<%=rs1.getString("type")%>（共<%=intRowCount%>件）</td></tr>
<tr>
<td align="center" colspan=3>
<%sqlname="select * from scott.main where idofteacher='"+id+"' and idoftype='"+rs1.getString("typeid")+"'";
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rt1=stmt3.executeQuery(sqlname);
while(rt1.next()){
%>
<a href=# title=<%=rt1.getString("title")%> onclick=javascript:showdetail("<%=rt1.getString("mainid")%>");><%=rt1.getString("title")%></a>
<%
}%>
</td> </tr>
<%}%>
</table>
<%
if((session.getValue("teacherid")==null)&&(session.getValue("admin")==null)){
%>
<%@ include file="foot.jsp"%>
<%
}%>
<%
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -