announceupdateaction.java

采用Eclispe开发平台

package com.whatratimes.webedu.bbs;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import org.apache.struts.validator.DynaValidatorActionForm;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.util.Date;

import com.whatratimes.dbms.DBOperation;
import com.whatratimes.dbms.DBHelper;
import com.whatratimes.dbms.UpdateSQLExecuter;
import com.whatratimes.dbms.UserSQLExecuter;

/**
 * User: Tao
 * Date: Jul 20, 2003
 * Time: 3:27:16 PM
 */
public class AnnounceUpdateAction extends Action
{
    public ActionForward execute(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) throws Exception
    {

        HttpSession session = httpServletRequest.getSession();

        DynaValidatorActionForm form = (DynaValidatorActionForm) actionForm;

        form.set("AnnounceId", new Integer(DBHelper.getNextAnnounceId()));
        form.set("SentTime", new Date());

        DBOperation.CMD(actionForm, actionMapping, "AnnounceId");

        Object parent_id = form.get("ParentId");

        if (!parent_id.equals(new Integer(0)))
        {
            session.setAttribute("TopicId", parent_id.toString());

            UpdateSQLExecuter sql = new UpdateSQLExecuter();

            sql.appendTableName("t_bbs_announce");
            sql.appendSetValue("ReplyTime", new Date());
            sql.appendWhereCondition("AnnounceId", "=", parent_id);
            sql.executeUpdate();

            UserSQLExecuter.executeUpdate("update t_bbs_announce set ReplyCounter = ReplyCounter + 1 where AnnounceId=" + parent_id);

        } else
        {
            session.setAttribute("TopicId", form.get("AnnounceId").toString());
        }

        return actionMapping.findForward("success");
    }
}