📄 score.jsp
字号:
<%@page contentType="text/html; charset=gb2312" language="java" errorPage="errorpage.jsp"%>
<html><!-- InstanceBegin template="/Templates/teacher.dwt.jsp" codeOutsideHTMLIsLocked="false" -->
<!-- DW6 -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!-- InstanceBeginEditable name="doctitle" -->
<title>公布成绩</title>
<!-- InstanceEndEditable --><link rel="stylesheet" href="2col_leftNav.css" type="text/css">
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.style2 {font-size: 14px}
-->
</style>
<!-- InstanceEndEditable -->
</head>
<!-- The structure of this file is exactly the same as 2col_rightNav.html;
the only difference between the two is the stylesheet they use -->
<body>
<%
String tea_id=null;
tea_id=(String)session.getAttribute("username");
if(tea_id==null){
response.sendRedirect("index.jsp");
}
%>
<div id="masthead">
<h1 id="siteName"> </h1>
<div id="globalNav">
<a href="#">global link</a> | <a href="#">global link</a> | <a href="#">global
link</a> | <a href="#">global link</a> | <a href="#">global link</a> | <a href="#">global
link</a> | <a href="#">global link</a>
</div>
</div>
<!-- end masthead -->
<div id="content">
<div class="feature"><!-- InstanceBeginEditable name="EditRegion1" -->
<h3>Feature Title </h3>
<p>
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec molestie.
Sed aliquam sem ut arcu. Phasellus sollicitudin. Vestibulum condimentum facilisis
nulla. In hac habitasse platea dictumst. Nulla nonummy. Cras quis libero.
Cras venenatis. Aliquam posuere lobortis pede. Nullam fringilla urna id leo.
Praesent aliquet pretium erat. Praesent non odio. Pellentesque a magna a
mauris vulputate lacinia. Aenean viverra. Class aptent taciti sociosqu ad
litora torquent per conubia nostra, per inceptos hymenaeos. Aliquam lacus.
Mauris magna eros, semper a, tempor et, rutrum et, tortor.
</p>
<table width="95%" border="1">
<tr>
<td><span class="style2">学生姓名</span></td>
<td><span class="style2">所在系</span></td>
<td><span class="style2">性别</span></td>
<td><span class="style2">学分</span></td>
<td><span class="style2">Email</span></td>
<td><span class="style2">Tel</span></td>
<td><span class="style2">成绩</span></td>
</tr>
<%
String class_id=request.getParameter("class_id");
String name=null;
String dep=null;
String sex=null;
int mark=0;
String e_mail=null;
String tel=null;
ResultSet rs=deter.getStudents2(class_id);
String stu_id=null;
while(rs.next()){
stu_id=rs.getString("username");
name=rs.getString("name");
dep=rs.getString("department");
sex=rs.getString("sex");
mark=rs.getInt("mark");
e_mail=rs.getString("e_mail");
tel=rs.getString("tel");
%>
<tr>
<td><span class="style2"><%=name%></span></td>
<td><span class="style2"><%=dep%></span></td>
<td><span class="style2"><%=sex%></span></td>
<td><span class="style2"><%=mark%></span></td>
<td><span class="style2"><%=e_mail%></span></td>
<td><span class="style2"><%=tel%></span></td>
<td><a href="input_score.jsp?stu_id=<%=stu_id%>&class_id=<%=class_id%> " class="style2">score</a></td>
</tr>
<%}%>
</table>
<p> </p>
<!-- InstanceEndEditable -->
</div>
</div>
<!--end content -->
<div id="navBar">
<div id="search">
<form action="#">
<label>search</label>
<input name="searchFor" type="text" size="10">
<input name="goButton" type="submit" value="go">
</form>
</div>
<div id="sectionLinks">
<ul>
<li><a href="display_student.jsp">我的学生</a></li>
<li><a href="public.jsp">公布成绩</a></li>
<li><a href="logoff.do">退出</a></li>
</ul>
</div>
<div id="headlines"></div>
</div>
<!--end navbar -->
<div id="siteInfo">
<div align="center"><a href="#">About Us</a> | <a href="#">Site
Map</a> | <a href="#">Privacy Policy</a> | <a href="#">Contact Us</a> | ©2005
By Luo </div>
</div>
<br>
</body>
<!-- InstanceEnd --></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -