manage2servlet.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 org.displaytag.tags.TableTagParameters;
import org.displaytag.util.ParamEncoder;

import webbook.chapter18.*;
import webbook.util.OracleUtil;

public class Manage2Servlet 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 {
		String pageNumberName = (new ParamEncoder("gb").encodeParameterName(TableTagParameters.PARAMETER_PAGE));
		String pageNumber = request.getParameter(pageNumberName);
		if (pageNumber == null) {
			pageNumber = "1";
		}
		int pageNumber2 = 1;
		try {
			pageNumber2 = Integer.parseInt(pageNumber);
		} catch (java.lang.NumberFormatException e) {			
		}

		Pagination pager = new OraclePagination("select id,name,title from guestbook order by id desc", 3, pageNumber2);
		request.setAttribute("guestbook.pagesize", pager.getPageSize());
		request.setAttribute("guestbook.maxElements", pager.getMaxElements());
		request.setAttribute("guestbook.admin.list", pager.getList());		
		request.getRequestDispatcher("/admin/secure/list2.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);
	}
}