firstaction.java

基于struts的course

package StudyCourse;

import javax.sql.DataSource;
import java.sql.Connection;
import javax.servlet.ServletContext;
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.ActionMessage;
import org.apache.struts.action.ActionMessages;
import java.util.Vector;
import org.apache.struts.action.DynaActionForm;

public final class FirstAction extends Action{  
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,  
		HttpServletResponse response) throws Exception {
	
   		DynaActionForm courseTypeIdForm = (DynaActionForm) form;         
		Integer courseTypeId = (Integer)courseTypeIdForm.get("courseTypeId");
		
   		ServletContext context = servlet.getServletContext();
		DataSource dataSource = (DataSource)context.getAttribute(Constants.DATASOURCE_KEY);
        DB db = new DB(dataSource);
        
		int iTypeId=0; 
		if (courseTypeId!=null){
			iTypeId= courseTypeId.intValue();
		}
		else{
			iTypeId = CourseType.GetFirstCourseType(db);
		}
		
        Vector courseList = new Vector();
        HttpSession session = request.getSession();
        
//		String PageForward;
//		ActionMessages errors = new ActionMessages();
        
		session.setAttribute(Constants.COURSE_TYPE_LIST_KEY,CourseType.SearchCourseType(db));
		
		courseList = Course.SearchCourse(db,iTypeId,"","");
		session.setAttribute(Constants.COURSE_LIST_KEY,courseList);
			
		db.close();
	   	return (mapping.findForward("toCourseMain"));					
 	}

}