adminmanagemessageservlet.java

简单的流言板系统,用myeclipse进行编写的,采用简单的jstl+javabean+servlet+jsp,属于三层架构.

package me.work.servlets;

import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import me.work.beans.MessageBean;
import me.work.services.DBOperation;

public class AdminManageMessageServlet extends HttpServlet {

	/**
	 * serialVersionUID
	 */
	private static final long serialVersionUID = 1L;

	/*
	 * (non-Javadoc)
	 * 
	 * @see javax.servlet.http.HttpServlet#doGet(javax.servlet.http.HttpServletRequest,
	 *      javax.servlet.http.HttpServletResponse)
	 */
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		doPost(req, resp);
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see javax.servlet.http.HttpServlet#doPost(javax.servlet.http.HttpServletRequest,
	 *      javax.servlet.http.HttpServletResponse)
	 */
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		String method = req.getParameter("method");
		String msgID = req.getParameter("id");
		int id;
		if (msgID != null && !"".equals(msgID.trim())) {
			try {
				id = Integer.valueOf(msgID).intValue();
			} catch (Exception e) {
				// TODO: handle exception
				id = 0;
			}
		} else {
			id = 0;
		}
		if ("delete".equals(method)) {
			// /********************************************
			// delete message
			// /********************************************
			DBOperation dbo = new DBOperation();
			try {
				if (dbo.deleteMsgByID(id)) {
					req.setAttribute("info", "delete successfully!");
					req.setAttribute("meth", "all");
					req.getRequestDispatcher("./pages/adminPage.jsp").forward(
							req, resp);
				}
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		} else if ("reply".equals(method)) {
			// /***************************************************
			// reply message
			// /*****************************************************
			DBOperation dbo = new DBOperation();
			try {
				List replyList;

				replyList = dbo.getReplyListOfSpecifiedMessage(id);

				MessageBean msg = dbo.getMessageByID(id);
				req.setAttribute("replyList", replyList);
				req.setAttribute("msg", msg);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			req.setAttribute("msgID", id);
			req.getRequestDispatcher("./pages/reply.jsp").forward(req, resp);
			//delete users
		} else if ("deleteu".equals(method.trim())) {
			// /*******************************************
			// delete user
			// /*******************************************
			DBOperation dbo = new DBOperation();
			try {
				if (dbo.deleteUser(id)) {
					req.setAttribute("info", "delete successfully!");
					req.getRequestDispatcher("./AdminServlet?method=user").forward(
							req, resp);
				}else{
					req.setAttribute("info", "delete failed!");
					req.getRequestDispatcher("./AdminServlet?method=user").forward(
							req, resp);
				}
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

		}
	}

}