package TestClass;

import javax.servlet.*;
import java.sql.*;
import javax.xml.parsers.*;
import org.apache.crimson.tree.*;
import org.w3c.dom.*;
import java.io.*;

public class PrintCommand implements Command
{
	private String NextPage=null;
	public PrintCommand(String nextPage)
	{
		this.NextPage=nextPage;
	}
	public String execute(ServletRequest request,ServletResponse response)
	{
 		//取出傳來的參數信息
		String rdoExam=request.getParameter("rdoExam");

		Document doc;
	    Element TestScore = null;
	    Element person = null; 
	    Element name = null; 
	    Element identy = null; 
	    Element pass = null; 
	    Element score = null; 
	    try{
			AttendmentBean a1=new AttendmentBean();
			AttendmentDBbean a2=new AttendmentDBbean();

			ResultSet results=a2.executeQuery("SELECT * FROM AttToEx INNER JOIN Attendment ON Attendment.pNo = AttToEx.pNo Where AttToEx.ExNo='"+rdoExam+"'");
	
	      	DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
	      	DocumentBuilder builder=dbf.newDocumentBuilder();
	      	doc = builder.newDocument();
	      
	      	TestScore = doc.createElement("TESTSCORE"); 
	      	while (results.next())
	      	{ 
	      		String pNo=results.getString("Attendment.pNo");
	      		String pName=results.getString("pName");
	      		String pID=results.getString("pID");
	      		String permitNo=results.getString("permitNo");
	      		double pscore=results.getDouble("pScore");
	      		String pScore=String.valueOf(score);
	      		
	        	person = doc.createElement("PERSON");
	        	person.setAttribute("PERSONID",pNo); 
	        	TestScore.appendChild(person);
	
		        name = doc.createElement("NAME");
		        name.appendChild(doc.createTextNode(pName));
		        person.appendChild(name);
		
		        identy = doc.createElement("IDENTIFICATION");
		        identy.appendChild(doc.createTextNode(pID));
		        person.appendChild(identy);
		
		        pass = doc.createElement("TESTPASSPORT");
		        pass.appendChild(doc.createTextNode(permitNo));
		        person.appendChild(pass);
	
		        score = doc.createElement("SCORE");
		        score.appendChild(doc.createTextNode(pScore));
		        person.appendChild(score);
	      }
	      doc.appendChild(TestScore);
	      ((XmlDocument)doc).write(System.out);
		  ((XmlDocument)doc).write(new java.io.FileOutputStream("Score.xml"));
	    }
	    catch(Exception e){}
		return NextPage;
	}
}