tevaluateaction.java

中应用程序的访问权限对Java Web Console 中应用程序的访问权限 成功登录 Web 控制台后,可能无法自动访问在该控制台中注册的所有应用程序。通常,必须安装应用程序,才能让所有的用户在控制

package edu.yinhe.mis.control;

import java.io.BufferedInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.beanutils.BeanUtils;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.upload.FormFile;
import edu.yinhe.mis.dto.TevaluateDTO;
import edu.yinhe.system.common.AppException;
import edu.yinhe.system.control.BaseAction;

public class TevaluateAction extends BaseAction{

	/**
	 * @author wanjiansheng
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return forward
	 * 导入教师课堂教学评估的Excel表
	 */
	public ActionForward teamerFillIn(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		ActionForward forward=null;
		TevaluateForm temf=(TevaluateForm)form;
		FormFile formFile=temf.getTevaluatefile();
		String fileName=formFile.getFileName();
		fileName=fileName.substring(fileName.lastIndexOf("."));
		fileName=System.currentTimeMillis()+fileName;
		fileName="c:\\"+fileName;
		try {
			FileOutputStream fout=new FileOutputStream(fileName);
			BufferedInputStream fin=new BufferedInputStream(formFile.getInputStream());
			byte[] bytes=new byte[1024*2];
			int i=0;
			while((i=fin.read(bytes, 0, bytes.length))!=-1){
				fout.write(bytes, 0, i);
			}
			fout.flush();
			fout.close();
			fin.close();
			TevaluateExcel excel = new TevaluateExcel();
			//读文件并采集数据，装入到List集合中；			
			ArrayList list = excel.readExcel(fileName);// 把excel文件解析出来封装在ArrayList里
			System.out.println(list.size() + "list.size()");
			for (int j = 0; j < list.size(); j++) {
				TevaluateDTO dto = (TevaluateDTO) list.get(j);// 把ArrayList里的数据放到DTO里
				Boolean flag=false;
				try {
					service.setDataSource(getDataSource(request,"mydatasource"));//设置连接,固定写法,这个service是从BaseAction继承过来
					flag = (Boolean) service.create(dto);// 把数据插入到数据库的表excel里
				} catch (AppException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				if (flag) {
					forward=mapping.findForward("teamerFillin");
				} else {
					forward=mapping.findForward("/error.jsp");
				}
			}

		} catch (FileNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return forward;

	}
	/**
	 * @author wanjiansheng
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return forward
	 * 查询教师课堂教学评估表
	 */
	public ActionForward teamerQuery(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		TevaluateForm tef=new TevaluateForm();
		ActionForward forward=null;
		List list=new ArrayList();
		TevaluateDTO temd=new TevaluateDTO();
		String startDate=request.getParameter("startDate");
		String endDate=request.getParameter("endDate");
		String subject=request.getParameter("subject");
		String teacher=request.getParameter("teacher");
		String facSore=request.getParameter("facSore");
		if(startDate!=null&&!"".equals(startDate)){
			tef.setStartDate(startDate);
			tef.setEndDate(endDate);
		}
		if(subject!=null&&!"".equals(subject)){
			tef.setSubject(subject);
		}
		if(teacher!=null&&!"".equals(teacher)){
			tef.setTeacher(teacher);
		}
		if(facSore!=null&&!"".equals(facSore)){
			tef.setFacSore(Integer.parseInt(facSore));
			System.out.println(Integer.parseInt(facSore));
		}
		try {
			BeanUtils.copyProperties(temd, tef);
			service.setDataSource(getDataSource(request,"mydatasource"));
			request.setAttribute("dto", temd);
			list=(List) service.alllist(temd);
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (InvocationTargetException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (AppException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		if(list!=null){
			request.setAttribute("tlist", list);
			request.setAttribute("dto", temd);
			forward=mapping.findForward("teamerQuery");
		}
		return forward;

	}
}