📄 admincourseware.jsp
字号:
<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.sql.*,java.util.* " %>
<!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>
<script language=JavaScript>
function openWindow(url){
window.open(url,'', 'height=200, width=350, top=200, left=400, toolbar=no, menubar=no, scrollbars=no, resizable=no,location=no, status=no');
}
</script>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
.STYLE2 {color: #FFFFFF}
-->
</style>
</head>
<%
String name=null,sort="";
int u_id=0;
try{
u_id=Integer.parseInt(session.getAttribute("userid").toString());
name=session.getAttribute("name").toString();
sort=session.getAttribute("sort").toString();
}catch(NullPointerException e){}
if(name==null||name.equalsIgnoreCase("null")||(!sort.equalsIgnoreCase("admin")&&!sort.equalsIgnoreCase("teacher")))
response.sendRedirect("error_ad.jsp");
%>
<body>
<%
if(sort.equals("teacher"))
{
%>
<div align="center">
<table width="750" height="25" border="0" cellpadding="0"
cellspacing="0">
<tr>
<td width="770" height="160"><iframe name="top" height="160"
width="770" scrolling="no" src="top.jsp" frameborder="0"></iframe></td>
</tr>
</table>
</div>
<%} %>
<div align="center">
<a href="addcourseware.jsp"><span class="STYLE1">添加课件</span></a>
<table width="750" height="82" border="0" cellspacing="1">
<tbody>
<tr>
<td width="15%" bgcolor="#339999"><div align="center" class="STYLE2">课件名称</div></td>
<td width="6%" bgcolor="#339999"><div align="center" class="STYLE2">大小</div></td>
<td width="6%" bgcolor="#339999"><div align="center" class="STYLE2">格式</div></td>
<td width="18%" bgcolor="#339999"><div align="center" class="STYLE2">上传时间</div></td>
<td width="8%" bgcolor="#339999"><div align="center" class="STYLE2">适用学历</div></td>
<td width="8%" bgcolor="#339999"><div align="center" class="STYLE2">适用年级</div></td>
<td width="8%" bgcolor="#339999"><div align="center" class="STYLE2">适用科目</div></td>
<td width="8%" bgcolor="#339999"><div align="center" class="STYLE2">上传人</div></td>
<td width="8%" bgcolor="#339999"><div align="center" class="STYLE2">下载</div></td>
<td width="5%" bgcolor="#339999"><div align="center" class="STYLE2">修改</div></td>
<td width="5%" bgcolor="#339999"><div align="center" class="STYLE2">删除</div></td>
</tr>
<%
int thispage=1;
int allpage=0;
int rowofpage=20;
int startrow=0;
int endrow=0;
int allrow=0;
ResultSet rs=null;
List paraList =null;
if(sort.equals("admin")){
paraList = cw.getcwlist();
}else if(sort.equals("teacher")){
paraList = cw.getcwlist(u_id,sort);
}
allrow=paraList.size();
try{
thispage=Integer.parseInt(request.getParameter("page"));
}catch(NumberFormatException e){}
allpage=allrow/rowofpage+1;
if(thispage<1)
thispage=1;
if(thispage>allpage)
thispage=allpage;
startrow=rowofpage*(thispage-1);
if(startrow+rowofpage>allrow)
endrow=allrow;
else endrow=startrow+rowofpage;
for(int i=startrow;i<endrow;i++)
{
cw = (edu.CoursewareBean) paraList.get(i);
%>
<tr>
<td><a href="javascript:openWindow('coursewaredown.jsp?id=<%=cw.getId() %>')"><%=cw.getTitle() %></a></td>
<td><%=(float)(cw.getFilesize()/1024) %> KB</td>
<td><%=cw.getFileext() %></td>
<td><%=cw.getUploadtime() %></td>
<%
rs=grades.getGrades(cw.getGrade_id());
try{
if(rs.next()){
%>
<td><%=rs.getString("grade") %></td>
<%}}catch(NullPointerException e){ %>
<td>暂无</td>
<%} %>
<%
rs=classs.getClasss(cw.getClass_id());
try{
if(rs.next()){
%>
<td><%=rs.getString("class") %></td>
<%}}catch(NullPointerException e){ %>
<td>暂无</td>
<%} %>
<%
rs=subjects.getSubjects(cw.getSubject_id());
try{
if(rs.next()){
%>
<td><%=rs.getString("subject") %></td>
<%}}catch(NullPointerException e){ %>
<td>暂无</td>
<%} %>
<%
try{
rs=ask.getAskSortName(cw.getSort(),cw.getU_id());
if(rs.next()){
%>
<td><%=rs.getString(1) %></td>
<%}}catch(NullPointerException e) { %>
<td>匿名</td>
<%} %>
<td><a href="javascript:openWindow('coursewaredown.jsp?id=<%=cw.getId() %>')">下载页面</a></td>
<td><a href="javascript:openWindow('modifycourseware.jsp?id=<%=cw.getId() %>')">修改</a></td>
<td><a href="Servletcourseware?action=del&id=<%=cw.getId() %>">删除</a></td>
</tr>
<%} %>
</tbody>
</table>
<table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" height="30"><div align="center">共<span class="STYLE1"><%=allrow %></span>条记录 当前第<span class="STYLE1"><%=thispage %></span>页/共<span class="STYLE1"><%=allpage %></span>页</div></td>
<td width="70%"><div align="center"><a href="admincourseware.jsp">首页</a>
<a href="admincourseware.jsp?page=<%=thispage-1 %>">上一页</a>
<a href="admincourseware.jsp?page=<%=thispage+1 %>">下一页</a>
<a href="admincourseware.jsp?page=<%=allpage %>">末页</a></div></td>
</tr>
</table>
</div>
<%
if(sort.equals("teacher"))
{
%>
<div align="center">
<table height="155" width="750" border="0" cellspacing="1"
align="center">
<tr>
<td><iframe name="bottom" height="155" width="750" scrolling="no"
src="bottom.jsp" frameborder="0"></iframe></td>
</tr>
</table>
</div>
<%} %>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -