📄 analyse.jsp
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%@page import="java.util.Date"%>
<%@page import="java.util.Calendar"%>
<%@page import="java.sql.*"%>
<%@page import="java.text.*"%>
<%@page import="java.lang.Integer"%>
<%@page import="java.lang.reflect.Array"%>
<jsp:useBean id="Operate" scope="page" class="todb.Operate"/>
<%
ResultSet rs = null;
String studentdept=new String(request.getParameter("studept").getBytes("ISO8859_1"));
String studentclass=new String(request.getParameter("stuclass").getBytes("ISO8859_1"));
%>
<html>
<head>
<title></title>
<style type="text/css">
<!--
.style1 {
font-size: xx-large;
font-weight: bold;
}
-->
</style>
</head>
<body>
<p>
<%
int i=0;
int j=0;
int rscount=0;
int min=0;
int max=0;
int average=0;
int sum=0;
//int score[]=new int[];
int temp=0;
int A=0;
int B=0;
int C=0;
int D=0;
int E=0;
int F=0;
int G=0;
int que=0;
byte[] tmpbyte;
String ctemp;
try{
//获得结果集
rs = Operate.executeQuery("select count(*) from student where student_dept='"+studentdept+"' and student_class='"+studentclass+"'");
while(rs.next()){rscount=rs.getInt(1);}
//out.println("该班学生总数为："+rscount);
int score[]=new int[rscount];
//获得结果集
rs = Operate.executeQuery("select * from student where student_dept='"+studentdept+"' and student_class='"+studentclass+"'");
i=0;
while(rs.next()){
score[i]=rs.getInt("student_score");
i++;
}
for(i=0;i<score.length;i++)
{
if(score[i]>=90) A++;
if(score[i]>=80&&score[i]<90) B++;
if(score[i]>=70&&score[i]<80) C++;
if(score[i]>=60&&score[i]<70) D++;
if(score[i]>=50&&score[i]<60) E++;
if(score[i]>=40&&score[i]<50) F++;
if(score[i]<40&&score[i]>0) G++;
if(score[i]==0) que++;
sum=sum+score[i];
average=sum/score.length;
}
for(i=1;i<score.length;i++)
{
for(j=0;j<i;j++)
{
if(score[i]<score[j])
{
temp=score[i];
score[i]=score[j];
score[j]=temp;
}
}
}
min=score[0];
max=score[score.length-1];
}catch(SQLException ex){
ctemp=ex.toString();
tmpbyte=ex.getMessage().getBytes("GBK");
ctemp=new String(tmpbyte,"ISO8859_1");
out.print(ctemp);
}
%>
</p>
<table width="640" height="90" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center" class="style1">高等教育院校试卷分析报告</div></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width="640" height="100" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="middle"> 系（部、所、室） 教研室 课程名称：<strong>计算机基础</strong></td>
</tr>
<tr>
<td valign="middle"> 任课教师： 试题来源：<strong>试题库抽题</strong> 阅卷方式：<strong>系统自动阅卷</strong></td>
</tr>
<tr>
<td valign="middle"> 阅卷人员：<strong>无（系统自动阅卷）</strong> 考试对象：
<%out.print("<strong>"+studentdept+"</strong>");%> 系</td>
</tr>
<tr>
<td valign="middle"> 年级班级
<%out.print("<strong>"+studentclass+"</strong>");%> ，应考人数：<%out.print("<strong>"+rscount+"</strong>");%> 实考人数：
<%out.print("<strong>"+(rscount-que)+"</strong>");%>
考试时间：<strong>120分钟</strong></td>
</tr>
</table>
<table width="640" height="47" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>一、分数分布</td>
</tr>
<tr>
<td> 1、分数段分布</td>
</tr>
</table>
<div align="center">
<table width="580" height="100" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="80"><div align="center">分数段</div></td>
<td width="70"><div align="center"><40</div></td>
<td width="70"><div align="center">40-49</div></td>
<td width="70"><div align="center">50-59</div></td>
<td width="70"><div align="center">60-69</div></td>
<td width="70"><div align="center">70-79</div></td>
<td width="67"><div align="center">80-89</div></td>
<td width="65"><div align="center">90-100</div></td>
</tr>
<tr>
<td><div align="center">等 级</div></td>
<td><div align="center">不及格</div></td>
<td><div align="center">不及格</div></td>
<td><div align="center">不及格</div></td>
<td><div align="center">及格</div></td>
<td><div align="center">中等</div></td>
<td><div align="center">良好</div></td>
<td><div align="center">优秀</div></td>
</tr>
<tr>
<td><div align="center">人 数</div></td>
<td><div align="center"><%out.print(G);%></div></td>
<td><div align="center"><%out.print(F);%></div></td>
<td><div align="center"><%out.print(E);%></div></td>
<td><div align="center"><%out.print(D);%></div></td>
<td><div align="center"><%out.print(C);%></div></td>
<td><div align="center"><%out.print(B);%></div></td>
<td><div align="center"><%out.print(A);%></div></td>
</tr>
<tr>
<td><div align="center">百分比</div></td>
<td><div align="center"><%out.print(Integer.toString((int)(100*G/rscount)));%></div></td>
<td><div align="center"><%out.print(Integer.toString((int)(100*F/rscount)));%></div></td>
<td><div align="center"><%out.print(Integer.toString((int)(100*E/rscount)));%></div></td>
<td><div align="center"><%out.print(Integer.toString((int)(100*D/rscount)));%></div></td>
<td><div align="center"><%out.print(Integer.toString((int)(100*C/rscount)));%></div></td>
<td><div align="center"><%out.print(Integer.toString((int)(100*B/rscount)));%></div></td>
<td><div align="center"><%out.print(Integer.toString((int)(100*A/rscount)));%></div></td>
</tr>
</table>
<table width="640" height="25" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> 2、</td>
</tr>
</table>
</div>
<table width="580" height="50" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">最高分</div></td>
<td><div align="center">最低分</div></td>
<td><div align="center">平均分</div></td>
<td><div align="center">试卷难度</div></td>
</tr>
<tr>
<td><div align="center"><%out.print(max);%></div></td>
<td><div align="center"><%out.print(min);%></div></td>
<td><div align="center"><%out.print(average);%></div></td>
<td><div align="center"></div></td>
</tr>
</table>
<table width="640" height="925" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="25">二、试卷质量分析</td>
</tr>
<tr>
<td height="25"> 1、试题有无科学性错误</td>
</tr>
<tr>
<td height="120"> </td>
</tr>
<tr>
<td height="25"> 2、试题量是否适中</td>
</tr>
<tr>
<td height="120"> </td>
</tr>
<tr>
<td height="25"> 3、试题是否符合课程教学大纲和考试大纲</td>
</tr>
<tr>
<td height="120"> </td>
</tr>
<tr>
<td height="25"> 4、试题内容覆盖面如何</td>
</tr>
<tr>
<td height="120"> </td>
</tr>
<tr>
<td height="25"> 5、错答分布及分析</td>
</tr>
<tr>
<td height="120"> </td>
</tr>
<tr>
<td>三、考试小节（经验、教训及改进意见）</td>
</tr>
<tr>
<td height="149"> </td>
</tr>
</table>
<table width="640" height="75" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> 报告执笔人（签名）： 系主任（签名）：</td>
</tr>
<tr>
<td> 教研室主任（签名）： 年 月 日</td>
</tr>
<tr>
<td> 注：本报告一式三份，连同学生成成绩考核记录册一份存教研室，一份报系办，一份报教务处存档。</td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -