getcourse.jsp

来自「采用基于B/S结构进行开发学生管理信息系统,本系统采用Servlet+Jsp+J」· JSP 代码 · 共 71 行

JSP
71
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<html>
<head>
<link href="Inc/student_com.css" type="text/css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>所有课程</title>
</head>
<jsp:useBean id="course" scope="page" class="myBean.Course"/>
<body>
<div align="center">
  <p>
<%
String admin_id = (String)session.getAttribute("id"); 
if(admin_id==null){response.sendRedirect("login.jsp");}
String id="",name="",prepare="",dep="",semester="",depN="";
int period = 0;
float credit = 0;
dep = (String)session.getAttribute("dep");
if(dep==null){response.sendRedirect("login.jsp");}
%>
<font color="#00FF00" size="+3" face="方正舒体">所有课程</font> </p>

  <p align="left"><a href="addCourse.jsp">新增课程</a></p>
</div>
<div align="center">
  <table cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
    <tr> 
      <td align="center" bgcolor="#EEEEEE">课程号</td>
      <td align="center" bgcolor="#EEEEEE">课程名</td>
      <td align="center" bgcolor="#EEEEEE">学分</td>
      <td align="center" bgcolor="#EEEEEE">学时</td>
      <td align="center" bgcolor="#EEEEEE">预修课</td>
      <td align="center" bgcolor="#EEEEEE">开课学期</td>
      <td align="center" bgcolor="#EEEEEE">所在系</td>
      <td align="center" bgcolor="#EEEEEE">删除</td>
      <td align="center" bgcolor="#EEEEEE">更新</td>
      <td align="center" bgcolor="#EEEEEE">查看成绩</td>
      <td align="center" bgcolor="#EEEEEE">授课教师</td>
      <td align="center" bgcolor="#EEEEEE">选课学生</td>
    </tr>
<%
ResultSet rs=course.getCour(dep);
while(rs.next()) {
id=rs.getString("ID");
name=rs.getString("NAME");
credit=rs.getFloat("CREDIT");
period=rs.getInt("PERIOD");
prepare=rs.getString("PREPARE");
semester=rs.getString("SEMESTER");
dep=rs.getString("DEPARTMENT");
depN = rs.getString(8);
%>	
	<tr><td align="center" bgcolor="#FFFFFF"><%=id%></td><td align="center" bgcolor="#FFFFFF"><%=name%></td><td align="center" bgcolor="#FFFFFF"><%=credit%></td>
	<td align="center" bgcolor="#FFFFFF"><%=period%></td><td align="center" bgcolor="#FFFFFF"><%=prepare%></td><td align="center" bgcolor="#FFFFFF"><%=semester%></td>
	<td align="center" bgcolor="#FFFFFF"><%=depN%></td>
        <td align="center" bgcolor="#FFFFFF"><a href="CourseSvlt?action=delete&id=<%=id%>">删除</a></td>
	<td align="center" bgcolor="#FFFFFF"><a href="updateCour.jsp?id=<%=id%> ">更新</a></td>
	<td align="center" bgcolor="#FFFFFF"><a href="courseMark.jsp?cour_id=<%=id%>">成绩</a></td>
	<td align="center" bgcolor="#FFFFFF"><a href="courseTea.jsp?cour_id=<%=id%>">授课教师</a></td>
	<td align="center" bgcolor="#FFFFFF"><a href="courseStu.jsp?cour_id=<%=id%>">选课学生</a></td></tr>
<%
}
%>	
	
  </table> 
</div>
    <p align="center">&nbsp; </p>
<p align="center"><a href="admin.jsp" target="_parent">返回</a></p>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?