logonaction.java

采用Eclispe开发平台

package com.whatratimes.webedu.teacher;

import java.util.ArrayList;
import java.util.Collection;
import java.util.Hashtable;

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

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.DynaActionForm;
import org.apache.struts.util.LabelValueBean;

import com.whatratimes.dbms.QuerySQLExecuter;
import com.whatratimes.tables.t_school;
import com.whatratimes.tables.t_user;

public class LogonAction 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("Teacher");
      SetExamHelper.setTeacherClasses(user.UserId, session);
      SetExamHelper.setTeacherCourses(user.UserId, session);
      setSchoolList(user.SchoolId, session);

        return actionMapping.findForward("success");
    }
	
    public static void setSchoolList(String school_id, HttpSession session)
    {
        QuerySQLExecuter sql = new QuerySQLExecuter();

        sql.setReturnClassName("t_school");
        sql.appendTableName("t_school");
        sql.appendColumn("*");
        sql.appendWhereCondition("State" , "=", new Integer(1));

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

        if ( !"CNTR".equals(school_id) )
        {
            sql.appendWhereCondition("SchoolId", "=", school_id);
        } else if (  user.UserType != 5 && user.UserType != 4 )
        {
            sql.appendWhereCondition("SchoolId", "=", school_id);
        }

        Object[] objs = sql.executeQuery();

        ArrayList ss = new ArrayList();
        for (int i = 0; i < objs.length; i++)
        {
            t_school s = (t_school) objs[i];
            ss.add(new LabelValueBean(s.SchoolName, s.SchoolId));
        }
        session.setAttribute("SchoolList", ss);

        ArrayList sss = new ArrayList(ss);
        sss.add(0, new LabelValueBean("不限", "0"));
        session.setAttribute("SearchSchool", sss);

        ArrayList ssss = new ArrayList(ss);
        ssss.add(0, new LabelValueBean("请选择", "0"));
        session.setAttribute("SelectSchool", ssss);
    }
	
}