assignexamupdateaction.java

采用Eclispe开发平台

package com.whatratimes.webedu.teacher;

import com.whatratimes.dbms.InsertSQLExecuter;
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.text.SimpleDateFormat;
import java.util.Date;
import java.util.Vector;

/**
 * User: Tao
 * Date: Jun 14, 2003
 * Time: 5:55:39 AM
 */
public class AssignExamUpdateAction extends Action
{
    public static SimpleDateFormat SDF = new SimpleDateFormat("yyyy-MM-dd HH:mm");

    public ActionForward execute(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) throws Exception
    {
        HttpSession session = httpServletRequest.getSession();
        DynaActionForm form = (DynaActionForm) actionForm;

        Integer assign_id = (Integer) form.get("AssignmentId");
        String sd = (String) form.get("StartTime");
        String ed = (String) form.get("EndTime");

        if ( sd.compareTo(ed) > 0)
        {
            String temp = ed;
            ed = sd;
            sd = temp;
        }

        Date start_time = SDF.parse(sd);
        Date end_time = SDF.parse(ed);

//        2003-06-12 06:11

        String tag = (String) form.get("Tag");
        int teacher_id = ((t_user) session.getAttribute("Teacher")).UserId;

        Integer exam_id = (Integer) form.get("ExamId");


        SetExamHelper.clearAssignment(assign_id);

        UserSQLExecuter usql = new UserSQLExecuter("delete from t_exam_assigned where AssignmentId = " + assign_id );
        usql.executeUpdate();

        InsertSQLExecuter sql = new InsertSQLExecuter();

        sql.appendTableName("t_exam_assigned");

        sql.appendValue("AssignmentId", assign_id);
        sql.appendValue("ExamId", exam_id);
        sql.appendValue("StartTime", start_time);
        sql.appendValue("EndTime", end_time);
        sql.appendValue("Tag", tag);
        sql.appendValue("TeacherId", new Integer(teacher_id));

        sql.executeUpdate();

        String ss = (String) form.get("Students");
        String ps = (String) form.get("Papers");

        int[] students = parseInts(ss);
        int[] papers = parseInts(ps);

        for (int i = 0; i < papers.length; i++)
        {
            usql = new UserSQLExecuter("insert into t_exam_assigned_paper " +
                    " (AssignmentId, PaperId ) " +
                    "values ( " + assign_id + ", " + papers[i] + ")");
            usql.executeUpdate();
        }

        for (int i = 0; i < students.length; i++)
        {

            usql = new UserSQLExecuter("insert into t_exam_assigned_student " +
                    " (AssignmentId, UserId ) " +
                    "values ( " + assign_id + ", " + students[i] + " )");
            usql.executeUpdate();
        }

        return actionMapping.findForward("success");
    }

    private int[] parseInts(String ints)
    {

        Vector v = new Vector();

        StringBuffer sb = new StringBuffer(ints);

        while (true)
        {
            int l = sb.length();
            int i = sb.indexOf(" ");

            if (i == -1) break;

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

        int[] rt = new int[v.size()];
        for (int i = 0; i < rt.length; i++)
        {
            rt[i] = Integer.valueOf((String) v.elementAt(i)).intValue();
        }

        return rt;
    }
}