📄 count.jsp
字号:
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*"%>
<html>
<jsp:useBean id="count" scope="session" class="bean.Count" />
<head>
<title>统计</title>
</head>
<body>
<h3>统计信息 <a href="amain.jsp"><font size="-2">返回</font></a></h3>
<table border="2" width="600">
<tr>
<td colspan="3"><center>平均分</center></td>
</tr>
<tr>
<td width="200">英语</td><td width="200">数学</td><td width="200">计算机</td>
</tr>
<tr>
<td><%out.println(count.getEscore());%></td>
<td><%out.println(count.getMscore());%></td>
<td><%out.println(count.getCscore());%></td>
</tr>
</table>
<p>
<table border="0">
<tr>
<td>
<table border="2" width="300">
<tr>
<td colspan="2"><center>英语最高分</center></td>
</tr>
<tr>
<td width="150">最高分</td><td width="150">姓名</td>
</tr>
<%
ResultSet hE=count.getHighE();
while(hE!=null&&hE.next()){
out.println("<tr>");
out.println("<td>"+hE.getString("Escore")+"</td>");
out.println("<td>"+hE.getString("name")+"</td>");
out.println("</tr>");
}
%>
</table>
</td><td>
<table border="2" width="300">
<tr>
<td colspan="2"><center>英语最低分</center></td>
</tr>
<tr>
<td width="150">最低分</td><td width="150">姓名</td>
</tr>
<%
hE=count.getLowE();
while(hE!=null&&hE.next()){
out.println("<tr>");
out.println("<td>"+hE.getString("Escore")+"</td>");
out.println("<td>"+hE.getString("name")+"</td>");
out.println("</tr>");
}
%>
</table>
</td>
</tr>
<tr>
<td>
<table border="2" width="300">
<tr>
<td colspan="2"><center>数学最高分</center></td>
</tr>
<tr>
<td width="150">最高分</td><td width="150">姓名</td>
</tr>
<%
hE=count.getHighM();
while(hE!=null&&hE.next()){
out.println("<tr>");
out.println("<td>"+hE.getString("Mscore")+"</td>");
out.println("<td>"+hE.getString("name")+"</td>");
out.println("</tr>");
}
%>
</table>
</td><td>
<table border="2" width="300">
<tr>
<td colspan="2"><center>数学最低分</center></td>
</tr>
<tr>
<td width="150">最低分</td><td width="150">姓名</td>
</tr>
<%
hE=count.getLowM();
while(hE!=null&&hE.next()){
out.println("<tr>");
out.println("<td>"+hE.getString("Mscore")+"</td>");
out.println("<td>"+hE.getString("name")+"</td>");
out.println("</tr>");
}
%>
</table>
</td>
</tr>
<tr>
<td>
<table border="2" width="300">
<tr>
<td colspan="2"><center>计算机最高分</center></td>
</tr>
<tr>
<td width="150">最高分</td><td width="150">姓名</td>
</tr>
<%
hE=count.getHighC();
while(hE!=null&&hE.next()){
out.println("<tr>");
out.println("<td>"+hE.getString("Cscore")+"</td>");
out.println("<td>"+hE.getString("name")+"</td>");
out.println("</tr>");
}
%>
</table>
</td><td>
<table border="2" width="300">
<tr>
<td colspan="2"><center>计算机最低分</center></td>
</tr>
<tr>
<td width="150">最低分</td><td width="150">姓名</td>
</tr>
<%
hE=count.getLowC();
while(hE!=null&&hE.next()){
out.println("<tr>");
out.println("<td>"+hE.getString("Cscore")+"</td>");
out.println("<td>"+hE.getString("name")+"</td>");
out.println("</tr>");
}
%>
</table>
</td>
</tr>
<tr>
<td>
<table border="2" width="300">
<tr>
<td colspan="2"><center>最高总分</center></td>
</tr>
<tr>
<td width="150">最高分</td><td width="150">姓名</td>
</tr>
<%
hE=count.getHighT();
while(hE!=null&&hE.next()){
out.println("<tr>");
out.println("<td>"+hE.getString("Total")+"</td>");
out.println("<td>"+hE.getString("name")+"</td>");
out.println("</tr>");
}
%>
</table>
</td><td>
<table border="2" width="300">
<tr>
<td colspan="2"><center>最低总分</center></td>
</tr>
<tr>
<td width="150">最低分</td><td width="150">姓名</td>
</tr>
<%
hE=count.getLowT();
while(hE!=null&&hE.next()){
out.println("<tr>");
out.println("<td>"+hE.getString("Total")+"</td>");
out.println("<td>"+hE.getString("name")+"</td>");
out.println("</tr>");
}
%>
</table>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -