submitpaperaction.java

采用Eclispe开发平台

package com.whatratimes.webedu.gradepaper;

import org.apache.struts.action.*;

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

import com.whatratimes.dbms.UpdateSQLExecuter;

/**
 * User: Tao
 * Date: Jun 21, 2003
 * Time: 6:19:13 PM
 */
public class SubmitPaperAction  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");
        String out = httpServletRequest.getParameter("Out");
        String grading = httpServletRequest.getParameter("Grading");

        UpdateSQLExecuter usql = new UpdateSQLExecuter();

        usql.appendTableName("t_exam_submit");

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

        usql.appendSetValue("Mark", Integer.valueOf(mark));
        if ( "1".equals(out))
        {
            usql.appendSetValue("State", new Integer(4));
        } else if ( "1".equals(grading))
        {
            usql.appendSetValue("State", new Integer(3));
        }

        usql.executeUpdate();

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