closeassignmentaction.java

JAVA编写的远程教育程序,包含了教育学的基本思想和网络应用程序的基本开发模式

package com.whatratimes.webedu.teacher;

import org.apache.struts.action.*;

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

import com.whatratimes.dbms.UserSQLExecuter;

/**
 * User: Tao
 * Date: Jun 14, 2003
 * Time: 9:20:37 AM
 */
public class CloseAssignmentAction extends Action
{
    public ActionForward execute(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) throws Exception
    {
        HttpSession session = httpServletRequest.getSession();

        String ass_id = httpServletRequest.getParameter("AssignmentId");

        if ( ass_id == null )
        {
            return actionMapping.findForward("success");
        }

        Object[] objs = UserSQLExecuter.executeQuery(
                "select TOP 1 * from t_exam_submit where AssignmentId = " + ass_id
        );

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

        }

        SetExamHelper.clearAssignment(Integer.valueOf(ass_id));

        UserSQLExecuter sql = new UserSQLExecuter(
                "delete from t_exam_assigned where AssignmentId=" + ass_id
        );
        sql.executeUpdate();

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