preparelessoncheckaction.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.PreparelessoncheckDTO;
import edu.yinhe.mis.util.ExcelTea;
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 PrepareLessonCheckAction extends BaseAction{

	/**
	 * 插入备课记录表数据
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */

	public ActionForward add(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response){
		ActionForward forward=null;
		PrepareLessonCheckForm pform=(PrepareLessonCheckForm)form;
		FormFile formFile=pform.getPreparefile();
		String fileName=formFile.getFileName();
		//Configuration conf=new Configuration();
		fileName=fileName.substring(fileName.lastIndexOf("."));
		fileName=System.currentTimeMillis()+fileName;
		//String savePath=conf.getProperty("uploadSavePath");
		fileName="c:\\"+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集合中；
			//插入到数据库中，
			ExcelTea excel = new ExcelTea();
			ArrayList list = excel.readExcel(fileName);// 把excel文件解析出来封装在ArrayList里
			for (int j = 0; j < list.size(); j++) {
				PreparelessoncheckDTO dto = (PreparelessoncheckDTO) 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("insert");
					// request.getRequestDispatcher("/ok.jsp").forward(request,
					// response);
				} else {
					//request.getRequestDispatcher("/error.jsp").forward(
					//		request, response);// 操作失败的跳转页面----解析或者插入数据不成功
					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;
	}
	
	/**
	 * 部长查看备课记录表
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward miniQuery(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		ActionForward forward = null;
		List list = new ArrayList();
		LoginVO vo = (LoginVO)request.getSession().getAttribute(GlobalNames.SESSION_ID);
		PreparelessoncheckDTO dto = new PreparelessoncheckDTO();
		String startdate = request.getParameter("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"));
			String teano = (String)service.findById(vo);
			if(teano!=null&&!"".equals(teano)){
				dto.setRemark2(teano);
				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;
	}
	
	/**
	 * 组长查看备课记录表
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward teamerQuery(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		ActionForward forward = null;
		List list = new ArrayList();
		LoginVO vo = (LoginVO)request.getSession().getAttribute(GlobalNames.SESSION_ID);
		PreparelessoncheckDTO dto = new PreparelessoncheckDTO();
		String startdate = request.getParameter("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"));
			String teano = (String)service.findById(vo);
			if(teano!=null&&!"".equals(teano)){
				dto.setRemark2(teano);
				service.setDataSource(getDataSource(request,"mydatasource"));
				list = (ArrayList)service.alllist(dto);
				if(list!=null){
					request.setAttribute("dto", dto);
					request.setAttribute("list", list);
					forward = mapping.findForward("teamerquery");
				}
			}
		} catch (AppException e) {
			e.printStackTrace();
		}
		return forward;
	}

}