teacherservlet.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.teacher.Teacher;
import com.ccniit.kaoqin.db.teacher.TeacherDAO;

@SuppressWarnings("serial")
public class TeacherServlet 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();
		TeacherDAO teacherDAO = null;
		try {
			if(functionStr.equals("/List")){
				
				String successPage ="/teacher/teacher.jsp";
				String pageStr=request.getParameter("pages");
				int pages=Integer.parseInt(pageStr);
				
				
				teacherDAO = new TeacherDAO();
				ArrayList teachers = teacherDAO.getFenyeTeacher(pages);
				
				request.setAttribute("intpage",pageStr );
				
				request.getSession().setAttribute("intpage", pageStr);
				request.setAttribute("teachers", teachers);
				// 获取转发器
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}else if(functionStr.equals("/OpenAddTeacher")){
				String successPage ="/teacher/addTeacher.jsp";
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}else if(functionStr.equals("/AddTeacher")){
				String successPage ="/Info/Teacher/OpenAddTeacher";
				String teacher_NO = request.getParameter("teacher_NO");
				String teacher_name = request.getParameter("teacher_name");
				String teacher_sex = request.getParameter("teacher_sex");
				String teacher_office = request.getParameter("teacher_office");
				String teacher_phone = request.getParameter("teacher_phone");
				String teacher_telPhone = request.getParameter("teacher_telPhone");
				String teacher_email = request.getParameter("teacher_email");
				
				Teacher teacher = new Teacher();
				teacher.setTeacher_NO(teacher_NO);
				teacher.setTeacher_name(teacher_name);
				teacher.setTeacher_sex(teacher_sex);
				teacher.setTeacher_office(teacher_office);
				teacher.setTeacher_phone(teacher_phone);
				teacher.setTeacher_telPhone(teacher_telPhone);
				teacher.setTeacher_email(teacher_email);
				teacher.setTeacher_password("123456");
				
				teacherDAO = new TeacherDAO();
				teacherDAO.addTeacher(teacher);
				
				request.setAttribute("message", "添加教师信息成功！");
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}else if(functionStr.equals("/OpenModifyTeacher")){
				String successPage ="/teacher/modifyTeacher.jsp";
				String teacher_idStr = request.getParameter("teacher_id");
				int teacher_id = Integer.parseInt(teacher_idStr);
				teacherDAO = new TeacherDAO();
				Teacher teacher =teacherDAO.getTeacherById(teacher_id);
				
				request.setAttribute("teacher", teacher);
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}else if(functionStr.equals("/ModifyTeacher")){
				String successPage ="/Info/Teacher/OpenModifyTeacher";
				String teacher_idStr = request.getParameter("teacher_id");
				int teacher_id = Integer.parseInt(teacher_idStr);
				String teacher_NO = request.getParameter("teacher_NO");
				String teacher_name = request.getParameter("teacher_name");
				String teacher_sex = request.getParameter("teacher_sex");
				String teacher_office = request.getParameter("teacher_office");
				String teacher_phone = request.getParameter("teacher_phone");
				String teacher_telPhone = request.getParameter("teacher_telPhone");
				String teacher_email = request.getParameter("teacher_email");
				String teacher_password = request.getParameter("teacher_password");
				
				Teacher teacher = new Teacher();
				teacher.setTeacher_NO(teacher_NO);
				teacher.setTeacher_name(teacher_name);
				teacher.setTeacher_sex(teacher_sex);
				teacher.setTeacher_office(teacher_office);
				teacher.setTeacher_phone(teacher_phone);
				teacher.setTeacher_telPhone(teacher_telPhone);
				teacher.setTeacher_email(teacher_email);
				teacher.setTeacher_password(teacher_password);
				teacher.setTeacher_id(teacher_id);
				
				teacherDAO = new TeacherDAO();
				teacherDAO.modifyTeacher(teacher);
				
				request.setAttribute("message", "修改教师信息成功！");
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}else if(functionStr.equals("/OpenTeacherDetail")){
				String successPage ="/teacher/teacherDetail.jsp";
				String teacher_idStr = request.getParameter("teacher_id");
				int teacher_id = Integer.parseInt(teacher_idStr);
				teacherDAO = new TeacherDAO();
				Teacher teacher = teacherDAO.getTeacherDetailById(teacher_id);
				
				request.setAttribute("teacher", teacher);
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}else if(functionStr.equals("/DeleteTeacher")){
				String successPage ="List?pages=1";
				if(request.getParameterValues("teacher_id")!=null){
					teacherDAO = new TeacherDAO();
					String teacher_idStr = request.getParameter("teacher_id");
					int teacher_id = Integer.parseInt(teacher_idStr);
					teacherDAO.deleteTeacher(teacher_id);
				}
				request.getRequestDispatcher(successPage).forward(request,
						response);
			}
		} catch (ClassNotFoundException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			try {
				if(teacherDAO!=null){
					teacherDAO.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);

	}

}