📄 report.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page import="java.sql.ResultSet"%>
<script Language="vbscript">
sub check()
c=document.form1.page.value
if c<>"" then
if not IsNumeric(c) then
msgbox " 页数只能输入数字"
document.form1.page.select()
exit sub
else
end if
else
msgbox"请输入想要转到页数"
document.form1.page.select()
exit sub
end if
document.form1.submit()
end sub
</script>
<html>
<head>
<%!String keywords ;
String topage;
// 设置每张网业显示30笔记录
int pagesize=30;
//设置预显示的页数
int showpage=1;
// ResultSet记录的笔数
int rowcount =0;
// 分页后的总页数
int pagecount=0;
int id1;
int fenshu;
String sel;
String data;
String name;
String str1;
String tg;
String bg;
String no;
String daan;
String sql;
ResultSet rs2,rs3;
int sid;
int id;
%>
<title>网上考试系统</title>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body topmargin="0" leftmargin="0">
<%
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
topage=request.getParameter("page");
String keyword=request.getParameter("keyword");
if( keyword==null ){
keywords="所有题目";
}
else{
keywords=keyword;
}
%>
<%request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
str1=request.getParameter("reportid");
if(str1==null){
str1="1";
}
sid=Integer.parseInt(str1);
%>
<%DBConn db2=new DBConn();
String sql3="select * from test";
String sql4="select * from test where id='"+sid+"'";
rs2=db2.Query(sql3);
rs3=db2.Query(sql4);
%>
<p>
<p align="center"><font class=test1>成绩统计管理</font><br>
</p>
<div align="center">
<center>
<table border="1" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="600">
<tr>
<td align="center" colspan="4"> 往期统计：
<select name="cate" size="1" style="background-color: rgb(224,252,255)" onchange="javascript:self.location=this.options[this.selectedIndex].value">
<% while(rs2.next()){ %>
<option value="report.jsp?reportid=<%=rs2.getInt("id") %>" <%=sid==rs2.getInt("id") ?"selected":"" %> >第<%=rs2.getInt("id") %>期</option>
<%} %>
</select>
<%rs3.next(); %>
<p>第 <%=sid%> 期考试统计（判断题数<%=rs3.getInt("id1") %>题/<%=rs3.getInt("fenshu1") %>分，选择题数<%=rs3.getInt("id2") %>题/<%=rs3.getInt("fenshu2") %>分，填空题数<%=rs3.getInt("id3") %>题/<%=rs3.getInt("fenshu3") %>分）<a href=test_tj.jsp?qid=<%=sid%>>[本期统计]</a></p>
<form method="post" name=form2 action="report.jsp">
<tr>
<td align="center" colspan="5">以下为学号为<font color=red> <%=keywords%> </font>的考生列表
输入考生学号 <input type="text" name="keyword" size="20" > <input type="submit" value="查找" name="B1"></td>
</tr>
</form>
<tr>
<td align="center" bgcolor="#CBEFDC">考生学号</td>
<td align="center" bgcolor="#CBEFDC">分数</td>
<td align="center" bgcolor="#CBEFDC">是否及格</td>
<td align="center" bgcolor="#CBEFDC">考试时间</td>
</tr>
<% if(keywords.equals("所有题目")){
sql="select * from chengji where id1='"+sid+"'";
}else{
sql="select * from chengji where no='"+keyword+"' and id1='"+sid+"' ";
}
DBConn db=new DBConn();
ResultSet rs=db.Query(sql);
rs.last();
rowcount=rs.getRow();
pagecount=((rowcount%pagesize)==0?
(rowcount/pagesize):(rowcount/pagesize+1));
%>
<%if(topage!=null){
showpage=Integer.parseInt(topage);
if(showpage>pagecount)
{
showpage=pagecount;
}
else if(showpage<=0)
{
showpage=1;
}
}
rs.absolute((showpage-1)*pagesize+1); %>
<%for(int i=1;i<=pagesize;){%>
<% if(rowcount==0){%>
<tr><td colspan=5><center><font color=red>没有你查的学生信息</font></center></td></tr>
<%break;}%>
<% i++;
no=rs.getString("no");
sel=rs.getString("sel");
fenshu=rs.getInt("fenshu");
data=rs.getString("data");
id=rs.getInt("id");
if(i%2==0)
{
bg="#E9F8F0";
}else{
bg="#ffffff";
}
if(sel.equals("0")){
sel="不及格";
tg="#FF0000";
}
else{
sel="及格";
tg="#000033";
}
%>
<tr bgcolor=<%=bg %>>
<td align="center"><a href="student.jsp?chengjiid=<%=id%>"><%=no%></a></td>
<td align="center"> <font color=<%=tg%>><%=fenshu %></font></td>
<td align="center"><%=sel%></td>
<td align="center">
<%=data%></td>
</tr>
<%if(!rs.next()){
break;}%>
<%}%>
<tr>
<td colspan="4" align="center">
<p align="center">
<form action=report.jsp method="post" name=form1 >
30条一页 <a href="report.jsp?page=1" target="right">第一页</a> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -