📄 queryonestudentallscoreaction.java

📁 学生信息管理系统
💻 JAVA
字号:
package action;
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import vo.OptionalScoreVO;
import vo.CompulsoryScoreVO;
import dao.OptionalScoreDAO;
import dao.CompulsoryScoreDAO;
import util.CharsetExchange;
public class QueryOneStudentAllScoreAction extends HttpServlet
{
	public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException
	{
		String student_id=request.getParameter("student_id");
		String term=request.getParameter("term");
		String coursetype=CharsetExchange.ISOToGB(request.getParameter("coursetype"));
		if(coursetype.equals("必修课"))
		{
			CompulsoryScoreDAO scoredao=new CompulsoryScoreDAO();
			boolean isexist=scoredao.checkStudent(student_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=addStudent.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
			{
				ArrayList scores=scoredao.getScoresByStudentId(student_id,term);
				HttpSession session=request.getSession(true);
				session.setAttribute("compulsoryscoresofonestudent",scores);
				this.getServletContext().getRequestDispatcher("/QueryOneStudentAllScoreResult.jsp").forward(request,response);
					
			}
					}
		else if(coursetype.equals("选修课"))
		{
			OptionalScoreDAO scoredao=new OptionalScoreDAO();
			boolean isexist=scoredao.checkStudent(student_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=addStudent.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
			{
				ArrayList scores=scoredao.getScoresByStudentId(student_id,term);
				HttpSession session=request.getSession(true);
				session.setAttribute("optionalscoresofonestudent",scores);
				this.getServletContext().getRequestDispatcher("/QueryOneStudentAllScoreResult.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 + -