handoutaction.java

采用Eclispe开发平台

package com.whatratimes.webedu.gradepaper;

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 javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.whatratimes.dbms.UpdateSQLExecuter;

/**
 * User: Tao
 * Date: May 29, 2003
 * Time: 8:57:04 AM
 *
 * 下发已阅试卷
 */
public class HandOutAction  extends Action
{
    public ActionForward execute(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) throws Exception
    {
        String sid = httpServletRequest.getParameter("SubmitId");
        String mark = httpServletRequest.getParameter("Mark");

        UpdateSQLExecuter usql = new UpdateSQLExecuter();

        usql.appendTableName("t_exam_submit");

        usql.appendWhereCondition("SubmitId", "=", Integer.valueOf(sid));

        usql.appendSetValue("Mark", Integer.valueOf(mark));
        usql.appendSetValue("State", new Integer(5));

        usql.executeUpdate();

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