fdmodifyservlet.java

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

package com.ccniit.kaoqin.servlet;

import java.io.IOException;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;

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.ClassesDAO;
import com.ccniit.kaoqin.db.course.CourseDAO;
import com.ccniit.kaoqin.db.dianmin.DianMin;
import com.ccniit.kaoqin.db.dianmin.DianMinDAO;
import com.ccniit.kaoqin.db.kaoqin.Kaoqin;
import com.ccniit.kaoqin.db.kaoqin.KaoqinDAO;
import com.ccniit.kaoqin.db.student.Student;
import com.ccniit.kaoqin.db.student.StudentDAO;
import com.ccniit.kaoqin.db.teacher.Teacher;

@SuppressWarnings("serial")
public class FDModifyServlet 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;
		CourseDAO courseDAO = null;
		DianMinDAO dianminDAO = null;
		KaoqinDAO kaoqinDAO = null;
		StudentDAO studentDAO = null;

		try {
			if (functionStr.equals("/OpenMain")) {
				String successPage = "/kaoqin/fdModify.jsp";

				classesDAO = new ClassesDAO();

				ArrayList classess = classesDAO.getAllClasses();

				request.setAttribute("classess", classess);

				request.getRequestDispatcher(successPage).forward(request,
						response);

			} else if (functionStr.equals("/SelectClass")) {

				String successPage = "OpenMain";

				String class_idStr = request.getParameter("class_id");
				int class_id = Integer.parseInt(class_idStr);

				courseDAO = new CourseDAO();
				ArrayList courses = courseDAO.getCourseByClassId(class_id);

				request.setAttribute("select", class_idStr);
				request.setAttribute("courses", courses);
				request.getRequestDispatcher(successPage).forward(request,
						response);

			}

			else if (functionStr.equals("/List")) {

				String successPage = "SelectClass";

				String course_idStr = request.getParameter("course_id");
				int course_id = Integer.parseInt(course_idStr);
				String class_idStr = request.getParameter("class_id");
				int class_id = Integer.parseInt(class_idStr);

				String kaoqin_timeStr = request.getParameter("kaoqin_time");
				int kaoqin_time = Integer.parseInt(kaoqin_timeStr);
				Teacher teacher = (Teacher) request.getSession().getAttribute(
						"teacher");

				DianMin dianmin = new DianMin();
				dianmin.setClass_id(class_id);
				dianmin.setCourse_id(course_id);
				dianmin.setKaoqin_time(kaoqin_time);
				dianmin.setTeacher_id(teacher.getTeacher_id());

				dianminDAO = new DianMinDAO();
				ArrayList dianmins = dianminDAO.getKaoQinPeople(dianmin);
				studentDAO = new StudentDAO();
				ArrayList students = studentDAO.getStudentByClassId(class_id);
				request.setAttribute("students", students);

				request.setAttribute("dianmins", dianmins);

				request.setAttribute("course_ids", course_idStr);
				request.setAttribute("kaoqin_times", kaoqin_timeStr);

				request.getRequestDispatcher(successPage).forward(request,
						response);

			} else if (functionStr.equals("/Save")) {

				String successPage = "List";

				Calendar rightNow = Calendar.getInstance();
				SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd");
				String kaoqin_date = fmt.format(rightNow.getTime());

				String course_idStr = request.getParameter("course_id");
				int course_id = Integer.parseInt(course_idStr);
				String class_idStr = request.getParameter("class_id");
				int class_id = Integer.parseInt(class_idStr);

				String kaoqin_timeStr = request.getParameter("kaoqin_time");
				int kaoqin_time = Integer.parseInt(kaoqin_timeStr);

				studentDAO = new StudentDAO();
				ArrayList students = studentDAO.getStudentByClassId(class_id);

				kaoqinDAO = new KaoqinDAO();

				Kaoqin kaoqin = new Kaoqin();
				for (int i = 0; i < students.size(); i++) {
					Student student = (Student) students.get(i);
					int student_id = student.getStudent_id();
					String kaoqin_data = request.getParameter("KaqQin_"
							+ student_id);
					kaoqin_data = new String(
							kaoqin_data.getBytes("ISO-8859-1"), "gb2312");

					kaoqin.setCourse_id(course_id);
					kaoqin.setKaoqin_time(kaoqin_time);
					kaoqin.setStudent_id(student_id);
					kaoqin.setKaoqin_date(kaoqin_date.trim());
					kaoqin.setKaoqin_data(kaoqin_data.trim());

					kaoqinDAO.addKaoqin(kaoqin);

				}

				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();
				if (courseDAO != null)
					courseDAO.release();
				if (kaoqinDAO != null)
					kaoqinDAO.release();
				if (studentDAO != null)
					studentDAO.release();
				if (dianminDAO != null)
					dianminDAO.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 {

		request.setCharacterEncoding("gb2312");
		this.doGet(request, response);
	}

}