servletuser.java

在线教育平台： 从小学

package edu;

import java.io.IOException;
import java.sql.*;

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 Servletuser extends javax.servlet.http.HttpServlet implements
		javax.servlet.Servlet {
	public void doGet(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		int id = 0;
		String sort = "";
		int f = 0;
		HttpSession session = req.getSession(true);
		try {
			sort = session.getAttribute("sort").toString();
		} catch (NullPointerException e) {
		}
		int success = 0;
		String action = null;
		action = req.getParameter("action");
		try {
			id = Integer.valueOf(req.getParameter("id")).intValue();
		} catch (NumberFormatException e) {
		}
		UserBean user = null;
		// String message = "";

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

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

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

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

			} catch (SQLException e) {
			}

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

			} catch (SQLException e) {
			}

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

			} catch (SQLException e) {
			}

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

					sendBean(req, res, user, "/ok.jsp");
				} catch (SQLException e) {
				}
			}
			if (sort.equals("admin")) {
				if ("forbid".equalsIgnoreCase(action)) {

					try {
						f = doforbid(id);
					} catch (SQLException e) {
					}

					if (f == 1)
						res.sendRedirect("getuser.jsp");

					else
						doError_ad(req, res, "禁止失败. Rows affected: " + f);

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

					try {
						f = dounforbid(id);
					} catch (SQLException e) {
					}
					if (f == 1)
						res.sendRedirect("getuser.jsp");
					else
						doError_ad(req, res, "取消禁止失败. Rows affected: " + f);

				}
				if ("update_ad".equalsIgnoreCase(action)) {
					try {
						user = doUpdate_ad(req, res, id);

						sendBean(req, res, user, "/getuser.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("getuser.jsp");

				}
			} else
				doError_ad(req, res, "你无权操作，或你还没有登陆！");
		} else
			doError(req, res, "你无权操作，或你还没有登陆！");

	}

	public int doforbid(int id) throws SQLException {
		UserBean user = new UserBean();

		int num = user.forbid(id);
		return num;
	}

	public int dounforbid(int id) throws SQLException {
		UserBean user = new UserBean();

		int num = user.unforbid(id);
		return num;
	}

	public UserBean doNew(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		UserBean user = new UserBean();
		Md5Bean md5 = new Md5Bean();
		HttpSession session = req.getSession(true);
		String pswss = req.getParameter("pswss");
		String name = new String(req.getParameter("name").getBytes("ISO8859_1"));
		String time = new String(req.getParameter("time").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 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, pswss, psw) && hasLogin(req, res, name)) {
			psw = md5.getMD5ofStr(psw);
			user.setTime(time);
			user.setName(name);
			user.setPsw(psw);
			user.setAge(age);
			user.setSex(sex);
			user.setAddress(address);
			user.setEmail(email);
			user.setAsk(ask);
			user.setAnswer(answer);
			user.addUser();
			String sort = "";
			try {
				sort = session.getAttribute("sort").toString();
			} catch (NullPointerException e) {
			}
			if (sort.equals("")) {
				int u_id = 0;
				try {
					u_id = user.idfromname(name);
				} catch (SQLException e) {
				}
				session.setAttribute("userid", String.valueOf(u_id));
				session.setAttribute("name", String.valueOf(name));
				session.setAttribute("sort", "user");
			}
		}
		return user;

	}

	public UserBean doNew_ad(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		UserBean user = new UserBean();
		Md5Bean md5 = new Md5Bean();

		String pswss = req.getParameter("pswss");
		String name = new String(req.getParameter("name").getBytes("ISO8859_1"));
		String time = new String(req.getParameter("time").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 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, pswss, psw) && hasLogin(req, res, name)) {
			psw = md5.getMD5ofStr(psw);
			user.setTime(time);
			user.setName(name);
			user.setPsw(psw);
			user.setAge(age);
			user.setSex(sex);
			user.setAddress(address);
			user.setEmail(email);
			user.setAsk(ask);
			user.setAnswer(answer);
			user.addUser();

		}
		return user;

	}

	public UserBean doUpdate(HttpServletRequest req, HttpServletResponse res,
			int id) throws ServletException, IOException, SQLException {
		UserBean user = new UserBean();
		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"));
		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);
			user.setId(id);
			user.setPsw(psw);

			user.setAge(age);
			user.setSex(sex);
			user.setAddress(address);
			user.setEmail(email);
			user.setAsk(ask);
			user.setAnswer(answer);
			if (ask == null || ask.equals("") || answer == null
					|| answer.equals(""))