coursestu.jsp

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

JSP
80
字号
<%@ 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="stu" class="myBean.Student" scope="page"/>
<body>
<p>
<%
 String admin_id = (String)session.getAttribute("id"); 
 if(admin_id==null){response.sendRedirect("login.jsp");}
 String name="",id="",password="",jiguan="",sex="",assistant="",dep="",entry="",classid="",dep_id="";
 int age,flag;
 String cour_id = request.getParameter("cour_id");
 %>
</p>
<p align="center"><font color="#00FF00" size="+3" face="华文行楷">所有学生</font></p>
 <div align="center">
    <table  border="0" 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>
      </tr>
  <%
  ResultSet rs = stu.getCour_Stu(cour_id);
  while(rs.next())
  {
   id=rs.getString(1);
   name=rs.getString(3);
   password=rs.getString(2);
   age = rs.getInt(6);
   jiguan=rs.getString(7);
   dep=rs.getString(13);
   sex=rs.getString(4);
   classid=rs.getString(8);
   entry=rs.getString(5).substring(0,4);
   assistant=rs.getString(10);
   flag=rs.getInt("FLAG");
   %>
   <tr> 
        <td align="center" bgcolor="#FFFFFF"><%=id%></td>
        <td align="center" bgcolor="#FFFFFF"><%=name%></td>
        <td align="center" bgcolor="#FFFFFF"><%=password%></td>
        <td align="center" bgcolor="#FFFFFF"><%=age%></td>
        <td align="center" bgcolor="#FFFFFF"><%=jiguan%></td>
        <td align="center" bgcolor="#FFFFFF"><%=dep%></td>
        <td align="center" bgcolor="#FFFFFF"><%=sex%></td>
        <td align="center" bgcolor="#FFFFFF"><%=entry%></td>
        <td align="center" bgcolor="#FFFFFF"><%=classid%></td>
        <td align="center" bgcolor="#FFFFFF"><%=assistant%></td>
        <%if(flag==1){%>
        <td align="center" bgcolor="#FFFFFF">是</td>
        <%}else{%>
        <td align="center" bgcolor="#FFFFFF">否</td>
        <%}%>
        <td align="center"></td>
      </tr>
  <%
   }
 %>
</table>
</div>
<p align="center">&nbsp; </p>
<div align="center"><a href="getCourse.jsp">返回 </a> 
</div>
</body>
</html>

⌨️ 快捷键说明

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