courseservlet.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.ClassesDAO;
import com.ccniit.kaoqin.db.course.Course;
import com.ccniit.kaoqin.db.course.CourseDAO;
import com.ccniit.kaoqin.db.selectCourse.SelectCourseDAO;
import com.ccniit.kaoqin.db.teachCourse.TeachCourseDAO;
import com.ccniit.kaoqin.db.teacher.TeacherDAO;

@SuppressWarnings("serial")
public class CourseServlet 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
	 */
	@SuppressWarnings("unchecked")
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String functionStr = request.getPathInfo();
		CourseDAO courseDAO = null;
		ClassesDAO classesDAO=null;
		 TeachCourseDAO teachCourseDAO=null;
		 SelectCourseDAO selectCourseDAO=null;
		
		try {
			if (functionStr.equals("/List")) {
				String successPage = "/course/course.jsp";
				courseDAO = new CourseDAO();
				ArrayList<Course> courses =courseDAO.getAllCourse();
				request.setAttribute("courses", courses);
				// 获取转发器
				request.getRequestDispatcher(successPage).forward(request,
						response);
			} else if (functionStr.equals("/OpenAddCourse")) {
				
				String successPage = "/course/addCourse.jsp";
				// 获取转发器
				request.getRequestDispatcher(successPage).forward(request,
						response);
			} else if (functionStr.equals("/AddCourse")) {
				String successPage = "/Info/Course/OpenAddCourse";
				String course_num = request.getParameter("course_NO");
				String course_name = request.getParameter("course_name");
				
				 courseDAO = new CourseDAO();
				
				 Course course1=courseDAO.getCourseByNo(course_num);
				 
			       if(course1==null){
			    	   Course course = new Course();
						course.setCourse_NO(course_num);
						course.setCourse_name(course_name);
					courseDAO.addCourse(course);
					request.setAttribute("message", "添加课程成功！"); 
					
				 }else {
					
					 request.setAttribute("message", "课程编号重复！"); 
					 
				 }
			       request.getRequestDispatcher(successPage).forward(request,
							response);
				
				
				
				

			}
				
			
             else if (functionStr.equals("/OpenModifyCourse")) {
				String successPage = "/course/modifyCourse.jsp";
				String course_idStr = request.getParameter("course_id");
				int course_id = Integer.parseInt(course_idStr);
				courseDAO = new CourseDAO();
				Course course = courseDAO.getCourseById(course_id);
				request.setAttribute("course", course);
				request.getRequestDispatcher(successPage).forward(request,
						response);
			} else if (functionStr.equals("/ModifyCourse")) {
				String successPage = "/Info/Course/OpenModifyCourse";
				String course_idStr = request.getParameter("course_id");
				int courses_id = Integer.parseInt(course_idStr);
				String course_NO = request.getParameter("course_NO");
				String course_name = request.getParameter("course_name");

				Course course = new Course();
				course.setCourse_NO(course_NO);
				course.setCourse_name(course_name);
				course.setCourse_id(courses_id);

				courseDAO = new CourseDAO();
				courseDAO.modifyCourse(course);

				request.setAttribute("message", "修改课程成功！");
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}else if(functionStr.equals("/OpenTeacher")){
				String successPage ="/course/appointTeacher.jsp";
				
				 String course_idStr=request.getParameter("course_id");
				 int course_id=Integer.parseInt(course_idStr);
				 
				 Course course=new Course();
				 courseDAO=new CourseDAO();
				 course=courseDAO.getCourseById(course_id);
				 request.setAttribute("course", course);
				request.getRequestDispatcher(successPage).forward(request,
						response);
				
			}
			else if(functionStr.equals("/OpenAppointTeacher")){
				
//				------------------------没做
				String successPage ="OpenTeacher";
				 String course_idStr=request.getParameter("course_id");
				 int course_id=Integer.parseInt(course_idStr);
				 
				 String teacherCourse_year=request.getParameter("teacherCourse_year");
				 String teacherCourse_termStr=request.getParameter("teacherCourse_term");
				 int teacherCourse_term=Integer.parseInt(teacherCourse_termStr);
				 
				 Course course=new Course();
				  courseDAO=new CourseDAO();
				 course=courseDAO.getCourseById(course_id);
				 
				  TeacherDAO teacherDAO=new TeacherDAO();
				   ArrayList teachers=teacherDAO.getAllTeacher();
				   
				   
				   teachCourseDAO=new TeachCourseDAO();
				  ArrayList teachCourses=teachCourseDAO.getTeachCourseByCourseId(teacherCourse_term,course_id,teacherCourse_year);
				   request.setAttribute("teacherCourse_year", teacherCourse_year);
				   request.setAttribute("teacherCourse_term", teacherCourse_termStr);
				   
				  request.setAttribute("teachCourses", teachCourses);
				   request.setAttribute("course", course);
				   request.setAttribute("teachers", teachers);
			
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}else if(functionStr.equals("/AppointTeacher")){
				
				
				
				      String successPage="OpenAppointTeacher";
				      teachCourseDAO=new TeachCourseDAO();
				String teacherCourse_year=request.getParameter("teacherCourse_year");
				String teacherCourse_termStr=request.getParameter("teacherCourse_term");
			      int 	teacherCourse_term=Integer.parseInt(teacherCourse_termStr);
			      String course_idStr=request.getParameter("course_id");
			      int course_id=Integer.parseInt(course_idStr);
			      
			      
			      
			      if(request.getParameterValues("teacher_id")!=null){
			      String[] teacher_idStr=request.getParameterValues("teacher_id");
			
				
				  int[] teacher_id=new int[teacher_idStr.length];
				   for(int i=0;i<teacher_id.length;i++){
					   teacher_id[i]=Integer.parseInt(teacher_idStr[i]);
				   }
				   teachCourseDAO.addTeachCours(course_id, teacherCourse_year, teacherCourse_term, teacher_id);
				
				
			      } else{
			    	  
			    	  int[] teacher_id=new int[0];  
			    	  
			    	  teachCourseDAO.addTeachCours(course_id, teacherCourse_year, teacherCourse_term, teacher_id);
			      }
			      
			      
			      
			      request.setAttribute("message", "指定成功");
				request.getRequestDispatcher(successPage).forward(request, response);
//				------------------------没做
				
			}
			else if(functionStr.equals("/OpenClass")){
				String successPage ="/course/appointClass.jsp";
				 String course_idStr=request.getParameter("course_id");
				 int course_id=Integer.parseInt(course_idStr);
				 
				 Course course=new Course();
				 courseDAO=new CourseDAO();
				 course=courseDAO.getCourseById(course_id);
				 request.setAttribute("course", course);
				
				
				
				request.getRequestDispatcher(successPage).forward(request, response);
				
				
			}
			
			
			else if(functionStr.equals("/OpenAppointClass")){
				

				String successPage ="/course/appointClass.jsp";
				
				 String course_idStr=request.getParameter("course_id");
				 int course_id=Integer.parseInt(course_idStr);
				 
				 String selectCourse_year=request.getParameter("selectCourse_year");
				String selectCourse_termStr=request.getParameter("selectCourse_term");
				    int 	selectCourse_term=Integer.parseInt(selectCourse_termStr);
				    
				 
				 
				 
                
				 Course course=new Course();
				  courseDAO=new CourseDAO();
				 course=courseDAO.getCourseById(course_id);
				 
				classesDAO=new ClassesDAO();
				 
				ArrayList classess=classesDAO.getAllClasses();
				 selectCourseDAO=new SelectCourseDAO();
				  ArrayList selectCourses=selectCourseDAO.getSelectCourseByCourseId(selectCourse_year, selectCourse_term, course_id);
				  
				  
				request.setAttribute("selectCourse_year", selectCourse_year);
				request.setAttribute("selectCourse_term", selectCourse_termStr); 
				request.setAttribute("selectCourses", selectCourses);
				request.setAttribute("classess", classess);
				request.setAttribute("course", course);
				
				request.getRequestDispatcher(successPage).forward(request, response);
	
				
			}else if(functionStr.equals("/AppointClass")){
				
				
				
				 String successPage="OpenAppointClass";
				 String course_idStr=request.getParameter("course_id");
				 int course_id=Integer.parseInt(course_idStr);
				
				String selectCourse_year=request.getParameter("selectCourse_year");
				String selectCourse_termStr=request.getParameter("selectCourse_term");
				    int selectCourse_term=Integer.parseInt(selectCourse_termStr);
				    
				    if(request.getParameterValues("class_id")!=null){
				    	
				    String[] class_idStr=request.getParameterValues("class_id");
					
					
					  int[] class_id=new int[class_idStr.length];
					   for(int i=0;i<class_id.length;i++){
						   class_id[i]=Integer.parseInt(class_idStr[i]);
					   }
					
					   selectCourseDAO=new SelectCourseDAO();
					   
					   selectCourseDAO.addSelectCourse(class_id, course_id, selectCourse_year, selectCourse_term);
				    }
				    else{
				    	
				    	
						
						  int[] class_id=new int[0];
						
						   selectCourseDAO=new SelectCourseDAO();
						   
						   selectCourseDAO.addSelectCourse(class_id, course_id, selectCourse_year, selectCourse_term);
				    }
				    
				    
				    
				         request.setAttribute("message", "指定成功");
		                request.getRequestDispatcher(successPage).forward(request, response);
				
				
//				------------------------没做
				
			}else if(functionStr.equals("/OpenCourseDetail")){
				
				String successPage ="/course/courseDetail.jsp";
				
				if(request.getParameterValues("course_id")!=null){
					 String course_idStr=request.getParameter("course_id");
					 int course_id=Integer.parseInt(course_idStr);
					 
					 Course course=new Course();
					  courseDAO=new CourseDAO();
					 course=courseDAO.getCourseDetailById(course_id);
				     
					 classesDAO=new ClassesDAO();
					 ArrayList classess=classesDAO.getClassesByCourseId(course_id);
					  
					 
					 request.setAttribute("classess", classess);
					 request.setAttribute("course", course);	
				}
				 request.getRequestDispatcher(successPage).forward(request, response);
				 
				}else if(functionStr.equals("/DeleteCourseDetail")){
				String successPage ="/Info/Course/List";
				if(request.getParameterValues("course_id")!=null){
					courseDAO = new CourseDAO();
					String course_idStr = request.getParameter("course_id");
					int course_id = Integer.parseInt(course_idStr);
					courseDAO.deleteCourse(course_id);
				}
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}else if(functionStr.equals("/OpenSudentInfo")){
				String successPage = "/course/openStudentInfo.jsp";
				String class_idStr = request.getParameter("class_id");
				int class_id = Integer.parseInt(class_idStr);
				classesDAO = new ClassesDAO();
				com.ccniit.kaoqin.db.classes.Classes clas=classesDAO.getClassesDetailById(class_id);
				request.setAttribute("clas", clas);
				// 获取转发器
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}else if(functionStr.equals("/Checkcourse")){
				response.setContentType("text/xml");
				response.setHeader("Cache-Control","no-cache");
				String username=(String)request.getParameter("course_NO");
				String xml="<?xml version=\"1.0\" encoding=\"gb2312\"?>";
				
				 
				 	courseDAO = new CourseDAO();
				 Course course1= courseDAO.getCourseByNo(username);
	           
				 
				if(username.equals("")||username==null)
				{
					xml+="<message><info>不能为空</info></message>";
				}
				
				else if(course1==null)
				{
					xml+="<message><info>可以使用</info></message>";
				}else if(course1.getCourse_NO().equals(username))
				{
					xml+="<message><info>课程编号重复</info></message>";
				}
	           
				
				response.setCharacterEncoding("gb2312");
				response.getWriter().write(xml);
				
				
				
				
				
				
				
				
			}
		} catch (ClassNotFoundException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} finally {
			try {
				if (courseDAO != null) 
					courseDAO.release();
				if(classesDAO!=null)
					classesDAO.release();
				if(teachCourseDAO!=null)
					teachCourseDAO.release();
				if(selectCourseDAO!=null)
					selectCourseDAO.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);
	}

}