queryonestudentallscoretag.java

学生信息管理系统

package action;
import java.io.*;
import java.util.*;
import vo.OptionalScoreVO;
import vo.CompulsoryScoreVO;
import dao.OptionalScoreDAO;
import dao.CompulsoryScoreDAO;

import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.PageContext;
import javax.servlet.jsp.JspException;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.jsp.tagext.TagSupport;

public class QueryOneStudentAllScoreTag extends TagSupport
{
	public int doStartTag()throws JspException
	{
		JspWriter out = pageContext.getOut();
		HttpServletRequest request = (HttpServletRequest)pageContext.getRequest();
		HttpSession session = request.getSession(true);
		if(session.getAttribute("compulsoryscoresofonestudent")!=null)
		{
			try
			{
				ArrayList scores=(ArrayList)session.getAttribute("compulsoryscoresofonestudent");
				
				out.print("<table align=center border=1>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>学号");
				out.println("</td>");
				out.println("<td align=center><font size=5 color=blue>课程编号");
				out.println("</td>");
				out.println("<td align=center><font size=5 color=blue>班级编号");
				out.println("</td>");
				out.println("<td align=center><font size=5 color=blue>学期");
				out.println("</td>");
				out.println("<td align=center><font size=5 color=blue>分数");
				out.println("</td>");
				out.println("<td align=center><font size=5 color=blue>考试时间");
				out.println("</td>");
				out.println("<td align=center><font size=5 color=blue>备注");
				out.println("</td>");
				
				out.println("</tr>");
				
				for(int i=0;i<scores.size();i++)
				
				{
					CompulsoryScoreVO scorevo=(CompulsoryScoreVO)scores.get(i);
					out.println("<tr>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getStudentId());
					out.println("</td>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getCourseId());
					out.println("</td>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getClassId());
					out.println("</td>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getTerm());
					out.println("</td>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getScore());
					out.println("</td>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getExamtime());
					out.println("</td>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getNote());
					out.println("</td>");
					out.println("</tr>");
				}
		    	out.println("</table>");	
			}
		    catch(IOException ioe)
		    {
		    	ioe.printStackTrace();
		    }
	
		}
		else if(session.getAttribute("optionalscoresofonestudent")!=null)
		{
			try
			{
				ArrayList scores=(ArrayList)session.getAttribute("optionalscoresofonestudent");
				
				out.print("<table align=center border=1>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>学号");
				out.println("</td>");
				out.println("<td align=center><font size=5 color=blue>课程编号");
				out.println("</td>");
				
				out.println("<td align=center><font size=5 color=blue>学期");
				out.println("</td>");
				out.println("<td align=center><font size=5 color=blue>分数");
				out.println("</td>");
				out.println("<td align=center><font size=5 color=blue>考试时间");
				out.println("</td>");
				out.println("<td align=center><font size=5 color=blue>备注");
				out.println("</td>");
				
				out.println("</tr>");
				
				for(int i=0;i<scores.size();i++)
				
				{
					OptionalScoreVO scorevo=(OptionalScoreVO)scores.get(i);
					out.println("<tr>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getStudentId());
					out.println("</td>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getCourseId());
					out.println("</td>");
					
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getTerm());
					out.println("</td>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getGrade());
					out.println("</td>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getExamtime());
					out.println("</td>");
					out.println("<td align=center><font size=5 color=blue>"+scorevo.getNote());
					out.println("</td>");
					out.println("</tr>");
				}
		    	out.println("</table>");	
			}
		    catch(IOException ioe)
		    {
		    	ioe.printStackTrace();
		    }
		}
		return this.SKIP_BODY;
	}
	public int doEndTag()throws JspException
	{
		return this.EVAL_PAGE;
	}
}