servletteacher.java

在线教育平台： 从小学

package edu;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class Servletteacher extends javax.servlet.http.HttpServlet implements
		javax.servlet.Servlet {
	public void doGet(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		String sort = "";

		int success = 0;
		int id = 0;
		HttpSession session = req.getSession(true);
		try {
			sort = session.getAttribute("sort").toString();
		} catch (NullPointerException e) {
		}
		String action = null;
		action = req.getParameter("action");
		try {
			id = Integer.valueOf(req.getParameter("id")).intValue();
		} catch (NumberFormatException e) {
		}
		TeacherBean teachers = null;
		// String message = "";

		if ("new".equalsIgnoreCase(action)) {
			teachers = doNew(req, res);

			sendBean(req, res, teachers, "/ok.jsp");
		}
		if ("new_ad".equalsIgnoreCase(action)) {
			teachers = doNew_ad(req, res);

			sendBean(req, res, teachers, "/getteacher.jsp");
		}
		if ("backpsw".equalsIgnoreCase(action)) {
			try {
				teachers = doPsw(req, res);
				sendBean(req, res, teachers, "/ok.jsp");
			} catch (SQLException e) {
			}

		}
		if ("backpsw1".equalsIgnoreCase(action)) {
			try {
				teachers = doPsw1(req, res);

			} catch (SQLException e) {
			}

		}
		if ("backpsw2".equalsIgnoreCase(action)) {
			try {
				teachers = doPsw2(req, res);

			} catch (SQLException e) {
			}

		}
		if ("backpsw3".equalsIgnoreCase(action)) {
			try {
				teachers = doPsw3(req, res);

			} catch (SQLException e) {
			}

		}
		if (!sort.equals("")) {
			if ("update".equalsIgnoreCase(action)) {
				try {
					teachers = doUpdate(req, res, id);

					sendBean(req, res, teachers, "/ok.jsp");
				} catch (SQLException e) {
				}
			}
			if (sort.equals("admin")) {
				if ("update_ad".equalsIgnoreCase(action)) {
					try {
						teachers = doUpdate_ad(req, res, id);

						sendBean(req, res, teachers, "/getteacher.jsp");
					} catch (SQLException e) {
					}
				}
				if ("delete".equalsIgnoreCase(action)) {

					try {
						success = doDelete(id);
					} catch (SQLException e) {
					}

					if (success != 1) {
						doError_ad(req, res, "删除失败. Rows affected: " + success);
					} else {
						res.sendRedirect("getteacher.jsp");
					}

				}
				if ("check".equalsIgnoreCase(action)) {

					try {
						success = doCheck(id);
					} catch (SQLException e) {
					}

					if (success != 1) {
						doError_ad(req, res, "审核失败. Rows affected: " + success);
					} else {
						res.sendRedirect("getteacher.jsp");
					}
				}
				if ("uncheck".equalsIgnoreCase(action)) {

					try {
						success = dounCheck(id);
					} catch (SQLException e) {
					}

					if (success != 1) {
						doError_ad(req, res, "审核失败. Rows affected: " + success);
					} else {
						res.sendRedirect("getteacher.jsp");
					}
				}
			} else
				doError_ad(req, res, "你无权操作，或你还没有登陆！");
		} else
			doError(req, res, "你无权操作，或你还没有登陆！");
	}

	public int doCheck(int id) throws SQLException {

		TeacherBean teachers = new TeacherBean();
		int num = teachers.checkTeacher(id);
		return num;
	}

	public int dounCheck(int id) throws SQLException {

		TeacherBean teachers = new TeacherBean();
		int num = teachers.uncheckTeacher(id);
		return num;
	}

	public TeacherBean doNew(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		TeacherBean teachers = new TeacherBean();
		HttpSession session = req.getSession(true);
		Md5Bean md5 = new Md5Bean();
		String pswss = req.getParameter("pswss");
		String teacher = new String(req.getParameter("teacher").getBytes(
				"ISO8859_1"));
		String psw = req.getParameter("psw");
		String age = new String(req.getParameter("age").getBytes("ISO8859_1"));
		String sex = new String(req.getParameter("sex").getBytes("ISO8859_1"));
		String address = new String(req.getParameter("address").getBytes(
				"ISO8859_1"));
		String time = new String(req.getParameter("time").getBytes("ISO8859_1"));
		int class_id = Integer.parseInt(req.getParameter("class_id"));
		int grade_id = Integer.parseInt(req.getParameter("grade_id"));
		int subject_id = Integer.parseInt(req.getParameter("subject_id"));
		String idcard = new String(req.getParameter("idcard").getBytes(
				"ISO8859_1"));
		String mobile = new String(req.getParameter("mobile").getBytes(
				"ISO8859_1"));
		String email = new String(req.getParameter("email").getBytes(
				"ISO8859_1"));
		String ask = new String(req.getParameter("ask").getBytes("ISO8859_1"));
		String answer = new String(req.getParameter("answer").getBytes(
				"ISO8859_1"));

		if (isTrue(req, res, teacher) && isTrue(req, res, pswss, psw)
				&& hasLogin(req, res, teacher)) {

			psw = md5.getMD5ofStr(psw);
			teachers.setTeacher(teacher);
			teachers.setPsw(psw);
			teachers.setAge(age);
			teachers.setSex(sex);
			teachers.setAddress(address);
			teachers.setClass_id(class_id);
			teachers.setGrade_id(grade_id);
			teachers.setSubject_id(subject_id);
			teachers.setIdcard(idcard);
			teachers.setMobile(mobile);
			teachers.setEmail(email);
			teachers.setAsk(ask);
			teachers.setAnswer(answer);
			teachers.setTime(time);
			teachers.addTeachers();
			String sort = "";
			try {
				sort = session.getAttribute("sort").toString();
			} catch (NullPointerException e) {
			}

			if (sort.equals("")) {
				int t_id = 0;
				try {
					t_id = teachers.idfromname(teacher);
				} catch (SQLException e) {
				}
				session.setAttribute("userid", String.valueOf(t_id));
				session.setAttribute("name", String.valueOf(teacher));
				session.setAttribute("sort", "teacher");
			}
		}
		return teachers;

	}

	public TeacherBean doNew_ad(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		TeacherBean teachers = new TeacherBean();

		Md5Bean md5 = new Md5Bean();
		String pswss = req.getParameter("pswss");
		String teacher = new String(req.getParameter("teacher").getBytes(
				"ISO8859_1"));
		String psw = req.getParameter("psw");
		String age = new String(req.getParameter("age").getBytes("ISO8859_1"));
		String sex = new String(req.getParameter("sex").getBytes("ISO8859_1"));
		String address = new String(req.getParameter("address").getBytes(
				"ISO8859_1"));
		String time = new String(req.getParameter("time").getBytes("ISO8859_1"));
		int class_id = Integer.parseInt(req.getParameter("class_id"));
		int grade_id = Integer.parseInt(req.getParameter("grade_id"));
		int subject_id = Integer.parseInt(req.getParameter("subject_id"));
		String idcard = new String(req.getParameter("idcard").getBytes(
				"ISO8859_1"));
		String mobile = new String(req.getParameter("mobile").getBytes(
				"ISO8859_1"));
		String email = new String(req.getParameter("email").getBytes(
				"ISO8859_1"));
		String ask = new String(req.getParameter("ask").getBytes("ISO8859_1"));
		String answer = new String(req.getParameter("answer").getBytes(
				"ISO8859_1"));

		if (isTrue(req, res, teacher) && isTrue(req, res, pswss, psw)
				&& hasLogin(req, res, teacher)) {

			psw = md5.getMD5ofStr(psw);
			teachers.setTeacher(teacher);
			teachers.setPsw(psw);
			teachers.setAge(age);
			teachers.setSex(sex);
			teachers.setAddress(address);
			teachers.setClass_id(class_id);
			teachers.setGrade_id(grade_id);
			teachers.setSubject_id(subject_id);
			teachers.setIdcard(idcard);
			teachers.setMobile(mobile);
			teachers.setEmail(email);
			teachers.setAsk(ask);
			teachers.setAnswer(answer);
			teachers.setTime(time);
			teachers.addTeachers();

		}
		return teachers;

	}

	public TeacherBean doUpdate(HttpServletRequest req,
			HttpServletResponse res, int id) throws ServletException,
			IOException, SQLException {
		TeacherBean teachers = new TeacherBean();
		Md5Bean md5 = new Md5Bean();

		String pswss = req.getParameter("pswss");
		String psw = req.getParameter("psw");
		String age = new String(req.getParameter("age").getBytes("ISO8859_1"));
		String sex = new String(req.getParameter("sex").getBytes("ISO8859_1"));
		int class_id = Integer.parseInt(req.getParameter("class_id"));
		int grade_id = Integer.parseInt(req.getParameter("grade_id"));
		int subject_id = Integer.parseInt(req.getParameter("subject_id"));
		String idcard = new String(req.getParameter("idcard").getBytes(
				"ISO8859_1"));
		String mobile = new String(req.getParameter("mobile").getBytes(
				"ISO8859_1"));
		String address = new String(req.getParameter("address").getBytes(
				"ISO8859_1"));
		String email = new String(req.getParameter("email").getBytes(
				"ISO8859_1"));
		String ask = new String(req.getParameter("ask").getBytes("ISO8859_1"));
		String answer = new String(req.getParameter("answer").getBytes(
				"ISO8859_1"));
		String oanswer = new String(req.getParameter("oanswer").getBytes(
				"ISO8859_1"));
		if (isTrue(req, res, pswss, psw) && ask_answer(req, res, id, oanswer)) {
			psw = md5.getMD5ofStr(psw);
			teachers.setId(id);
			teachers.setPsw(psw);
			teachers.setClass_id(class_id);
			teachers.setGrade_id(grade_id);
			teachers.setSubject_id(subject_id);