/* * name:	添加系別 * file:	AddDeptAction.java * author:	王聳 */package com.huang.actions;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.AddDeptForm;public class AddDeptAction extends Action {	public ActionForward execute(		ActionMapping mapping,		ActionForm form,		HttpServletRequest request,		HttpServletResponse response) {				//建立添加系別Form		AddDeptForm addDeptForm = (AddDeptForm) form;				//從addDeptForm中提取系別id和系別name		String dept_id = addDeptForm.getDept_id();		String dept_name = addDeptForm.getDept_name();				//編寫sql語句		String sql = "insert into tb_dept values('"+dept_id+"','"+dept_name+"')";				//提交sql語句		if(DBtool.updateData(sql)) {			//成功后跳轉到成功頁面			return mapping.findForward("success");		}else {			//失敗跳轉到失敗頁面			return mapping.findForward("fail");		}	}}