scorecommand.java

北大青鸟在线考试系统,包括在线考试模块,教师管理模块,系统管理模块

package TestClass;

import javax.servlet.*;
import java.io.*;
import java.sql.*;
import java.util.*;

public class ScoreCommand implements Command
{
	private String NextPage=null;
	public ScoreCommand(String next)
	{
		this.NextPage=next;
	}
	public String execute(ServletRequest request,ServletResponse response)
	{
		int OK=0;
		int flag=0;
		String SubID=null;
		String stAns=null;
		double Score=0;
		//取出传来的参数信息
		String attID=request.getParameter("attID");
		//实例状态组件
		SubjectBean bean=new SubjectBean();
		AttToExBean scoreBean=new AttToExBean();
		//实例数据操作组件
		SubjectDBbean dbBean=new SubjectDBbean();
		AttToExDBbean scoredbBean=new AttToExDBbean();
		//查询试题编号
		ResultSet Rs=dbBean.executeQuery("SELECT Subject.SubID,Subject.Answer FROM Subject INNER JOIN ExToSub on Subject.SubID=ExToSub.SubID Where ExToSub.ExNo='ACCPno001' Order by OutID");
		try{
			//显示记录行
			while(Rs.next())
			{
				flag++;
				//取出试题编号
				int results=Rs.getInt(1);
				SubID=String.valueOf(results);
				//取出试题标准答案
				stAns=Rs.getString(2);
				//取出考生所做的答案
				String[] subAnswer=request.getParameterValues(SubID);
				String subAns="";
				for(int i=0;i<subAnswer.length;i++)
					subAns=subAns+subAnswer[i];
				//将标准答案与考生答案比较,做对的记为1
				if(stAns.equals(subAns))
					OK++;
			}
			//计算考生成绩
			Score=OK*100/flag;
			//更新考生成绩				
			scoredbBean.executeUpdate("Update AttToEx set pScore="+Score+" Where pNo='"+attID+"' and ExNo='ACCPno001'");
			request.setAttribute("Score",Score);
			scoredbBean.Close();
			Rs.close();
			dbBean.Close();
		}
		catch(Exception e){}
		return NextPage;
	}
	private String ToCn(String strvalue) 
	{
		String restr = null;
		try{
			if(strvalue!=null)
				restr = new String(strvalue.getBytes("ISO8859_1"), "GBK");
		}
		catch(Exception e){}
		return restr;
	}
}