📄 detail.jsp
字号:
<%@ include file="conn.jsp"%>
<%@ include file="fenlei.jsp"%>
<%
String id=request.getParameter("id");
if(id==null){
out.print("<script>alert('没有找到您要查看的记录');window.close();</script>");
}
sql="select * from scott.main,scott.teacher,scott.type where main.idofteacher=teacher.teacherid and main.idoftype=type.typeid and main.mainid='"+id+"'";
rs=stmt.executeQuery(sql);
if(!rs.next()){
out.print("<script>alert('没有找到您要查看的记录');window.close();</script>");
}else{
%>
<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>
</head>
<body text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0>
<br>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=5 width="350" border=1>
<tr><td>
<table align=center width=100% border=0>
<tr><td align="center" class="header" colspan=2>详细资料</td></tr>
<tr><td width=80 align="right"><b>所属<%=strfenlei1%>：</b></td><td width=270><%=rs.getString("fenlei1")%></td></tr>
<tr><td align="right"><b>所属<%=strfenlei2%>：</b></td><td><%=rs.getString("fenlei2")%></td></tr>
<tr><td align="right"><b>教师姓名：</b></td><td><%=rs.getString("teacher")%></td></tr>
<tr><td align="right"><b>课程名称：</b></td><td><%=rs.getString("course")%></td></tr>
<tr><td align="right"><b>更新日期：</b></td><td><%=rs.getString("dateandtime")%></td></tr>
<tr><td align="right"><b>阅读次数：</b></td><td><%=rs.getString("times")%></td></tr>
<tr><td align="right"><b>资料大小：</b></td><td><%=rs.getString("filesize")%><b>K</b></td></tr>
<tr><td align="right"><b>资料类型：</b></td><td><%=rs.getString("type")%></td></tr>
<tr><td align="right"><b>资料标题：</b></td><td><%=rs.getString("title")%></td></tr>
<tr><td align="right" valign="top"><b>资料简介：</b></td><td rowspan=2 valign="top"><%=rs.getString("content")%> </td></tr>
<tr><td> </td></tr>
<tr><td colspan=2 bgColor=#cccccc height=1></td></tr>
<tr>
<td colspan=2 align=center> <br>
<img src=images/close.gif border=0><a href=# onclick=javascript:window.close();>关闭窗口</a>
<img src=images/download.gif border=0><a href=download.jsp?id=<%=id%> target=_blank>点这里阅读</a>
<img src=images/close.gif border=0><a href=redetail.jsp?id=<%=id%> target=_blank>提交作业</a></td>
</tr>
<tr><td colspan=2 bgColor=#cccccc height=1></td></tr>
</table>
</td></tr></table>
<br>
</body>
</html>
<%
}
stmt.executeUpdate("update scott.main set times=times+1 where mainid='"+id+"'");
rs.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -