showremark.java

博客管理系统。安装说明： 1、在SQLSERVER中创建blog数据库并创建登陆帐号blog：blog

package huc.blog.servlet;

import huc.blog.bean.Remark;
import huc.blog.op.RemarkOp;
import huc.blog.util.PageObject;
import huc.blog.util.ParamUtils;

import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;

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

public class ShowRemark extends HttpServlet {

    private static final long serialVersionUID = 1L;

    /**
     * The doGet method of the servlet. <br>
     *
     * This method is called when a form has its tag value method equals to get.
     * 
     * @param request the request send by the client to the server
     * @param response the response send by the server to the client
     * @throws ServletException if an error occurred
     * @throws IOException if an error occurred
     */
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    /**
     * The doPost method of the servlet. <br>
     *
     * This method is called when a form has its tag value method equals to post.
     * 
     * @param request the request send by the client to the server
     * @param response the response send by the server to the client
     * @throws ServletException if an error occurred
     * @throws IOException if an error occurred
     */
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String blogid = ParamUtils.getParameter(request, "blogid", "");
        String cmd = ParamUtils.getParameter(request, "cmd", "");
        int pageNo = ParamUtils.getParameter(request, "pageNo", 1);
        String remarkid = ParamUtils.getParameter(request, "remarkid", "");
        
        RemarkOp remarkOp = new RemarkOp();

        if(cmd.equals("add")){
            String nickName = ParamUtils.getParameter(request, "nickName", "匆匆过客");
            String content = ParamUtils.getParameter(request, "content", "");
            Remark remark = new Remark();
            remark.setBlogid(blogid);
            remark.setContent(content);
            remark.setNickName(nickName);
            SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            remark.setPublishTime(f.format(new Date()));
            
            remarkOp.add(remark);
        }
        else if(cmd.equals("del")){
            Remark remark = new Remark();
            remark.setId(remarkid);
            remarkOp.delete(remark);
        }
        
        PageObject page = new PageObject();
        page.setPageSize(5);
        page.setPageNo(pageNo);
        page = remarkOp.getPage(page, " and blogid = '" + blogid + "'", "  order by publishTime desc");
        
        request.setAttribute("blogid", blogid);
        request.setAttribute("page", page);
        request.getRequestDispatcher("../remarklist.jsp").forward(request, response);
    }

}