📄 coursewaredown.jsp
字号:
<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.sql.* " %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<jsp:useBean id="cw" scope="page" class="edu.CoursewareBean"/>
<jsp:useBean id="grades" scope="page" class="edu.GradeBean" />
<jsp:useBean id="classs" scope="page" class="edu.ClassBean" />
<jsp:useBean id="subjects" scope="page" class="edu.SubjectBean" />
<jsp:useBean id="ask" scope="page" class="edu.AskBean" />
<link href="images/style.css" rel="stylesheet" type="text/css" />
<title>课件资料下载</title>
</head>
<body>
<div align="center">
<%
int id=0;
ResultSet rs=null;
try{
id=Integer.parseInt(request.getParameter("id"));
}catch(NumberFormatException e){}
cw=cw.getcourseware(id);
%>
<%if(cw!=null) {%>
<table width="200" border="0" cellpadding="0" cellspacing="1" bgcolor="#EBEBEB">
<tbody>
<tr bgcolor="#FFFFFF">
<td height="20">课件名称：</td>
<td height="20"><%=cw.getTitle() %></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20">适合于：</td>
<%
rs=grades.getGrades(cw.getGrade_id());
String grade=null;
String clas=null;
String subject=null;
try{
if(rs.next()){
grade=rs.getString("grade");
}
rs=classs.getClasss(cw.getClass_id());
if(rs.next()){
clas=rs.getString("class");
}
rs=subjects.getSubjects(cw.getSubject_id());
if(rs.next()){
subject=rs.getString("subject");
}
rs.close();
%>
<td height="20"><%=grade+" "+clas+" "+subject %></td>
<%}catch(NullPointerException e){ %>
<td>暂无</td>
<%} %>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20"> 大小：</td>
<td height="20"><%=(float)(cw.getFilesize()/1024) %> KB</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20"> 格式：</td>
<td height="20"><%=cw.getFileext() %></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20"> 上传时间：</td>
<td height="20"><%=cw.getUploadtime() %></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20"> 上传人：</td>
<%
rs=ask.getAskSortName(cw.getSort(),cw.getU_id());
try{
if(rs.next()){
%>
<td height="20"><%=rs.getString(1) %></td>
<%}}catch(NullPointerException e) { %>
<td>匿名</td>
<%} %>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20">下载连接：</td>
<td height="20"><a href="<%=cw.getFilename() %>">下载</a></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20"> 简介：</td>
<td height="20"><%=cw.getContent() %></td>
</tr>
</tbody>
</table>
<%}else out.println("资源不存在！");%>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -