classesservlet.java

学生考勤管理系统————分为课程选择

package com.ccniit.kaoqin.servlet;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.ccniit.kaoqin.db.classes.Classes;
import com.ccniit.kaoqin.db.classes.ClassesDAO;

@SuppressWarnings("serial")
public class ClassesServlet extends HttpServlet {

	/**
	 * The doGet method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String functionStr = request.getPathInfo();
		ClassesDAO classesDAO = null;
		try {
			if (functionStr.equals("/List")) {
				String successPage = "/class/class.jsp";
				classesDAO = new ClassesDAO();
				ArrayList classes = classesDAO.getAllClasses();
				request.setAttribute("classes", classes);
				// 获取转发器
				request.getRequestDispatcher(successPage).forward(request,
						response);
			} else if (functionStr.equals("/OpenAddClass")) {
				String successPage = "/class/addClass.jsp";
				// 获取转发器
				request.getRequestDispatcher(successPage).forward(request,
						response);

			} else if (functionStr.equals("/AddClass")) {
				String successPage = "/Info/Classes/OpenAddClass";
				String class_num = request.getParameter("class_NO");
				String class_name = request.getParameter("class_name");
				String class_grade = request.getParameter("grade_name");

				Classes classe = new Classes();
				classe.setClass_NO(class_num);
				classe.setClass_name(class_name);
				classe.setClass_grade(class_grade);

				classesDAO = new ClassesDAO();
				classesDAO.addClassess(classe);
				request.setAttribute("message", "添加行政班成功！");
				request.getRequestDispatcher(successPage).forward(request,
						response);

			} else if (functionStr.equals("/OpenModifyClass")) {
				String successPage = "/class/modifyClass.jsp";
				String class_idStr = request.getParameter("class_id");
				int class_id = Integer.parseInt(class_idStr);
                System.out.println("班级id:"+class_idStr);
				

				classesDAO = new ClassesDAO();
				Classes clas = classesDAO.getClassById(class_id);
				
				System.out.println("班级年级："+clas.getClass_grade());
				request.setAttribute("grade_name", clas.getClass_grade());
				request.setAttribute("clas", clas);
				request.getRequestDispatcher(successPage).forward(request,
						response);
			} else if (functionStr.equals("/ModifyClass")) {
				String successPage = "OpenModifyClass";
				String class_idStr = request.getParameter("class_id");
				int class_id = Integer.parseInt(class_idStr);

				String class_NO = request.getParameter("class_NO");

				String class_name = request.getParameter("class_name");
				String grade_name = request.getParameter("grade_name");
				// System.out.println(grade_name);

				Classes clas = new Classes();
				clas.setClass_NO(class_NO);
				clas.setClass_name(class_name);
				clas.setClass_grade(grade_name);
				clas.setClass_id(class_id);

				classesDAO = new ClassesDAO();
				classesDAO.modifyClasses(clas);

				request.setAttribute("grade_name", grade_name);
				request.setAttribute("message", "修改行政班成功！");
				request.getRequestDispatcher(successPage).forward(request,
						response);

			} else if (functionStr.equals("/OpenClassDetail")) {
				String successPage = "/class/classDetail.jsp";
				String class_idStr = request.getParameter("class_id");
				int class_id = Integer.parseInt(class_idStr);
				classesDAO = new ClassesDAO();
				Classes clas = classesDAO.getClassesDetailById(class_id);
				request.setAttribute("clas", clas);
				// 获取转发器
				request.getRequestDispatcher(successPage).forward(request,
						response);
			} else if (functionStr.equals("/DeleteClassDeaile")) {
				String successPage = "/Info/Classes/List";
				if (request.getParameterValues("class_id") != null) {
					classesDAO = new ClassesDAO();
					String class_idStr = request.getParameter("class_id");
					int class_id = Integer.parseInt(class_idStr);
					classesDAO.deleteClasses(class_id);
				}
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}
		} catch (ClassNotFoundException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} finally {
			try {
				if (classesDAO != null) {
					classesDAO.release();
				}
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}

	}

	/**
	 * The doPost method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to
	 * post.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 设定字符为gb2312
		request.setCharacterEncoding("gb2312");
		this.doGet(request, response);

	}

}