package?com.demo.cyd.action;

import?java.io.ByteArrayInputStream;
import?java.io.ByteArrayOutputStream;
import?java.io.File;
import?java.io.FileInputStream;
import?java.io.InputStream;
import?java.util.ArrayList;
import?java.util.List;

import?javax.annotation.Resource;
import?javax.servlet.http.HttpServletRequest;

import?org.apache.poi.hssf.usermodel.HSSFDataFormat;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.ss.usermodel.Cell;
import?org.apache.poi.ss.usermodel.Cellstyle;
import?org.apache.poi.ss.usermodel.Row;
import?org.apache.poi.ss.usermodel.Sheet;
import?org.apache.poi.ss.usermodel.Workbook;
import?org.apache.struts2.ServletActionContext;
import?org.springframework.context.annotation.Scope;
import?org.springframework.stereotype.Component;

import?com.demo.cyd.java.UploadFile;
import?com.demo.cyd.model.Student;
import?com.demo.cyd.service.StudentService;
import?com.opensymphony.xwork2.ActionSupport;

@SuppressWarnings（“serial“）
@Scope（“prototype“）
@Component
public?class?StudentAction?extends?ActionSupport?{

	private?InputStream?excelFile;
	private?File?uploadFile;
	private?String?uploadFileFileName;
	private?StudentService?studentService;

	//?進入頁面查詢數(shù)據(jù)
	public?String?listAll（）?{
		HttpServletRequest?request?=?ServletActionContext.getRequest（）;
		List?sList?=?studentService.findAll（）;
		request.setAttribute（“l(fā)ist“?sList）;
		return?“l(fā)istAll“;
	}

	//?導出Excel
	public?String?ExcelExport（）?throws?Exception?{
		HttpServletRequest?request?=?ServletActionContext.getRequest（）;
		String?ids?=?request.getParameter（“ids“）;
		List?list?=?new?ArrayList（）;
		String[]?array?=?ids.split（““）;
		int[]?id?=?new?int[array.length];
		for?（int?i?=?0;?i?			Student?student?=?studentService
					.findById（Integer.valueOf（array[i]））;
			list.add（student）;
		}
		Workbook?workbook?=?new?HSSFWorkbook（）;
		Sheet?sheet?=?workbook.createSheet（“學生信息“）;
		Row?row?=?sheet.createRow（0）;
		row.createCell（0）.setCellValue（“學號“）;
		row.createCell（1）.setCellValue（“姓名“）;
		row.createCell（2）.setCellValue（“年齡“）;
		row.createCell（3）.setCellValue（“性別“）;
		row.createCell（4）.setCellValue（“地址“）;
		Cellstyle?cellstyle?=?workbook.createCellstyle（）;
		cellstyle.setDataFormat（HSSFDataFormat.getBuiltinFormat（“m/d/yy“））;
		for?（int?i?=?1;?i?<=?list.size（）;?i++）?{
			Student?stu?=?list.get（i?-?1）;
			row?=?sheet.createRow（i）;
			row.createCell（0）.setCellValue（stu.getS_id（））;
			row.createCell（1）.setCellValue（stu.getS_name（））;
			row.createCell（2）.setCellValue（stu.getS_age（））;
			row.createCell（3）.setCellValue（stu.getS_sex（））;
			row.createCell（4）.setCellValue（stu.getS_address（））;
		}
		ByteArrayOutputStream?baos?=?new?ByteArrayOutputStream（）;
		workbook.write（baos）;
		excelFile?=?new?ByteArrayInputStream（baos.toByteArray（））;
		baos.close（）;
		return?“excel“;
	}

	//?導入Excel
	public?String?ExcelInto（）?throws?Exception?{
		String?di

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-10-24?14:54??Poi導出excel\
?????文件????????5990??2012-12-13?22:27??Poi導出excel\.classpath
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\.myeclipse\
?????文件?????????315??2012-12-13?22:27??Poi導出excel\.mymetadata
?????文件????????1420??2012-12-13?22:27??Poi導出excel\.project
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\.settings\
?????文件?????????500??2012-12-13?22:27??Poi導出excel\.settings\.jsdtscope
?????文件?????????330??2012-12-13?22:27??Poi導出excel\.settings\org.eclipse.jdt.core.prefs
?????文件??????????49??2012-12-13?22:27??Poi導出excel\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2012-12-13?22:27??Poi導出excel\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\src\
?????文件????????3266??2012-12-13?22:27??Poi導出excel\src\beans.xml
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\src\com\
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\src\com\demo\
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\action\
?????文件????????5266??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\action\StudentAction.java
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\dao\
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\dao\impl\
?????文件????????1140??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\dao\impl\StudentDaoImpl.java
?????文件?????????240??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\dao\StudentDao.java
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\java\
?????文件?????????491??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\java\UploadFile.java
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\model\
?????文件????????1079??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\model\Student.java
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\service\
?????文件?????????738??2012-12-13?22:27??Poi導出excel\src\com\demo\cyd\service\StudentService.java
?????文件????????1543??2012-12-13?22:27??Poi導出excel\src\log4j.properties
?????文件????????1222??2012-12-13?22:27??Poi導出excel\src\struts.xml
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\WebRoot\
?????目錄???????????0??2012-12-13?22:27??Poi導出excel\WebRoot\css\
............此處省略130個文件信息