//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.UpdateStudentForm;public class UpdateStudentAction extends Action {	public ActionForward execute(		ActionMapping mapping,		ActionForm form,		HttpServletRequest request,		HttpServletResponse response) {		UpdateStudentForm updateStudentForm = (UpdateStudentForm) form;		// TODO Auto-generated method stub				String index = (String)request.getParameter("index");				if(index.equals("first")) {			ArrayList list = DBtool.getDataList("tb_profession",new String[]{"profession_id","profession_name"});			request.setAttribute("profession",list);						String student_id = (String)request.getParameter("id");						ArrayList list1 = DBtool.getDataList("tb_student",new String[]{"student_name","profession_id","student_sex"},"student_id='"+student_id+"'");			request.setAttribute("student_name",((HashMap)list1.get(0)).get("student_name").toString());			request.setAttribute("profession_id",((HashMap)list1.get(0)).get("profession_id").toString());			request.setAttribute("student_sex",((HashMap)list1.get(0)).get("student_sex").toString());			request.setAttribute("student_id",student_id);			return mapping.findForward("first");					}		if(index.equals("update")) {			String student_id = (String)request.getParameter("id");			String student_name = updateStudentForm.getStudent_name();			String student_sex = updateStudentForm.getStudent_sex();			String profession_id = updateStudentForm.getProfession_id();						String sql = "update tb_student set student_name='"+student_name+"',student_sex='"+student_sex+"',profession_id='"+profession_id+"' where student_id='"+student_id+"'";			DBtool.updateData(sql);			return mapping.findForward("success");		}		return null;	}}