package?com.echarts.servlet;

import?java.awt.image.BufferedImage;
import?java.io.ByteArrayOutputStream;
import?java.io.File;
import?java.io.FileOutputStream;
import?java.io.IOException;
import?java.io.OutputStream;
import?java.net.URLEncoder;

import?javax.imageio.ImageIO;
import?javax.servlet.ServletException;
import?javax.servlet.annotation.WebServlet;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?org.apache.poi.hssf.usermodel.HSSFCell;
import?org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import?org.apache.poi.hssf.usermodel.HSSFPatriarch;
import?org.apache.poi.hssf.usermodel.HSSFRow;
import?org.apache.poi.hssf.usermodel.HSSFSheet;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;

import?sun.misc.base64Decoder;

/**
?*?Servlet?implementation?class?CreateServlet
?*/
@WebServlet（“/createServlet“）
public?class?CreateServlet?extends?HttpServlet?{
	private?static?final?long?serialVersionUID?=?1L;
???????
?
	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
		doPost（request?response）;
	}

	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
	????String?data?=?request.getParameter（“img“）;
	????try?{
	????	
	????	String?userName?=?System.getProperty（“user.name“）;
	????	System.out.println（“userName:“+userName）;
	????	
	????	String?filePath?=?“C:\\Users\\“+userName+“\\Desktop\\chart“;
	????	File?file?=?new?File（filePath）;
	????	if（!file.exists（））{
	????		file.mkdir（）;
	????	}
	????	
	????	String?fileName?=?filePath?+“\\“+?System.currentTimeMillis（）+“.png“;
	???????
	????	createImage（request?response?fileName?data）;
	????	
	????	createExcel（request?response?fileName）;

	????}?catch?（Exception?e）?{
	????????e.printStackTrace（）;
	????}
	}
	
	public?void?createImage（HttpServletRequest?request?HttpServletResponse?response
			String?fileName?String?data）?
			throws?ServletException?IOException?{
		try?{
	????????String[]?url?=?data.split（““）;
	????????String?u?=?url[1];
	????????//?base64解碼
	????????byte[]?b?=?new?base64Decoder（）.decodeBuffer（u）;
	????????//?生成圖片
	????????OutputStream?out?=?new?FileOutputStream（new?File（fileName））;
	????????out.write（b）;
	????????out.flush（）;
	????????out.close（）;			
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
	
	public?void?createExcel（HttpServletRequest?request?HttpServletResponse?response?String?fileName）?
			throws?ServletException?IOException?{
????????
		??//?第一步，創(chuàng)建一個webbook，對應一個Excel文件
		HSSFWorkbook?wb?=?new?HSSFWorkbook（）;
		??//?第二步，在webbook中添加一個sheet對應Excel文件中的sheet
		HSSFSheet?sheet?=?wb.createSheet（“echart“）;
		HSSFRow?row?=?null;
????????row?=?sheet.createRow（60）;
????????
????????/*HSSFCell?headerCell?=?row.createCell（0）;????
????????headerCell.setCellType（HSSFCell.CELL_T

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

?????文件???????1192??2015-12-10?17:35??MyProject\.classpath

?????文件????????300??2015-12-04?11:52??MyProject\.mymetadata

?????文件???????1227??2015-12-03?17:25??MyProject\.project

?????文件????????330??2015-12-03?17:25??MyProject\.settings\org.eclipse.jdt.core.prefs

?????文件???????4254??2015-12-08?17:15??MyProject\src\com\echarts\servlet\CreateServlet.java

?????文件???????1394??2015-12-08?17:35??MyProject\src\com\echarts\servlet\EchartsServlet.java

?????文件???????2062??2015-12-08?17:15??MyProject\src\com\echarts\servlet\PieServlet.java

?????文件???????2290??2015-12-08?16:25??MyProject\WebRoot\chart\bar.jsp

?????文件???????4445??2015-12-08?16:25??MyProject\WebRoot\chart\line.jsp

?????文件???????7452??2015-12-11?11:13??MyProject\WebRoot\chart\map.jsp

?????文件???????2962??2015-12-08?16:25??MyProject\WebRoot\chart\pie.jsp

?????文件???????3205??2015-12-11?11:43??MyProject\WebRoot\chart\test.jsp

?????文件???????6148??2015-12-03?17:27??MyProject\WebRoot\echarts\.DS_Store

?????文件???????4036??2015-12-03?17:27??MyProject\WebRoot\echarts\application.js

?????文件???????3483??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-affix.js

?????文件???????2524??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-alert.js

?????文件???????2841??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-button.js

?????文件???????6057??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-carousel.js

?????文件???????4735??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-collapse.js

?????文件???????4203??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-dropdown.js

?????文件???????6656??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-modal.js

?????文件???????3115??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-popover.js

?????文件???????4655??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-scrollspy.js

?????文件???????3496??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-tab.js

?????文件???????9911??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-tooltip.js

?????文件???????2073??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-transition.js

?????文件???????8320??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap-typeahead.js

?????文件??????55258??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap.js

?????文件??????29110??2015-12-03?17:27??MyProject\WebRoot\echarts\bootstrap.min.js

?????文件?????209071??2015-12-03?17:27??MyProject\WebRoot\echarts\codemirror.js

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