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;
	}
}