📄 queryonescorebystudentidaction.java

📁 学生信息管理系统
💻 JAVA
字号:
package action;
import java.io.*;
import java.util.*;
import vo.CompulsoryScoreVO;
import vo.OptionalScoreVO;
import dao.OptionalScoreDAO;
import dao.CompulsoryScoreDAO;
import javax.servlet.*;
import javax.servlet.http.*;
import util.CharsetExchange;
public class QueryOneScoreByStudentIdAction extends HttpServlet
{
	public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException
	{
		String student_id=request.getParameter("student_id");
		String course_id=CharsetExchange.ISOToGB(request.getParameter("courses"));
		String term=request.getParameter("term");
		String coursetype=CharsetExchange.ISOToGB(request.getParameter("coursetype"));
		if(coursetype.equals("必修课"))
		{
			CompulsoryScoreDAO scoredao=new CompulsoryScoreDAO();
			boolean isexist=scoredao.checkScore(student_id,term,course_id);
			if(!isexist)
			{
				response.setCharacterEncoding("gb2312");
				response.setContentType("text/html");
				PrintWriter out=response.getWriter();
				out.println("<html>");
				out.println("<head><meta http-equiv=refresh content=2;url=QueryOneClassScore.jsp>");
				out.println("<title>查询学生成绩信息</title></head>");
				out.println("<body background=2.jpg>");
				out.println("<br><br><br>");
				out.println("<h1 align=center ><font color=red>对不起，该学生的该门成绩不存在，无法查询</font></h1><hr>");
				out.println("<br><br>");
				out.println("</body>");
				out.println("</html>");
			}
			else
			{
				CompulsoryScoreVO scorevo=new CompulsoryScoreVO();
				scorevo=scoredao.getScoreByStudentId(student_id,term,course_id);
				HttpSession session=request.getSession(true);
				session.setAttribute("compulsoryscoreofonestudent",scorevo);
				this.getServletContext().getRequestDispatcher("/QueryOneScoreByStudentIdResult.jsp").forward(request,response);
			}
			
			
			
		}
		else if(coursetype.equals("选修课"))
		{
			OptionalScoreDAO scoredao=new OptionalScoreDAO();
			boolean isexist=scoredao.checkScore(student_id,term,course_id);
			if(!isexist)
			{
				response.setCharacterEncoding("gb2312");
				response.setContentType("text/html");
				PrintWriter out=response.getWriter();
				out.println("<html>");
				out.println("<head><meta http-equiv=refresh content=2;url=QueryOneClassScore.jsp>");
				out.println("<title>查询学生成绩信息</title></head>");
				out.println("<body background=2.jpg>");
				out.println("<br><br><br>");
				out.println("<h1 align=center ><font color=red>对不起，该学生的该门成绩不存在，无法查询</font></h1><hr>");
				out.println("<br><br>");
				out.println("</body>");
				out.println("</html>");
			}
			else
			{
				OptionalScoreVO scorevo=new OptionalScoreVO();
				scorevo=scoredao.getScoreByStudentId(student_id,term,course_id);
				HttpSession session=request.getSession(true);
				session.setAttribute("optionalscoreofonestudent",scorevo);
				this.getServletContext().getRequestDispatcher("/QueryOneScoreByStudentIdResult.jsp").forward(request,response);
			}
		}
		
		
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException
	{
		doGet(request,response);
	}
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -