package?controller;
import?java.io.IOException;
import?java.io.PrintWriter;
import?java.text.SimpleDateFormat;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;

import?javax.servlet.ServletException;
import?javax.servlet.ServletOutputStream;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?org.apache.poi.hssf.usermodel.HSSFSheet;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.ss.usermodel.Sheet;
import?org.apache.poi.ss.usermodel.Workbook;
import?org.apache.poi.xssf.usermodel.XSSFWorkbook;

import?StudentImpl.StudentServiceImpl;
import?model.Student;
import?net.sf.json.JSONobject;
import?util.ExportUtils;
import?util.OtherReadExcel;
import?util.ReadExcel;



public?class?StudentContro??extends??HttpServlet{
	
	?/**
	?*?
	?*/
	private?static?final?long?serialVersionUID?=?1L;
	
	private?Workbook??workbook;
	private?Sheet??sheet;
	??public?void?destroy（）?{??
	????????super.destroy（）;?
	????}??
	??
	????/**?
	?????*?初始化servlet?
	?????*/??
	????public?void?init（）?throws?ServletException?{??
	????}??
	????public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
				throws?ServletException?IOException?{
			this.doPost（request?response）;
		}
	????
		public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
				throws?ServletException?IOException?{
			String?opSt=request.getParameter（“status“）;
			if（opSt!=null）{
				if（opSt.equals（“out“））{
					//導出
					try?{
						exportEXcel（request?response）;
					}?catch?（Exception?e）?{
						e.printStackTrace（）;
					}
				}else??if（opSt.equals（“otherRead“））{
					//另一種07解析
					try?{
						OtherreadExcel（request?response）;
					}?catch?（Exception?e）?{
						e.printStackTrace（）;
					}
				}
				
				
				
			}
		
		}
	
	/**
	?*?導出EXcel
	?*?03版
	?*?需要jar:
	?*?poi-3.9.jar
	?*?@throws?IOException?
	?*/
	public?void?exportEXcel（HttpServletRequest?request?HttpServletResponse?response）?throws?Exception{
		String?str?=?new?String（request.getParameter（“valArr“）.getBytes（“iso-8859-1“）?“utf-8“）;?
		/*String??as=str.substring（3?str.length（）-1）;*/
		String[]?headName?=?str.split（““）;
		List??list?=?new?ArrayList（）;
		for（int?i=0;i<99;i++）{
			Student??ss=new?Student（）;
			ss.setName（“張三“+i）;
			int?age=i+1;
			ss.setAge（String.valueOf（age））;
			if（i%2==0）{
				ss.setSex（“男“）;
			}else{
				ss.setSex（“女“）;
			}
			list.add（ss）;
		}
		response.setContentType（“application/octet-stream“）;
		SimpleDateFormat??ss=new?SimpleDateFormat（“yyyyMMddHHmmss“）;
		String?dateString=ss.format（new?Date（））;
		response.setHeader（“Content-Disposition“?“attachment;filename=ProjectList“+dateString+“.xls“）;
		HSSFWorkbook??wb=new??HSSFWorkbook（）;
		HSSFSheet??sheets=wb.createSheet（“sheet0“）

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1707??2016-06-02?10:46??DEMO\demo\.classpath

?????文件???????1096??2016-06-01?09:44??DEMO\demo\.project

?????文件????????503??2013-11-11?14:12??DEMO\demo\.settings\.jsdtscope

?????文件????????109??2016-06-01?09:33??DEMO\demo\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2013-11-11?14:12??DEMO\demo\.settings\org.eclipse.jdt.core.prefs

?????文件????????464??2016-06-01?09:44??DEMO\demo\.settings\org.eclipse.wst.common.component

?????文件????????305??2013-11-11?14:12??DEMO\demo\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2013-11-11?14:12??DEMO\demo\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-11-11?14:12??DEMO\demo\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????7769??2016-06-03?15:10??DEMO\demo\bin\controller\StudentContro.class

?????文件????????958??2016-06-03?15:10??DEMO\demo\bin\model\Student.class

?????文件???????7216??2016-06-03?15:10??DEMO\demo\bin\servlet\uploadDemoServlet.class

?????文件???????2668??2016-06-03?15:10??DEMO\demo\bin\StudentImpl\StudentServiceImpl.class

?????文件???????2906??2016-06-03?15:10??DEMO\demo\bin\util\ExportUtils.class

?????文件???????3275??2016-06-03?15:10??DEMO\demo\bin\util\OtherReadExcel.class

?????文件???????9622??2016-06-03?15:10??DEMO\demo\bin\util\ReadExcel.class

?????文件???????5927??2016-06-03?15:03??DEMO\demo\src\controller\StudentContro.java

?????文件????????590??2016-06-01?10:38??DEMO\demo\src\model\Student.java

?????文件???????6216??2016-06-03?14:41??DEMO\demo\src\servlet\uploadDemoServlet.java

?????文件???????1466??2016-06-02?13:35??DEMO\demo\src\StudentImpl\StudentServiceImpl.java

?????文件???????1632??2016-06-01?10:03??DEMO\demo\src\util\ExportUtils.java

?????文件???????2374??2016-06-02?10:18??DEMO\demo\src\util\OtherReadExcel.java

?????文件???????9529??2016-06-03?15:01??DEMO\demo\src\util\ReadExcel.java

?????文件???????8568??2015-09-23?11:47??DEMO\demo\WebContent\js\ajaxfileupload.js

?????文件??????25773??2016-06-01?11:47??DEMO\demo\WebContent\js\ajaxupload.js

?????文件????????395??2016-06-03?15:10??DEMO\demo\WebContent\js\jquery.jokeer.js

?????文件??????93871??2015-09-23?11:48??DEMO\demo\WebContent\js\jquery.js

?????文件?????????39??2013-11-11?14:12??DEMO\demo\WebContent\meta-INF\MANIFEST.MF

?????文件???????1667??2016-06-03?15:14??DEMO\demo\WebContent\OtherReadExcel.jsp

?????文件???????2001??2016-06-03?15:13??DEMO\demo\WebContent\readExcel.jsp

............此處省略46個文件信息