📄 scores_view.jsp
字号:
<%@page contentType="text/html; charset=gb2312" language="java" errorPage="../Err.jsp"%>
<%@page import="java.util.*"%>
<%@page import="javaBeanClass.Encode2CN"%>
<%@page import="javaBeanClass.Scores.ScoresData"%>
<jsp:useBean id="Scores_View" class="javaBeanClass.Scores.Scores" scope="page"/>
<jsp:setProperty name="Scores_View" property="*"/>
<%
int pageSizes=10;
Vector vAllData=Scores_View.findAll(pageSizes);
int totalPage=Scores_View.getTotalPage();
int pageNumber=Scores_View.getPageNumber();
//where子句用的参数
String whereStr="&names="+(request.getParameter("names")==null?"":Encode2CN.getEncode(request.getParameter("names")))+
"&SN="+(request.getParameter("SN")==null?"":request.getParameter("SN"))+
"&classID="+(request.getParameter("classID")==null?"":request.getParameter("classID"))+
"&testTypeID="+(request.getParameter("testTypeID")==null?"":request.getParameter("testTypeID"))+
"&minScores="+(request.getParameter("minScores")==null?"":request.getParameter("minScores"))+
"&maxScores="+(request.getParameter("maxScores")==null?"":request.getParameter("maxScores"));
%>
<html>
<head>
<link rel="stylesheet" href="../menu/css/ioa.css" type="text/css">
<title>学员成绩查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div align="center">
<%
if(vAllData!=null){
%>
<table width="100%" border="0">
<tr>
<td width="12%">学员姓名</td>
<td width="14%">学员SN号</td>
<td width="14%">所属班级</td>
<td width="19%">试题分类</td>
<td width="21%">试卷描述</td>
<td width="10%">考试成绩</td>
<td width="10%"> </td>
</tr>
<tr>
<td colspan="7" height="3" bgcolor="#EEEEEE"></td>
</tr>
<%
ScoresData viewData=null;
for(int i=0;i<vAllData.size();i++){
viewData=(ScoresData)vAllData.elementAt(i);
%>
<tr>
<td width="12%"><%=viewData.getNames()%></td>
<td width="14%"><%=viewData.getSN()%></td>
<td width="14%"><%=viewData.getClassNumber()%>
<td width="19%"><%=viewData.getProject_CN()%> </td>
<td width="21%"><%=viewData.getTestIndexMemo()%></td>
<td width="10%"><%=viewData.getScores()%></td>
<!--<td width="10%">查看试题</td>-->
</tr>
<tr>
<td colspan="7" height="3" bgcolor="#EEEEEE"> </td>
</tr>
<%
}//end for
%>
<tr>
<td colspan="10" height="2">
<table width="100%" border="0">
<tr>
<td width="16%">第<%=pageNumber%>页/共<%=totalPage%>页</td>
<td width="16%">每页<%=pageSizes%>条记录</td>
<td width="17%">转到第
<select name="pageNumber" onChange="javascript:location.href='Scores_View.jsp?pageNumber='+this.value+'<%=whereStr%>';">
<%for(int i=1;i<=totalPage;i++){%>
<option value="<%=i%>" <%=(i==pageNumber?"selected":"")%>><%=i%></option>
<%}//end for%>
</select>
页</td>
<td width="13%">
<%if(pageNumber==1){%>
第一页
<%}else{%>
<a href="Scores_View.jsp?pageNumber=1<%=whereStr%>">第一页</a>
<%}%>
</td>
<td width="12%">
<%if(pageNumber==1){%>
上一页
<%}else{%>
<a href="Scores_View.jsp?pageNumber=<%=pageNumber-1%><%=whereStr%>">上一页</a>
<%}%>
</td>
<td width="12%">
<%if(pageNumber==totalPage){%>
下一页
<%}else{%>
<a href="Scores_View.jsp?pageNumber=<%=pageNumber+1%><%=whereStr%>">下一页</a>
<%}%>
</td>
<td width="14%">
<%if(pageNumber==totalPage){%>
最后一页
<%}else{%>
<a href="Scores_View.jsp?pageNumber=<%=totalPage%><%=whereStr%>">最后一页</a>
<%}%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
}//else if
else{
%>
没有找到记录!
<%
}//end if
%>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -