browsefileaction.java

基于JAVA的学生就业信息网 实现对信息浏览 检索 审核 修改和删除

/*
 * Created on 2006-7-24
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package org.ug.sztz.webview.structs.actions.oa;

import java.io.FileInputStream;
import java.io.IOException;
import java.util.Vector;

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

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
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 org.ug.sztz.domain.assistant.UrlConvertor;
import org.ug.sztz.webview.structs.forms.AddNewsPicForm;

/**
 * @author Skywalker
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class BrowseFileAction extends BaseUploadAction {

	/* (non-Javadoc)
	 * @see org.apache.struts.action.Action#execute(org.apache.struts.action.ActionMapping, org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception {
		// TODO Auto-generated method stub
		
		AddNewsPicForm addNewsPicForm = (AddNewsPicForm)form;
		FormFile file =addNewsPicForm.getNewsPic();
		
		if(file != null && file.getFileSize() > 0)
      	{
			
      		String fname = file.getFileName();
      		//组合文件名
      		if(!fname.substring(fname.lastIndexOf(".")).equalsIgnoreCase(".xls"))
      		{
      			request.setAttribute("info","上传失败！请上传xls格式的文件！");
      			return mapping.findForward("failure");
      		}
      		fname = "data.xls";//文件名由时间和文件扩展名组成
      		this.uploadFile(file,fname);
      		UrlConvertor urlConvertor = new UrlConvertor(this.getServlet().getServletConfig());
      		
      		try{
      		POIFSFileSystem fs      =
                new POIFSFileSystem(new FileInputStream(urlConvertor.getAbsoluteFile("/upload/",fname)));
      		Vector vector =new Vector();
      		HSSFWorkbook wb = new HSSFWorkbook(fs);
      	    HSSFSheet sheet = wb.getSheetAt(0);
      	    HSSFRow row = sheet.getRow(0);
      	   // System.out.println(row.getRowNum()+"*"+row.getLastCellNum()+"*"+row.getHeight()+"*"+row.getFirstCellNum());
      	    for(int i=0;i<row.getLastCellNum();i++){
      	    	HSSFCell cell = row.getCell((short)i);
      	    	vector.add(cell.getStringCellValue());
      	    }     	    
      	    request.setAttribute("colname",vector);
      		}catch(IOException e){
      			System.out.println(e);
      		}
      		return mapping.findForward("success");
      	}
      	else
      	{
      		request.setAttribute("info","上传失败！");
      		return mapping.findForward("failure");
      	}
		
	}
}