queryonescorebystudentidtag.java

学生信息管理系统

package tagext;
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.http.HttpSession;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.tagext.TagSupport;
import javax.servlet.http.HttpServletRequest;
public class QueryOneScoreByStudentIdTag extends TagSupport
{
	public int doStartTag()throws JspException
	{
		JspWriter out=pageContext.getOut();
		HttpServletRequest request=(HttpServletRequest)pageContext.getRequest();
		HttpSession session=request.getSession(true);
		if(session.getAttribute("compulsoryscoreofonestudent")!=null)
		{
			try
			{
			
				CompulsoryScoreVO scorevo = (CompulsoryScoreVO)session.getAttribute("compulsoryscoreofonestudent");
				out.print("<table align=center border=1>");
				
				out.println("<td align=center><font size=5 color=blue>学号"+"</td><td align=center><font size=5 color=blue>"+scorevo.getStudentId());
				out.println("</td>");
				out.println("</tr>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>班级编号"+"</td><td  align=center><font size=5 color=blue>"+scorevo.getClassId());
				out.println("</td>");
				out.println("</tr>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>课程编号"+"</td><td align=center><font size=5 color=blue>"+scorevo.getCourseId());
				out.println("</td>");
				out.println("</tr>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>学期"+"</td><td align=center><font size=5 color=blue>"+scorevo.getTerm());
				out.println("</td>");
				
				out.println("</tr>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>分数"+"</td><td align=center><font size=5 color=blue>"+scorevo.getScore());
				out.println("</td>");
				out.println("</tr>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>考试时间"+"</td><td align=center><font size=5 color=blue>"+scorevo.getExamtime());
				out.println("</td>");
				out.println("</tr>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>备注"+"</td><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("optionalscoreofonestudent")!=null)
		{
			try
			{
			
				OptionalScoreVO scorevo = (OptionalScoreVO)session.getAttribute("optionalscoreofonestudent");
				out.print("<table align=center border=1>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>学号"+"</td><td align=center><font size=5 color=blue>"+scorevo.getStudentId());
				out.println("</td>");
				out.println("</tr>");
				
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>课程编号"+"</td><td align=center><font size=5 color=blue>"+scorevo.getCourseId());
				out.println("</td>");
				out.println("</tr>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>学期"+"</td><td align=center><font size=5 color=blue>"+scorevo.getTerm());
				out.println("</td>");
				
				out.println("</tr>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>分数"+"</td><td align=center><font size=5 color=blue>"+scorevo.getGrade());
				out.println("</td>");
				out.println("</tr>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>考试时间"+"</td><td align=center><font size=5 color=blue>"+scorevo.getExamtime());
				out.println("</td>");
				out.println("</tr>");
				out.println("<tr>");
				out.println("<td align=center><font size=5 color=blue>备注"+"</td><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;
	}
}