selectcourseaction.java

为基于J2EE（Java2 Platform

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.0.1/xslt/JavaClass.xsl

package 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");

	}

}