package?com.myExcel.action;

import?java.io.BufferedInputStream;
import?java.io.File;
import?java.io.FileInputStream;
import?java.io.FileNotFoundException;
import?java.io.IOException;
import?java.io.InputStream;
import?java.io.UnsupportedEncodingException;
import?java.util.Map;

import?javax.annotation.Resource;

import?org.apache.struts2.ServletActionContext;
import?org.apache.struts2.convention.annotation.Action;
import?org.apache.struts2.convention.annotation.Namespace;
import?org.apache.struts2.convention.annotation.ParentPackage;
import?org.apache.struts2.convention.annotation.Result;
import?org.springframework.context.annotation.Scope;
import?org.springframework.stereotype.Controller;

import?com.myExcel.service.IExcelService;
/**
?*?
excel控制類

?*?@author?黃文杰，qq:372170989
?*
?*/
@Controller
@Scope（“prototype“）
@Namespace（“/excel“）
@ParentPackage（“json-default“）
public?class?ExcelAction?{
	
	@Resource（name=“excelService“）
	private?IExcelService?excelService;
	private?Mapject>?mm;
	//上傳的文件，（注意，兩個名字不可以隨便修改的，要對應格式，原因百度搜索struts上傳文件教程，并且要與頁面上的對應）
	private?File?input;
	//上傳的文件名，（注意，兩個名字不可以隨便修改的，要對應格式，原因百度搜索struts上傳文件教程）
	private?String?inputFileName;
	//讀取下載文件的輸入流
	private?InputStream?inputStream;
	//?初始的通過param指定的文件名屬性
	//service中創(chuàng)建Excel的文件名（我這里是直接寫死的，大概流程就這樣，你可以根據(jù)項目實際需求來弄，比如可以在server層中保存到Map集合中，跳回action再取出賦值）
	private?String?fileName?=?“測試Excel.xls“;
	
	public?InputStream?getInputStream（）?throws?FileNotFoundException?{
		String?path?=?ServletActionContext.getServletContext（）.getRealPath（“/download/excel“）;
		return?new?BufferedInputStream（new?FileInputStream（path+“\\“+fileName））;
	}

	public?void?setInputStream（InputStream?inputStream）?{
		this.inputStream?=?inputStream;
	}

	public?String?getFileName（）?throws?UnsupportedEncodingException?{
		//解決下載中文亂碼
		return?new?String（this.fileName.getBytes（）?“ISO8859-1“）;???
	}

	public?void?setFileName（String?fileName）?{
		this.fileName?=?fileName;
	}

	//上傳Excel文件
	@Action（value=“upload“results={
			@Result（name=“json“type=“json“params={“root““mm“}）
	}）
	public?String?upload（）{
		mm?=?excelService.upload（input?inputFileName）;
		return?“json“;
	}

	
	//下載Excel文件
	@Action（value=“download“results={
		@Result（name?=?“success“?type?=?“stream“?params?=?{?“contentType“
					“application/octet-stream;charset=ISO8859-1“?“inputName“
					“inputStream“?“contentDisposition“
					“attachment;filename=\“${fileName}\““?“bufferSize“?“4096“?}）
	}）?
	public?String?download（）?throws?IOException?{
		excelService.download（）;
		return?“success“;
	}
		
	public?Mapject>?getMm（）?{
		return?mm;
	}

	public?void?setMm（Mapject>?mm）?{
		this.mm?=?mm;
	}

	public?File?getInput（）?{
		return?input;
	}

	public?void?setInput（File?input）?{
		this.input?=?input;
	}

	public?String?getInputFileName（）?{
		return?inputFileName;
	}

	public?void?setInputFileName（S

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-11-02?09:14??導出導入Excel示例\
?????目錄???????????0??2017-11-01?17:55??導出導入Excel示例\使用ssh框架實現(xiàn)\
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\
?????文件?????????589??2017-11-01?14:01??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\.classpath
?????文件????????1040??2017-11-01?11:56??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\.project
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\.settings\
?????文件?????????567??2017-11-01?11:56??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\.settings\.jsdtscope
?????文件?????????364??2017-11-01?11:56??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\.settings\org.eclipse.jdt.core.prefs
?????文件?????????473??2017-11-01?11:56??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\.settings\org.eclipse.wst.common.component
?????文件?????????345??2017-11-01?11:56??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-11-01?11:56??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-11-01?11:56??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\
?????文件????????6190??2017-11-01?16:35??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\applicationContext?.xml
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\myExcel\
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\myExcel\action\
?????文件????????3802??2017-11-01?17:30??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\myExcel\action\ExcelAction.class
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\myExcel\dao\
?????文件?????????190??2017-11-01?15:54??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\myExcel\dao\IExcelDao.class
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\myExcel\dao\impl\
?????文件?????????749??2017-11-01?15:54??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\myExcel\dao\impl\ExcelDaoImpl.class
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\myExcel\service\
?????文件?????????411??2017-11-01?16:55??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\myExcel\service\IExcelService.class
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\myExcel\service\impl\
?????文件????????6991??2017-11-01?17:34??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\com\myExcel\service\impl\ExcelServiceImpl.class
?????文件????????1504??2017-11-01?15:34??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\jdbc.properties
?????文件????????1532??2017-10-26?08:55??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\build\classes\struts.xml
?????目錄???????????0??2017-11-01?17:46??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\src\
?????文件????????6190??2017-11-01?16:35??導出導入Excel示例\使用ssh框架實現(xiàn)\myExcel\src\applicationContext?.xml
............此處省略99個文件信息