score.jsp
上传用户:ht0805
上传日期:2013-10-20
资源大小:384k
文件大小:2k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

Java

  1. <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
  2. <html>
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  5. <title>score</title>
  6. </head>
  7. <jsp:useBean id="deter" scope="page" class="determine"/>
  8. <body bgcolor="#0099FF" text="#FFFFFF" link="#00FF00">
  9. <div align="center"> 
  10.   <p>&nbsp;</p>
  11.   <p><font color="#00FF00" size="+3" face="方正舒体">选报该课程的学生有</font></p>
  12.   <p>&nbsp;</p>
  13.   <table width="75%" border="1">
  14.     <tr> 
  15.       <td>学生姓名</td>
  16.       <td>所在系</td>
  17.       <td>性别</td>
  18.       <td>学分</td>
  19.       <td>Email</td>
  20.       <td>Tel</td>
  21.       <td>成绩</td>
  22.     </tr>
  23.     <%
  24. String class_id=request.getParameter("class_id");
  25. String name=null;
  26. String dep=null;
  27. String sex=null;
  28. int mark=0;
  29. String e_mail=null;
  30. String tel=null;
  31. ResultSet rs=deter.getStudents2(class_id);
  32. String stu_id=null;
  33. while(rs.next()){
  34. stu_id=rs.getString("id");
  35. name=rs.getString("name");
  36. dep=rs.getString("department");
  37. sex=rs.getString("sex");
  38. mark=rs.getInt("mark");
  39. e_mail=rs.getString("e_mail");
  40. tel=rs.getString("tel");
  41. %>
  42.     <tr> 
  43.       <td><%=name%></td>
  44.       <td><%=dep%></td>
  45.       <td><%=sex%></td>
  46.       <td><%=mark%></td>
  47.       <td><%=e_mail%></td>
  48.       <td><%=tel%></td>
  49.       <td><a href="marking.jsp?stu_id=<%=stu_id%>&class_id=<%=class_id%> ">score</a></td>
  50.     </tr>
  51. <%
  52. }
  53. %>
  54.   </table>
  55.   <p>&nbsp;</p>
  56.   <p align="left"><a href="choosestu.jsp">&lt;&lt;Back </a></p>
  57. </div>
  58. </body>
  59. </html>