//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 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.ProfessionInfoForm;public class ProfessionInfoAction extends Action {	public ActionForward execute(		ActionMapping mapping,		ActionForm form,		HttpServletRequest request,		HttpServletResponse response) {		ProfessionInfoForm professionInfoForm = (ProfessionInfoForm) form;				String index = (String)request.getParameter("index");							if(index.equals("delete")) {			//刪除時			String profession_id = (String)request.getParameter("id");			String sql = "delete from tb_profession where profession_id='"+profession_id+"'";			DBtool.updateData(sql);		}else if(index.equals("update")) {			//修改時		}				ArrayList profession_list = DBtool.getDataList("tb_profession",new String[]{"profession_id","profession_name","dept_id"}); 		request.setAttribute("profession",profession_list);		ArrayList dept_list = DBtool.getDataList("tb_dept",new String[]{"dept_id","dept_name"}); 			request.setAttribute("dept",dept_list);		return mapping.findForward("success");	}}