studytableaction.java

采用Eclispe开发平台

package com.whatratimes.webedu.student;

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 javax.servlet.http.HttpSession;
import java.util.Hashtable;

import com.whatratimes.tables.t_user;
import com.whatratimes.dbms.UserSQLExecuter;

/**
 * User: Tao
 * Date: Jun 14, 2003
 * Time: 9:06:16 PM
 */
public class StudyTableAction extends Action
{
    public ActionForward execute(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) throws Exception
    {
        HttpSession session = httpServletRequest.getSession();
        String c = httpServletRequest.getParameter("CourseId");

        t_user user = (t_user) session.getAttribute("User");

        if ( user.UserType != 1 )
        {
            UserSQLExecuter usql = new UserSQLExecuter("select * from t_course where CourseId = " + c );
            Object[] objs = usql.executeQuery();

            session.setAttribute("ExamTable", new Hashtable[0]);
            session.setAttribute("InstanceTable", new Hashtable[0]);
            session.setAttribute("Course", objs[0]);

            return actionMapping.findForward("success");
        }


        if (c != null)
        {
            Hashtable[] courses = (Hashtable[]) session.getAttribute("Courses");
            for (int i = 0; i < courses.length; i++)
            {
                if (courses[i].get("CourseId").toString().equals(c))
                {
                    session.setAttribute("Course", courses[i]);
                    break;
                }
            }
        } else
        {
            c = ((Hashtable) session.getAttribute("Course")).get("CourseId").toString();
        }

        StudyHelper.setExamTable(user, (Integer.valueOf(c)).intValue(), session);
        StudyHelper.setInstanceTable(user, (Integer.valueOf(c)).intValue(), session);

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