adddeptaction.java

为基于J2EE（Java2 Platform

/*
 * 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");
		}
	}

}