studentsvlt.java

一个学生课绩管理系统

package control;

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

import database.student;

public class StudentSvlt extends HttpServlet {

	public void doGet(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {

		String stu_id = req.getParameter("id");
		int success = 0;
		String action = action = req.getParameter("action");
		student stu = null;
		String message = "";

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

			sendBean(req, res, stu, "/getStudent.jsp");
		}

		if ("update".equalsIgnoreCase(action)) {
			try {
				stu = doUpdate(req, res, stu_id);
				sendBean(req, res, stu, "/getStudent.jsp");
			} catch (SQLException e) {
			}
		}

		if ("delete".equalsIgnoreCase(action)) {
			try {
				success = doDelete(stu_id);
			} catch (SQLException e) {
			}
			if (success != 1) {
				doError(req, res,
						"StudentSvlt: Delete unsuccessful. Rows affected: "
								+ success);
			} else {
				res.sendRedirect("http://localhost:8080/test/getStudent.jsp");
			}

		}
	}

	public student doNew(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		student stu = new student();
		String stu_id = req.getParameter("id");
		String name = new String(req.getParameter("name").getBytes("ISO8859_1"));
		String password = req.getParameter("password");
		String dep = new String(req.getParameter("dep").getBytes("ISO8859_1"));
		String sex = new String(req.getParameter("sex").getBytes("ISO8859_1"));
		String jiguan = new String(req.getParameter("jiguan").getBytes(
				"ISO8859_1"));
		if (isTrue(req, res, stu_id, name, password)
				&& hasLogin(req, res, stu_id)) {

			stu.setId(stu_id);
			stu.setName(name);
			stu.setPassword(password);
			stu.setDep(dep);
			stu.setSex(sex);
			stu.setJiguan(jiguan);
			stu.addStudent();
		}
		return stu;

	}

	public student doUpdate(HttpServletRequest req, HttpServletResponse res,
			String id) throws ServletException, IOException, SQLException {
		student stu = new student();
		String name = new String(req.getParameter("name").getBytes("ISO8859_1"));

		String password = req.getParameter("password");
		String dep = new String(req.getParameter("dep").getBytes("ISO8859_1"));
		String sex = new String(req.getParameter("sex").getBytes("ISO8859_1"));
		String jiguan = new String(req.getParameter("jiguan").getBytes(
				"ISO8859_1"));
		if (isTrue(req, res, id, name, password)) {
			stu.setId(id);
			stu.setName(name);
			stu.setPassword(password);
			stu.setDep(dep);
			stu.setSex(sex);
			stu.setJiguan(jiguan);
			stu.updateStudent();
		}
		return stu;
	}

	public int doDelete(String id) throws SQLException {
		int num = 0;
		student stu = new student();
		num = stu.deleteStudent(id);
		return num;
	}

	public void sendBean(HttpServletRequest req, HttpServletResponse res,
			student stu, String target) throws ServletException, IOException {
		req.setAttribute("stu", stu);
		RequestDispatcher rd = getServletContext().getRequestDispatcher(target);
		rd.forward(req, res);
	}

	public void doError(HttpServletRequest req, HttpServletResponse res,
			String str) throws ServletException, IOException {

		req.setAttribute("problem", str);
		RequestDispatcher rd = getServletContext().getRequestDispatcher(
				"/errorpage.jsp");
		rd.forward(req, res);
	}

	public boolean hasLogin(HttpServletRequest req, HttpServletResponse res,
			String id) throws ServletException, IOException {
		boolean f = true;
		String message = "对不起，该学生号已经被注册过了!";
		student stu = new student();
		f = stu.hasLogin(id);
		if (f == false) {
			doError(req, res, message);
		}
		return f;
	}

	public boolean isTrue(HttpServletRequest req, HttpServletResponse res,
			String id, String name, String password) throws ServletException,
			IOException {
		boolean f = true;
		String message = "";
		if (id == null || id.equals("")) {
			f = false;
			message = "错误，学生号不能为空！";
			doError(req, res, message);
		}

		if (name == null || name.equals("")) {
			f = false;
			message = "学生姓名不能为空，请重新填写！";
			doError(req, res, message);
		}

		if (password == null || password.equals("")) {
			f = false;
			message = "密码不能为空，请重新填写！";
			doError(req, res, message);
		}
		return f;
	}

	public void doPost(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		doGet(req, res);
	}

}