📄 total.jsp
字号:
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*"%>
<html>
<jsp:useBean id="total" scope="session" class="bean.Total" />
<head>
<title>汇总</title>
</head>
<body>
<p><font size="+1">排序:</font>
<form name="chk" method="post" action="total.jsp">
<input type="radio" name="by" value="1" checked>按学号
<input type="radio" name="by" value="2">按姓名
<input type="radio" name="by" value="3">按英语成绩
<input type="radio" name="by" value="4">按数学成绩
<input type="radio" name="by" value="5">按计算机成绩
<input type="radio" name="by" value="6">按总成绩
<input type="submit" name="submit" value="确认">
</form>
<table border="2" width="600">
<%
if(request.getParameter("submit")!=null){
String by=request.getParameter("by");
String ord="学号";
ResultSet tmp=total.getTotal(by);
String num="";
String name="";
String Escore="";
String Mscore="";
String Cscore="";
String Tot="";
String admin=(String)session.getAttribute("admin");
if(by.equals("1"))ord="学号";
else if(by.equals("2"))ord="姓名";
else if(by.equals("3"))ord="英语成绩";
else if(by.equals("4"))ord="数学成绩";
else if(by.equals("5"))ord="计算机成绩";
else if(by.equals("6"))ord="总成绩";
out.println("<tr><td colspan=\"6\"><center>按"+ord+"排序</center></td></tr>");
out.println("<tr>");
out.println("<td width=\"100\">学号</td><td width=\"100\">姓名</td><td width=\"100\">英语</td><td width=\"100\">数学</td><td width=\"100\">计算机</td><td width=\"100\">总成绩</td>");
out.println("</tr>");
if(admin.equals("1")){
while(tmp!=null&&tmp.next()){
num=tmp.getString("num");
name=tmp.getString("name");
Escore=tmp.getString("Escore");
Mscore=tmp.getString("Mscore");
Cscore=tmp.getString("Cscore");
Tot=tmp.getString("Total");
out.println("<tr><td>"+num+"</td>");
out.println("<td>"+name+"</td>");
out.println("<td>"+Escore+"</td>");
out.println("<td>"+Mscore+"</td>");
out.println("<td>"+Cscore+"</td>");
out.println("<td>"+Tot+"</td></tr>");
}
}
}
%>
</table>
<a href="amain.jsp">返回</a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -