sj201action.java

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

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

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
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 org.apache.struts.validator.DynaValidatorForm;
import com.hbnu.dao.Sj201Dao;
/**
 * @author jackie
 * @version 1.0 
 * 
 */
public class Sj201Action 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;
    /** 画面处理分歧值*/
    protected String detailFlg = "init";
	private String sjbh ="";
    
    /** 
     * <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 {
    	
    	if (log.isDebugEnabled()) log.debug(" setParamData call. ");
		this.setParamData(form,request);
		
		if (log.isDebugEnabled()) log.debug(" getResultData call. ");
		this.getResultData(form,request);
		
		ActionForward af = mapping.findForward(this.getForwardName(RETURN_SUCCESS));
		if (log.isDebugEnabled()) log.debug(" returns " + af);

		return af;
    }
    
    /**
     * <br>画面间引继情报获取<br>
     * 
     * @param form			ActionForm对象
     * @param request		HttpServletRequest对象
     * @throws Exception	
     *  
     */    
    public void setParamData(ActionForm form, HttpServletRequest request) throws Exception {
    	if (log.isDebugEnabled()) log.debug(" setParamData started. ");
    	
    	/*引继情报获取*/
    	detailFlg = String.valueOf(request.getParameter("dispatch"));
    	sjbh = String.valueOf(request.getParameter("bhID"));
    }
    
    /**
     * <br>画面对应项目表示<br>
     * 
     * @param form 			ActionForm对象
	 * @param request 		HttpServletRequest对象
	 * @throws Exception
	 */
    public void getResultData(ActionForm form,HttpServletRequest request) throws Exception{
    	if (log.isDebugEnabled()) log.debug(" getResultData started. ");
        
    	/*画面处理分歧:添加试卷分析*/
    	if (this.detailFlg.equals("init")) {
    	    /*下拉列表list填充*/
    	    this.setListData(form);
    
    		
    	}/*画面处理分歧:编辑试卷分析*/
    	if (this.detailFlg.equals("modify")) {
    	    /*下拉列表list填充*/
    	    this.setListData(form);
    	    DynaValidatorForm sj201DynaForm = (DynaValidatorForm) form;
    	    String user_name = String.valueOf((request.getSession().getAttribute("user_name")));
    	    sj201DynaForm.set("username",user_name);
    	    
    	    Sj201Dao sj201 = new Sj201Dao();
    	    ArrayList sj201List = new ArrayList();
    	    sj201List = sj201.getSj201Info(this.sjbh);
    	    int sj201size = sj201List.size();
    	    /*画面对应项目表示*/
    	    for ( int i =0; i< sj201size;i++){
    	        Map selectMap = new HashMap();
    	        selectMap = (Map)sj201List.get(i);
    	        
    	        System.out.println(String.valueOf(selectMap.get("kssj")));
    	        sj201DynaForm.set("txt_examTime",	String.valueOf(selectMap.get("kssj")));
    	        sj201DynaForm.set("txt_ps_scorse",	String.valueOf(selectMap.get("pscj")));
    	        sj201DynaForm.set("txt_sy_scorse",	String.valueOf(selectMap.get("sycj")));
    	        sj201DynaForm.set("txt_profession",	String.valueOf(selectMap.get("zymc")));
    	        sj201DynaForm.set("txt_setStyle",	String.valueOf(selectMap.get("mtfs")));
    	        sj201DynaForm.set("txt_check_teacher",String.valueOf(selectMap.get("yjjs")));
    	        sj201DynaForm.set("txt_checkStyle",	String.valueOf(selectMap.get("yjfs")));
    	        sj201DynaForm.set("txt_classes",	String.valueOf(selectMap.get("bjmc")));
    	        sj201DynaForm.set("txt_teacher",	String.valueOf(selectMap.get("rklaoshi")));
    	        sj201DynaForm.set("txt_course",		String.valueOf(selectMap.get("kcmc")));
    	        sj201DynaForm.set("txt_room",		String.valueOf(selectMap.get("jysmc")));
    	        sj201DynaForm.set("txt_courseId",	String.valueOf(selectMap.get("kcbh")));
    	        sj201DynaForm.set("txt_courseTime",	String.valueOf(selectMap.get("kcxs")));
    	        sj201DynaForm.set("txt_courseScore",String.valueOf(selectMap.get("xuefen")));
    	    }	
    	}
    }
    
    /**
     * <br>下拉列表list填充<br>
     * 
     * @param form		ActionForm对象	
     *  
     */
    public void setListData(ActionForm form) {
        DynaValidatorForm sj201DynaForm = (DynaValidatorForm) form;
        /* 考试时间List */
		final String [] examTime ={"2006 - 2007 第一学期", "2006 - 2007 第二学期", "2005 - 2006 第一学期", "2005 - 2006 第二学期",
              	 					"2003 - 2004 第一学期", "2003 - 2004 第二学期", "2002 - 2003 第一学期","2002 - 2003 第二学期"};
        ArrayList examTimeList = new ArrayList();
        examTimeList = this.setListData("examTime_label", "examTime_value", examTime, examTimeList);
		sj201DynaForm.set("pld_examTime", examTimeList);
		
		/* 系部List */
		final String [] dept = {"计算机科学系", "中文系",  "数学系", "外语系", "政法系", "化环系",
								 "物理系", "生物系", "体育系", "音乐系", "教科系", "信工系"};
		ArrayList deptList = new ArrayList();
		deptList = this.setListData("dept_label","dept_value", dept, deptList);
		sj201DynaForm.set("pld_dept", deptList);
		
		/*课程类别List*/
		final String [] Category = {"公共选修","公共必修","专业必修","专业选修"};
		ArrayList categoryList = new ArrayList();
		categoryList = this.setListData("category_label","category_value",Category, categoryList);
		sj201DynaForm.set("pld_category",categoryList);
		/*平时成绩List*/
		final String [] pscj = {"平时成绩","实验操作","口语成绩","体育测试"};
		ArrayList pscjList = new ArrayList();
		pscjList = this.setListData("ps_label","ps_value",pscj, pscjList);
		sj201DynaForm.set("pld_ps_scorse",pscjList);
		/*实验成绩List*/
		final String [] sycj = {"实验成绩","期中考试","实验操作","体育测试"};
		ArrayList sycjList = new ArrayList();
		sycjList = this.setListData("sy_label","sy_value",sycj, sycjList);
		sj201DynaForm.set("pld_sy_scorse",sycjList);
		/*期末成绩List*/
		final String [] qmcj = {"期末考试"};
		ArrayList qmcjList = new ArrayList();
		qmcjList = this.setListData("qm_label","qm_value",qmcj, qmcjList);
		sj201DynaForm.set("pld_qm_scorse",qmcjList);
		/*平时成绩权重List*/
		final String [] pscjqz = {"10%","20%","30%","40%","50%","60%","70%","80%","90%","100%"};
		ArrayList pscjqzList = new ArrayList();
		pscjqzList = this.setListData("ps_label","ps_value",pscjqz, pscjqzList);
		sj201DynaForm.set("pld_ps_weight",pscjqzList);
		/*实验成绩权重List*/
		final String [] sycjqz = {"10%","20%","30%","40%","50%","60%","70%","80%","90%","100%"};
		ArrayList sycjqzList = new ArrayList();
		sycjqzList = this.setListData("sy_label","sy_value",sycjqz, sycjqzList);
		sj201DynaForm.set("pld_sy_weight",sycjqzList);
		/*期末成绩权重List*/ 
		final String [] qmcjqz = {"10%","20%","30%","40%","50%","60%","70%","80%","90%","100%"};
		ArrayList qmcjqzList = new ArrayList();
		qmcjqzList = this.setListData("qm_label","qm_value",qmcjqz, qmcjqzList);
		sj201DynaForm.set("pld_qm_weight",qmcjqzList);
		/*考试方式List*/
		final String [] examStyle = {"开卷","闭卷"};
		ArrayList examStyleList = new ArrayList();
		examStyleList = this.setListData("examStyle_label","examStyle_value",examStyle, examStyleList);
		sj201DynaForm.set("pld_examStyle",examStyleList);
		
    }
    
    /**
     * <br>下拉列表list填充<br>
     * 
     * @param label			
     * @param value		
     * @param name
     * @param list 
     *  
     */
    public ArrayList setListData(String label, String value, String [] name , ArrayList list) {
    	HashMap map = new HashMap();
    	map.put(label,"");
    	map.put(value,"");
    	list.add(map);
    	for(int i = 0; i < name.length;++i) {
    		map = new HashMap();
    		map.put(label, String.valueOf(name[i]));
    		map.put(value, String.valueOf(name[i]));
    		list.add(map);
    	}
    	return list;
    }
    
    
    /**
     * <br>画面迁移文字获取<br>
     * 
     * @param code			返回值
     * @param dispatch		画面迁移文字
     * @throws Exception	
     * 
     */
    public String getForwardName(int code) {
		if(log.isDebugEnabled()) log.debug(" getForwardName started. ");
		
		if (code == RETURN_FAILURE) {
			return FORWARD_FAILURE;
		} 
		
		return FORWARD_SUCCESS;
	}
}