adddataaction.java

基于STRUTS的试卷分析系统,实现JFREECHART画图片和POI生成EXCEL文档,开发平台:eclipse3.0+myclipse+tomcat5.0+mysql4.0

/*
 * Name:xxx.java 
 * Version:1.0 
 * Copyright(c) MA-LF, WANG-X. 2006 All right reserved. 
 * Created:2006-4-30 
 * Author:WANG-X
 * Updated: 2006-4-30 WANG-X
 * 
 */
package com.hbnu.action;

/**
 * @author jackie
 * @version 1.0
 * 
 */
import java.util.ArrayList;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
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 javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.validator.DynaValidatorForm;
import com.hbnu.common.DUtilBean;
import java.util.HashMap;
import java.util.Map;
import com.hbnu.dao.AddDataDao;
public class AddDataAction extends Action{
	/** 日志对象*/
	protected final Log log = LogFactory.getLog(this.getClass());
	/** 正常终了画面迁移文字*/
	protected static final String FORWARD_SUCCESS = "success";
	/** 异常终了画面迁移文字*/
	protected static final String FORWARD_FAILURE = "failure";
	/** 正常终了返回值*/
	protected static final int RETURN_SUCCESS = 1;
	/** 异常终了返回值*/
	protected static final int RETURN_FAILURE = 0;
	
	/** 
     * <br>画面初始化处理<br>
     * 
     * @param mapping 		ActionMapping对象
	 *  @param form 		ActionForm对象
	 *  @param request 		HttpServletRequest对象
	 *  @param response 	HttpServletResponse对象
	 *  @return af			ActionForward对象
	 *  @throws Exception 
	 */
	 public ActionForward execute(ActionMapping mapping, ActionForm form,
    		HttpServletRequest request, HttpServletResponse response) throws Exception {
	 	DynaValidatorForm sj301Frm = (DynaValidatorForm)form;	
	 	//获得表单中的 detailSj301Map,将其放入SESSION里
	 	Map sj301Map = new HashMap();
	 	sj301Map = (Map) sj301Frm.get("detailSj301Map");
		request.getSession().setAttribute("SJ301detailMap", sj301Map);
	 	//获得表单中的 list_ps_scorse 
	 	ArrayList list_ps_scorse = (ArrayList)sj301Frm.get("list_ps_scorse");
		ArrayList list_ps = new ArrayList();
		for(int i=0;i< list_ps_scorse.size();i++){
			list_ps.add(DUtilBean.removeComma
					(String.valueOf(list_ps_scorse.get(i))));
		}			
	 	//获得表单中的 list_sy_scorse 
		ArrayList list_sy_scorse = (ArrayList)sj301Frm.get("list_sy_scorse");
		ArrayList list_sy = new ArrayList();
		for(int i=0;i< list_sy_scorse.size();i++){
			list_sy.add(DUtilBean.removeComma
					(String.valueOf(list_sy_scorse.get(i))));
		}			
	 	//获得表单中的 list_qm_scorse 
		ArrayList list_qm_scorse = (ArrayList)sj301Frm.get("list_qm_scorse");
		ArrayList list_qm = new ArrayList();
		for(int i=0;i< list_qm_scorse.size();i++){
			list_qm.add(DUtilBean.removeComma
					(String.valueOf(list_qm_scorse.get(i))));
		}			
       //获得表单中的 list_zp_scorse 
		ArrayList list_zp_scorse = (ArrayList)sj301Frm.get("list_zp_scorse");
		ArrayList list_zp = new ArrayList();
		for(int i=0;i< list_zp_scorse.size();i++){
			list_zp.add(DUtilBean.removeComma
					(String.valueOf(list_zp_scorse.get(i))));
		}			
		 //获得表单中的 list_xuefen
		ArrayList list_xuefen = (ArrayList)sj301Frm.get("list_xuefen");
		
		//获得表单中的 list_xuhao
		ArrayList list_xuhao = (ArrayList)sj301Frm.get("list_xuhao");
	
		 //获得表单中的 list_beizhu
		ArrayList list_beizhu = (ArrayList)sj301Frm.get("list_beizhu");
		 //获得表单中的 list_name
		ArrayList list_name = (ArrayList)sj301Frm.get("list_name");
		//将各个ArrayList放入Map中
		Map InfoMap = new HashMap();
		InfoMap.put("list_ps_scorse",list_ps);
		InfoMap.put("list_sy_scorse",list_sy);
		InfoMap.put("list_qm_scorse",list_qm);
		InfoMap.put("list_zp_scorse",list_zp);
		InfoMap.put("list_beizhu",list_beizhu);
		InfoMap.put("list_xuefen",list_xuefen);
		InfoMap.put("list_xuhao",list_xuhao);
		InfoMap.put("list_name",list_name);
		//
		Map detailMap = (Map)sj301Frm.get("detailSj301Map");
		String courseName = String.valueOf(detailMap.get("txt_course"));
		String className = String.valueOf(detailMap.get("txt_classes"));
		//执行数据库插入填写数据
		AddDataDao dataDao = new AddDataDao();
		dataDao.doInfoInsert(courseName,className,InfoMap);
		//将MAP放入SESSION
		request.getSession().setAttribute("SJ301detailMap", detailMap);//CreateStatement将用到此session;
		request.getSession().setAttribute("SJ301InfoMap", InfoMap);//CreateStatement将用到此session;
		return (mapping.findForward("success"));
	 }
	 }