coursetea.jsp

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

JSP
53
字号
<%@ 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="teacher" scope="page" class="myBean.Teacher"/>
<body bgcolor="#0099FF" text="#FFFFFF" link="#00FF00">
<p>
<%
String admin_id = (String)session.getAttribute("id"); 
if(admin_id==null){response.sendRedirect("login.jsp");}
String id="",name="",title="",password="",entryyear="",depN="";
String cour_id = request.getParameter("cour_id");
%>
</p>
<p align="center"><font color="#00FF00" size="+3" face="华文行楷">所有教师</font></p>
  <table  border="0" align="center" 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>
    </tr>
    <%
ResultSet rs=teacher.getTeacher(cour_id);
while(rs.next()) {
id=rs.getString("ID");
name=rs.getString("NAME");
title=rs.getString("TITLE");
password=rs.getString("PASSWORD");
entryyear=rs.getString("ENTRYYEAR").substring(0,4);
depN=rs.getString(7);
%>
    <tr>
      <td align="center" bgcolor="#FFFFFF"><%=id%></td>
      <td align="center" bgcolor="#FFFFFF"><%=name%></td>
      <td align="center" bgcolor="#FFFFFF"><%=title%></td>
      <td align="center" bgcolor="#FFFFFF"><%=password%></td>
      <td align="center" bgcolor="#FFFFFF"><%=depN%></td>
      <td align="center" bgcolor="#FFFFFF"><%=entryyear%></td>
    </tr>
    <%
 }
 %>
</table>
<p align="center"><a href="getCourse.jsp">返回</a></p>
</body>
</html>

⌨️ 快捷键说明

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