//Created by MyEclipse Struts// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.0.1/xslt/JavaClass.xslpackage com.huang.student.actions;import java.util.ArrayList;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 com.huang.common.DB.DBtool;import com.huang.student.forms.SelectCourseForm;public class SelectCourseAction extends Action {	public ActionForward execute(		ActionMapping mapping,		ActionForm form,		HttpServletRequest request,		HttpServletResponse response) {		SelectCourseForm selectCourseForm = (SelectCourseForm) form;		// TODO Auto-generated method stub				String index = (String)request.getParameter("index");		if(index.equals("find")) {			String method = (String)request.getParameter("method");			String text = (String)request.getParameter("text");			ArrayList list = null;						if(method.equals("all")) {				list = DBtool.getDataList("v_course",new String[]{"course_id","course_name","course_credit","teacher_name"});							}else if(method.equals("course")) {				list = DBtool.getDataList("v_course",new String[]{"course_id","course_name","course_credit","teacher_name"},"course_name='"+text+"'");							}else if(method.equals("credit")) {				list = DBtool.getDataList("v_course",new String[]{"course_id","course_name","course_credit","teacher_name"},"course_credit='"+text+"'");							}else if(method.equals("teacher")) {				list = DBtool.getDataList("v_course",new String[]{"course_id","course_name","course_credit","teacher_name"},"teacher_name='"+text+"'");							}			if(list != null) {				request.setAttribute("course",list);				return mapping.findForward("success");			}					}				if(index.equals("select")) {			String course_id = (String)request.getParameter("id");			String student_id = request.getSession().getAttribute("student").toString();						String sql = "insert into tb_sc values('"+student_id+"','"+course_id+"')";			DBtool.updateData(sql);			return mapping.findForward("selectsuccess");		}												ArrayList list = new ArrayList();		request.setAttribute("course",list);		return mapping.findForward("success");	}}