/*
 * 模型之進入考試業(yè)務(wù)操作組件
 */
package TestClass;

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

public class StartCommand implements Command
{
	private String NextPage=null;
	public StartCommand(String nextPage)
	{
		//在構(gòu)造時定義下一頁面
		this.NextPage=nextPage;
	}
	public String execute(ServletRequest request,ServletResponse response)
	{
		//取出傳來的參數(shù)信息
		String attID=request.getParameter("attNo");
	    //定義隨機數(shù)
	    int temp=0;
	    int id=0;				
		//實例狀態(tài)組件
		SubjectBean bean=new SubjectBean();
		//實例數(shù)據(jù)操作組件
		SubjectDBbean dbBean=new SubjectDBbean();
		try{
			//取試題編號
			ResultSet Rs=dbBean.executeQuery("SELECT SubID FROM Subject");
			while(Rs.next())
			{
				id=Rs.getInt(1);	
		    	//產(chǎn)生隨機數(shù)
				temp =(new Double(Math.random()*997)).intValue();
				//更新出題順序
				dbBean.executeUpdate("Update Subject set OutID="+temp+" Where SubID="+id);
			}
			ResultSet Rs1=dbBean.executeQuery("SELECT * FROM Subject INNER JOIN ExToSub on Subject.SubID=ExToSub.SubID Where ExToSub.ExNo='ACCPno001' Order by OutID");
			/*
			 *request.setAttribute傳送有問題,
			 *Test.jsp頁面用: ResultSet Rs=(ResultSet)request.getAttribute("AllList");接收不到
			 */
			request.setAttribute("TestSub",Rs1);
//			request.setAttribute("AllList",dbBean.GetAllData());
		}
		catch(Exception e){
			System.out.println("StartCommand: "+e);
		}
		dbBean.Close();
		return NextPage;
	}
}