qualitymainaction.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.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

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.QualityMainDTO;
import edu.yinhe.mis.util.ExcelQuality;
import edu.yinhe.system.common.AppException;
import edu.yinhe.system.common.GlobalNames;
import edu.yinhe.system.control.BaseAction;
import edu.yinhe.system.vo.LoginVO;

/**
 * @author 熊星 
 * 注释为测试时用
 */
public class QualityMainAction extends BaseAction {

	/**
	 * 
	 * 插入教师品质月度评估表数据 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward addQualitymain(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// System.out.println("找到了对应的方法");
		ActionForward forward = null;
		QualityMainForm qmform = (QualityMainForm) form;
		FormFile formFile = qmform.getQualityfile();
		String fileName = formFile.getFileName();
		//System.out.println(fileName);
		if(fileName.indexOf(".xls")==-1){
			//System.out.print("...............");
			return forward = mapping.findForward("nopass");
		}
		// Configuration conf=new Configuration();
		fileName = fileName.substring(fileName.lastIndexOf("."));
		fileName = System.currentTimeMillis() + fileName;
		// String savePath=conf.getProperty("uploadSavePath");
		fileName = "c:\\" + fileName;
		//System.out.println("fileName:"+ fileName);

		try {
			FileOutputStream fout = new FileOutputStream(fileName);
			BufferedInputStream fin = new BufferedInputStream(formFile
					.getInputStream());
			// FileInputStream fin=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();

			// 读文件并采集数据，装入到List集合中；
			// 插入到数据库中，
			ExcelQuality excel = new ExcelQuality();
			ArrayList<QualityMainDTO> list = excel.readExcel(fileName);// 把excel文件解析出来封装在ArrayList里
			//System.out.println(list.size() + "    list.size()");
			for (int j = 0; j < list.size(); j++) {
				QualityMainDTO dto = (QualityMainDTO) list.get(j);// 把ArrayList里的数据放到DTO里
				// list=(ArrayList)service.findAll();//调用服务层的方法
				Boolean isInsert = false;
				try {
					service
							.setDataSource(getDataSource(request,
									"mydatasource"));// 设置连接,固定写法,这个service是从BaseAction继承过来
					isInsert = (Boolean) service.create(dto);
				} catch (AppException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}// 把数据插入到数据库的表excel里
				if (isInsert) {
					forward = mapping.findForward("pass");
					// request.getRequestDispatcher("/ok.jsp").forward(request,
					// response);
				} else {
					// request.getRequestDispatcher("/error.jsp").forward(
					// request, response);// 操作失败的跳转页面----解析或者插入数据不成功
					forward = mapping.findForward("nopass");
				}
			}

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

	/**
	 * 组长查看教师品质月度评估表
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward teamerQuery(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		ActionForward forward = null;
		//System.out.println("找到了对应的方法");
		List list = new ArrayList();
		LoginVO vo = (LoginVO) request.getSession().getAttribute(
				GlobalNames.SESSION_ID);
		QualityMainDTO dto = new QualityMainDTO();
		String startdate = request.getParameter("startdate");
		//System.out.println(startdate);
		String enddate = request.getParameter("enddate");
		String teacher = request.getParameter("teacher");
		if (teacher != null && !"".equals(teacher)) {
			dto.setTeacherName(teacher);
		}
		  if(startdate!=null && !"".equals(startdate)) {
		  dto.setStartdate(startdate); 
		  dto.setEnddate(enddate); }
		 
		try {
			service.setDataSource(getDataSource(request, "mydatasource"));

			list = (ArrayList) service.alllist(dto);
			if (list != null) {
				request.setAttribute("dto", dto);
				request.setAttribute("list", list);
				forward = mapping.findForward("qualityquery");
			}

		} catch (AppException e) {
			e.printStackTrace();
		}
		return forward;
	}	
	
	/**
	 * 部长查看教师品质月度评估表
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward miniQuery(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		ActionForward forward = null;
		//System.out.println("找到了对应的方法");
		List list = new ArrayList();
		LoginVO vo = (LoginVO) request.getSession().getAttribute(
				GlobalNames.SESSION_ID);
		QualityMainDTO dto = new QualityMainDTO();
		String startdate = request.getParameter("startdate");
		//System.out.println(startdate);
		String enddate = request.getParameter("enddate");
		String teacher = request.getParameter("teacher");
		if (teacher != null && !"".equals(teacher)) {
			dto.setTeacherName(teacher);
		}
		  if(startdate!=null && !"".equals(startdate)) {
		  dto.setStartdate(startdate); 
		  dto.setEnddate(enddate); }
		 
		try {
			service.setDataSource(getDataSource(request, "mydatasource"));

			list = (ArrayList) service.alllist(dto);
			if (list != null) {
				request.setAttribute("dto", dto);
				request.setAttribute("list", list);
				forward = mapping.findForward("miniquery");
			}

		} catch (AppException e) {
			e.printStackTrace();
		}
		return forward;
	}	
}