package?com.llg.controller.common;

import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;

import?javax.servlet.http.HttpServletRequest;

import?org.springframework.stereotype.Controller;
import?org.springframework.ui.ModelMap;
import?org.springframework.web.bind.annotation.RequestMapping;
import?org.springframework.web.servlet.ModelAndView;

import?com.llg.controller.base.baseController;
import?com.llg.util.Jurisdiction;
import?com.llg.util.objectExcelView;
import?com.llg.util.PageData;

@Controller
@RequestMapping（“/excelExport“）
public?class?ExcelController?extends?baseController?{

	String?menuUrl?=?“excel/list.do“;?//菜單地址（權(quán)限用）
	
/*	@RequestMapping（“/goExcelUpload“）
	public?String?getTransferList（ModelMap?model?HttpServletRequest?request?String?employeeId）?throws?Exception?{
		//?employeeId?=?request.getParameter（“employeeId“）;

		return?“/transfer/excelUpload“;
	}*/
	?/**導(dǎo)出到excel
		?*?@param
		?*?@throws?Exception
		?*/
		@RequestMapping（value=“/export“）
		public?ModelAndView?exportExcel（HttpServletRequest??request）?throws?Exception{
			logBefore（logger?Jurisdiction.getUsername（）+“導(dǎo)出Child到excel“）;
			ModelAndView?mv?=?new?ModelAndView（）;
			Mapject>?dataMap?=?new?HashMapject>（）;
			List?titles?=?new?ArrayList（）;
			String?tou?=?request.getParameter（“tou“）;
			if（null!=tou）{
				String[]?ths?=?tou.split（““）;
				for（String?th?:ths）{
				titles.add（th）;	
				}
			}
			dataMap.put（“titles“?titles）;
			String[]?rows=?request.getParameterValues（“row“）;
			List?varList?=?new?ArrayList（）;
			for（int?i=0;i				PageData?vpd?=?new?PageData（）;
				String[]?cols?=?rows[i].split（““）;
				for（int?j=0;j					vpd.put（“var“+（j+1）?cols[j]）;	
				}
				varList.add（vpd）;
			}
			dataMap.put（“varList“?varList）;
			objectExcelView?erv?=?new?objectExcelView（）;
			mv?=?new?ModelAndView（ervdataMap）;
			return?mv;
		}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????2382??2017-10-19?12:30??excel.js
?????文件???????76043??2017-10-19?12:45??tabletest.html
?????文件???????16911??2017-10-19?12:47??操作說明.docx
?????文件????????2070??2017-10-19?11:45??ExcelController.java