//Created by MyEclipse Struts// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.0.1/xslt/JavaClass.xslpackage com.huang.actions;import java.util.ArrayList;import java.util.HashMap;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.forms.UpdateCourseForm;public class UpdateCourseAction extends Action {	public ActionForward execute(		ActionMapping mapping,		ActionForm form,		HttpServletRequest request,		HttpServletResponse response) {		UpdateCourseForm updateCourseForm = (UpdateCourseForm) form;		// TODO Auto-generated method stub				String index = (String)request.getParameter("index");				if(index.equals("first")) {						String course_id = (String)request.getParameter("id");						ArrayList list = DBtool.getDataList("tb_course",new String[]{"course_name","course_credit","teacher_id"},"course_id='"+course_id+"'");			String course_name = ((HashMap)list.get(0)).get("course_name").toString();			String course_credit = ((HashMap)list.get(0)).get("course_credit").toString();			String teacher_id = ((HashMap)list.get(0)).get("teacher_id").toString();						request.setAttribute("course_name",course_name);			request.setAttribute("course_id",course_id);			request.setAttribute("course_credit",course_credit);			request.setAttribute("teacher_id",teacher_id);						ArrayList list2 = DBtool.getDataList("tb_teacher",new String[]{"teacher_id","teacher_name"});			request.setAttribute("teacher",list2);			return mapping.findForward("first");											}				if(index.equals("update")) {			String course_id = (String)request.getParameter("id");			String course_credit = updateCourseForm.getCourse_credit();			String course_name = updateCourseForm.getCourse_name();			String teacher_id = updateCourseForm.getTeacher_id();						String sql = "update tb_course set course_name = '"+course_name+"' , course_credit = '"+course_credit+"',teacher_id='"+teacher_id+"' where course_id = '"+course_id+"'";						DBtool.updateData(sql);			return mapping.findForward("success");		}		return null;	}}