submitchoicespaperaction.java

采用Eclispe开发平台

package com.whatratimes.webedu.student;

import com.whatratimes.dbms.UpdateSQLExecuter;
import com.whatratimes.dbms.UserSQLExecuter;
import com.whatratimes.tables.t_user;
import org.apache.struts.action.*;

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

/**
 * User: Tao
 * Date: Jun 15, 2003
 * Time: 10:45:42 AM
 */
public class SubmitChoicesPaperAction extends Action
{
    public ActionForward execute(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) throws Exception
    {
        HttpSession session = httpServletRequest.getSession();
        t_user user = (t_user) session.getAttribute("User");

        DynaActionForm form = (DynaActionForm) actionForm;

        Integer[] answers = parseAnswer(form.get("Answer").toString());

        session.setAttribute("SubmittedAnswers", answers);

        Integer submit_id = (Integer) form.get("SubmitId");
        session.setAttribute("SubmitId", submit_id);

        Object[] temp = UserSQLExecuter.executeQuery(
                "SELECT  " +
                    "SubmitId " +
                "FROM " +
                    "t_exam_submit " +
                "WHERE " +
                    "SubmitId = " + submit_id + " AND " +
                    "State > 1 "
        );

        if (temp.length > 0)
        {
            return actionMapping.findForward("failed");
        }

        int total_mark = StudyHelper.mark(submit_id, user, answers, session);

        session.setAttribute("TotalMark", new Integer(total_mark));

        Date submit_time = new Date();

        UpdateSQLExecuter usql = new UpdateSQLExecuter();
        usql.appendTableName("t_exam_submit");
        usql.appendSetValue("SubmitTime", submit_time);
        usql.appendSetValue("Mark", new Integer(total_mark));
        usql.appendSetValue("State", new Integer(5));

        usql.appendWhereCondition("SubmitId", "=", submit_id);

        usql.executeUpdate();

        StudyHelper.setSubmitExam(submit_id, session);

        return actionMapping.findForward("success");
    }

    private Integer[] parseAnswer(String answer)
    {
        StringBuffer sb = new StringBuffer(answer);


        ArrayList v = new ArrayList();

        while (true)
        {
            if (sb.length() < 2)
            {
                break;
            }

            int i = sb.indexOf(" ");
            if (i == -1)
            {
                break;
            }

            v.add(Integer.valueOf(sb.substring(0, i)));

            sb.delete(0, i + 1);
        }

        return (Integer[]) v.toArray(new Integer[v.size()]);

    }
}