91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 10.83MB
    文件類型: .zip
    金幣: 2
    下載: 0 次
    發布日期: 2023-10-15
  • 語言: 其他
  • 標簽: export??

資源簡介

導出

資源截圖

代碼片段和文件信息 

package?xingyou.controller;

import?java.util.ArrayList;
import?java.util.Date;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;
import?java.util.zip.ZipOutputStream;

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

import?org.springframework.stereotype.Controller;
import?org.springframework.web.bind.annotation.RequestMapping;
import?org.springframework.web.bind.annotation.ResponseBody;

import?xingyou.excelTools.ExcelBean;
import?xingyou.excelTools.ExcelUtils;
import?xingyou.excelTools.JsGridReportbase;
import?xingyou.excelTools.TableColumn;
import?xingyou.excelTools.TableData;
import?xingyou.excelTools.TableHeadermetaData;
import?xingyou.module.DataCount;
import?xingyou.module.People;

@Controller
@RequestMapping（“/export.do“）
@SuppressWarnings（“unchecked“）
public?class?ExportController?{

	/**
	?*?數組數據樣例
	?*?@return
	?*/
	private?Listject[]>?getData（）{
		Listject[]>?list?=?new?ArrayListject[]>（）;
		for（int?i=1;i<100;i++）{
			list.add（new?object[]{i“童鞋“+i“你猜““K型““陰陽路“+i+“號“}）;
		}
		return?list;
	}
	
	/**
	?*?Bean數據樣例
	?*?@return
	?*/
	private?List?getBeanData（）{
		List?list?=?new?ArrayList（）;
		for（int?i=1;i<100;i++）{
			People?p?=?new?People（）;
			p.setCode（i）;
			p.setName（“童鞋“+i）;
			p.setAddr（“陰陽路“+i+“號“）;
			p.setBlood（“K型“）;
			p.setSex（“你猜“）;
			p.setBirthday（new?Date（））;
			list.add（p）;
		}
		return?list;
	}

	/**
	?*?Map數據樣例
	?*?@return
	?*/
	private?List?getMapData（）{
		List?list?=?new?ArrayList（）;
		for（int?i=1;i<100;i++）{
			Map?map?=?new?HashMap（）;
			map.put（“code“?i）;
			map.put（“name“?“童鞋“+i）;
			map.put（“sex“?“你猜“）;
			map.put（“blood“?“K型“）;
			map.put（“addr“?“陰陽路“+i+“號“）;
			list.add（map）;
		}
		return?list;
	}
	
	/**
	?*?表格數據查詢
	?*?@return
	?*/
	@RequestMapping（params?=?“method=loadData“）
	@ResponseBody
	public?List?loadData（）{
		return?getBeanData（）;
	}
	
	/**
	?*?普通Excel導出，獲取的數據格式是List
	?*?@return
	?*?@throws?Exception?
	?*/
	@RequestMapping（params?=?“method=exportExcel“）
	public?void?exportExcel（HttpServletRequest?request?HttpServletResponse?response）?throws?Exception{
????????response.setContentType（“application/msexcel;charset=GBK“）;
????????
????????List?list?=?getBeanData（）;//獲取數據
????????
????????String?title?=?“普通Excel表“;
????????String[]?hearders?=?new?String[]?{“編號“?“姓名“?“性別“?“血型“?“地址“?“生日“};//表頭數組
????????String[]?fields?=?new?String[]?{“code“?“name“?“sex“?“blood“?“addr“?“birthday“};//People對象屬性數組
????????TableData?td?=?ExcelUtils.createTableData（list?ExcelUtils.createTableHeader（hearders）fields）;
????????JsGridReportbase?report?=?new?JsGridReportbase（request?response）;
????????report.exportToExcel（title?“admin“?td）;
	}

	/**
	?*?合并列表頭Excel導出，獲取的數據格式是List
	?*?@return
	?*?@throws?Exception?
	?*/
	@RequestMapping（params?=?“method=spanE

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-05-05?14:58??export\
?????文件????????5581??2017-05-05?14:24??export\.classpath
?????文件?????????283??2012-12-20?17:23??export\.mymetadata
?????文件??????????66??2012-07-25?14:10??export\.myumldata
?????文件????????1616??2017-05-05?14:50??export\.project
?????目錄???????????0??2017-05-05?14:58??export\.settings\
?????文件????????1040??2012-07-25?14:10??export\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????598??2017-05-05?14:06??export\.settings\org.eclipse.jdt.core.prefs
?????文件?????????117??2017-05-05?14:50??export\.settings\org.eclipse.jst.j2ee.ejb.annotations.xdoclet.prefs
?????文件?????????554??2017-05-05?14:50??export\.settings\org.eclipse.wst.common.component
?????文件?????????259??2017-05-05?14:24??export\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????87??2017-05-05?14:50??export\.settings\org.eclipse.wst.ws.service.policy.prefs
?????文件?????????232??2017-05-05?14:50??export\.settings\org.eclipse.wst.xsl.core.prefs
?????目錄???????????0??2017-05-05?14:58??export\WebContent\
?????目錄???????????0??2017-05-05?14:58??export\WebContent\meta-INF\
?????文件??????????39??2017-05-05?14:06??export\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2017-05-05?14:58??export\WebContent\WEB-INF\
?????目錄???????????0??2017-05-05?14:58??export\WebContent\WEB-INF\lib\
?????目錄???????????0??2017-05-05?14:58??export\WebRoot\
?????目錄???????????0??2017-05-05?14:58??export\WebRoot\meta-INF\
?????文件??????????36??2012-04-12?15:47??export\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2017-05-05?14:58??export\WebRoot\WEB-INF\
?????目錄???????????0??2017-05-05?14:58??export\WebRoot\WEB-INF\classes\
?????文件????????1680??2017-05-05?14:56??export\WebRoot\WEB-INF\classes\springmvc-servlet.xml
?????目錄???????????0??2017-05-05?14:58??export\WebRoot\WEB-INF\classes\xingyou\
?????目錄???????????0??2017-05-05?14:58??export\WebRoot\WEB-INF\classes\xingyou\controller\
?????文件????????9730??2017-05-05?14:56??export\WebRoot\WEB-INF\classes\xingyou\controller\ExportController.class
?????目錄???????????0??2017-05-05?14:58??export\WebRoot\WEB-INF\classes\xingyou\excelTools\
?????文件????????2474??2017-05-05?14:56??export\WebRoot\WEB-INF\classes\xingyou\excelTools\ExcelBean.class
?????文件???????19546??2017-05-05?14:56??export\WebRoot\WEB-INF\classes\xingyou\excelTools\ExcelUtils.class
?????文件????????3873??2017-05-05?14:56??export\WebRoot\WEB-INF\classes\xingyou\excelTools\FormulaProcessor.class
............此處省略183個文件信息

評論

共有 條評論