manageservlet.java

一个简单的BBS系统 适用于初学者用JSP和连接池 开发系统

package webbook.guestbook;

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

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import webbook.util.OracleUtil;

public class ManageServlet extends HttpServlet {
	OracleUtil db = null;
	private static final long serialVersionUID = 204655027689309554L;

	public void edit(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String params[] = { request.getParameter("id") };		
		String sql = "select * from guestbook where id=?";
		List list = (List) db.query(sql, params, new BeanListHandler(Guestbook.class));
		request.setAttribute("guestbook.admin.edit", list.get(0));		
		request.getRequestDispatcher("/admin/secure/edit.jsp").forward(request, response);
	}

	public void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String params[] = { request.getParameter("name"), request.getParameter("email"), request.getParameter("phone"),
				request.getParameter("title"), request.getParameter("content"), request.getParameter("id") };		
		int i = db.update("update guestbook set name=?,email=?,phone=?,title=? ,content=? where id=?", params);
		if (i == 1) {
			request.setAttribute("guestbook.admin.update.message", "更新成功！");
			Guestbook gb = new Guestbook();
			gb.setId(Integer.parseInt(request.getParameter("id")));
			gb.setName(request.getParameter("name"));
			gb.setEmail(request.getParameter("email"));
			gb.setPhone(request.getParameter("phone"));
			gb.setTitle(request.getParameter("title"));
			gb.setContent(request.getParameter("content"));
			request.setAttribute("guestbook.admin.edit", gb);
		} else {
			request.setAttribute("guestbook.admin.update.message", "更新失败！");
		}		request.getRequestDispatcher("/admin/secure/updateResult.jsp").forward(request, response);
	}

	public void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String params[] = { request.getParameter("id") };
		int i = db.update("delete from guestbook where id=?", params);
		if (i == 1) {
			request.setAttribute("guestbook.admin.delete.message", "删除成功");
		} else {
			request.setAttribute("guestbook.admin.delete.message", "删除失败");
		}		request.getRequestDispatcher("/admin/secure/deleteResult.jsp").forward(request, response);
	}

	public void list(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		List list = (List) db.query("select id,name,title from guestbook order by id desc", null, new BeanListHandler(
				Guestbook.class));
		request.setAttribute("guestbook.admin.list", list);
		request.getRequestDispatcher("/admin/secure/list.jsp").forward(request, response);
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		db = new OracleUtil("java:/comp/env/jdbc/oracleds");
		db.init();
		String method = request.getParameter("q");
		if(method==null){
			method="list";
		}	
		if (method.equals("edit")) {
			edit(request, response);
		} else if (method.equals("delete")) {
			delete(request, response);
		} else if (method.equals("update")) {
			update(request, response);
		} else {
			list(request, response);
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}
}