addprofessionaction.java

为基于J2EE（Java2 Platform

/*
 * name:	添加专业
 * file:	AddProfessionAction.java
 * author:	王耸
 */
package 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.AddProfessionForm;

public class AddProfessionAction extends Action {

	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		AddProfessionForm addProfessionForm = (AddProfessionForm) form;
		
		//从request中提取index标志
		String index = (String)request.getParameter("index");
		
		if(index.equals("add")) {
			String sql = "insert into tb_profession values("+addProfessionForm.getProfession_id()+",'"+addProfessionForm.getProfession_name()+"',"+addProfessionForm.getDept_id()+")"; 
			DBtool.updateData(sql);
			return mapping.findForward("success");
		}
		
		ArrayList list = DBtool.getDataList("tb_dept",new String[]{"dept_id","dept_name"}); 	
		request.setAttribute("dept",list);
		return mapping.findForward("fail");

	}

}