package StudyCourse;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
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 javax.servlet.ServletContext;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;

import java.util.*;
import javax.servlet.http.*;
import org.apache.struts.action.DynaActionForm;

public final class SearchAction extends Action{  
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,  
		HttpServletResponse response) throws Exception {
			
   		DynaActionForm courseSearchForm = (DynaActionForm) form;         
		String keyword = (String)courseSearchForm.get("keyword");
		String cat = (String)courseSearchForm.get("cat");
		
        HttpSession session = request.getSession();
		Vector courseList = new Vector();
		
   		ServletContext context = servlet.getServletContext();
		DataSource dataSource = 
			(DataSource)context.getAttribute(Constants.DATASOURCE_KEY);
						
        DB db = new DB(dataSource);
        
		courseList = Course.SearchCourse(db,0,cat,keyword);
		
		session.setAttribute(Constants.COURSE_LIST_KEY,courseList);
		session.setAttribute(Constants.COURSE_TYPE_LIST_KEY,CourseType.SearchCourseType(db));
   		
		db.close();

	   	return (mapping.findForward("toCourseMain"));					
 	}	
}