开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Jsp/Servlet > 查看源码
count.jsp
资源名称：jsp.rar　[点击查看]
上传用户：szaosen
上传日期：2007-08-07
资源大小：40k
文件大小：4k
源码类别：

Jsp/Servlet

开发平台：

Java

count.jsp：源码内容
  1. <%@ page contentType="text/html; charset=utf-8" import="java.sql.*"%>
  2. <html>
  3. <jsp:useBean id="count" scope="session" class="bean.Count" />
  4. <head>
  5. <title>统计</title>
  6. </head>
  7. <body>
  8. <h3>统计信息&nbsp;&nbsp;&nbsp;<a href="amain.jsp"><font size="-2">返回</font></a></h3>
  9. <table border="2" width="600">
  10. <tr>
  11. <td colspan="3"><center>平均分</center></td>
  12. </tr>
  13. <tr>
  14. <td width="200">英语</td><td width="200">数学</td><td width="200">计算机</td>
  15. </tr>
  16. <tr>
  17. <td><%out.println(count.getEscore());%></td>
  18. <td><%out.println(count.getMscore());%></td>
  19. <td><%out.println(count.getCscore());%></td>
  20. </tr>
  21. </table>
  22. <p>
  23. <table border="0">
  24. <tr>
  25. <td>
  26. <table border="2" width="300">
  27. <tr>
  28. <td colspan="2"><center>英语最高分</center></td>
  29. </tr>
  30. <tr>
  31. <td width="150">最高分</td><td width="150">姓名</td>
  32. </tr>
  33. <%
  34.         ResultSet hE=count.getHighE();
  35. while(hE!=null&&hE.next()){
  36.     out.println("<tr>");
  37. out.println("<td>"+hE.getString("Escore")+"</td>");
  38. out.println("<td>"+hE.getString("name")+"</td>");
  39. out.println("</tr>");
  40. }
  41. %>
  42. </table>
  43. </td><td>
  44. <table border="2" width="300">
  45. <tr>
  46. <td colspan="2"><center>英语最低分</center></td>
  47. </tr>
  48. <tr>
  49. <td width="150">最低分</td><td width="150">姓名</td>
  50. </tr>
  51. <%
  52.         hE=count.getLowE();
  53. while(hE!=null&&hE.next()){
  54.     out.println("<tr>");
  55. out.println("<td>"+hE.getString("Escore")+"</td>");
  56. out.println("<td>"+hE.getString("name")+"</td>");
  57. out.println("</tr>");
  58. }
  59. %>
  60. </table>
  61. </td>
  62. </tr>
  63. <tr>
  64. <td>
  65. <table border="2" width="300">
  66. <tr>
  67. <td colspan="2"><center>数学最高分</center></td>
  68. </tr>
  69. <tr>
  70. <td width="150">最高分</td><td width="150">姓名</td>
  71. </tr>
  72. <%
  73.         hE=count.getHighM();
  74. while(hE!=null&&hE.next()){
  75.     out.println("<tr>");
  76. out.println("<td>"+hE.getString("Mscore")+"</td>");
  77. out.println("<td>"+hE.getString("name")+"</td>");
  78. out.println("</tr>");
  79. }
  80. %>
  81. </table>
  82. </td><td>
  83. <table border="2" width="300">
  84. <tr>
  85. <td colspan="2"><center>数学最低分</center></td>
  86. </tr>
  87. <tr>
  88. <td width="150">最低分</td><td width="150">姓名</td>
  89. </tr>
  90. <%
  91.         hE=count.getLowM();
  92. while(hE!=null&&hE.next()){
  93.     out.println("<tr>");
  94. out.println("<td>"+hE.getString("Mscore")+"</td>");
  95. out.println("<td>"+hE.getString("name")+"</td>");
  96. out.println("</tr>");
  97. }
  98. %>
  99. </table>
  100. </td>
  101. </tr>
  102. <tr>
  103. <td>
  104. <table border="2" width="300">
  105. <tr>
  106. <td colspan="2"><center>计算机最高分</center></td>
  107. </tr>
  108. <tr>
  109. <td width="150">最高分</td><td width="150">姓名</td>
  110. </tr>
  111. <%
  112.         hE=count.getHighC();
  113. while(hE!=null&&hE.next()){
  114.     out.println("<tr>");
  115. out.println("<td>"+hE.getString("Cscore")+"</td>");
  116. out.println("<td>"+hE.getString("name")+"</td>");
  117. out.println("</tr>");
  118. }
  119. %>
  120. </table>
  121. </td><td>
  122. <table border="2" width="300">
  123. <tr>
  124. <td colspan="2"><center>计算机最低分</center></td>
  125. </tr>
  126. <tr>
  127. <td width="150">最低分</td><td width="150">姓名</td>
  128. </tr>
  129. <%
  130.         hE=count.getLowC();
  131. while(hE!=null&&hE.next()){
  132.     out.println("<tr>");
  133. out.println("<td>"+hE.getString("Cscore")+"</td>");
  134. out.println("<td>"+hE.getString("name")+"</td>");
  135. out.println("</tr>");
  136. }
  137. %>
  138. </table>
  139. </td>
  140. </tr>
  141. <tr>
  142. <td>
  143. <table border="2" width="300">
  144. <tr>
  145. <td colspan="2"><center>最高总分</center></td>
  146. </tr>
  147. <tr>
  148. <td width="150">最高分</td><td width="150">姓名</td>
  149. </tr>
  150. <%
  151.         hE=count.getHighT();
  152. while(hE!=null&&hE.next()){
  153.     out.println("<tr>");
  154. out.println("<td>"+hE.getString("Total")+"</td>");
  155. out.println("<td>"+hE.getString("name")+"</td>");
  156. out.println("</tr>");
  157. }
  158. %>
  159. </table>
  160. </td><td>
  161. <table border="2" width="300">
  162. <tr>
  163. <td colspan="2"><center>最低总分</center></td>
  164. </tr>
  165. <tr>
  166. <td width="150">最低分</td><td width="150">姓名</td>
  167. </tr>
  168. <%
  169.         hE=count.getLowT();
  170. while(hE!=null&&hE.next()){
  171.     out.println("<tr>");
  172. out.println("<td>"+hE.getString("Total")+"</td>");
  173. out.println("<td>"+hE.getString("name")+"</td>");
  174. out.println("</tr>");
  175. }
  176. %>
  177. </table>
  178. </td>
  179. </tr>
  180. </table>
  181. </body>
  182. </html>