控制层操作;
//导出excel
@RequestMapping("/toExcel")
public void downLoadExcel(HttpServletRequest request, HttpServletResponse response){
String fileName = "生长适宜性指数";
List<Map<String, Object>> listmap = new ArrayList<Map<String, Object>>();
Map<String, Object> map = new HashMap<String, Object>();
map.put("sheetName", "sheet1");
listmap.add(map);
Exponent exponent = null;
for (int j = 0; j <list.size(); j++) {
exponent = list.get(j);
Map<String, Object> mapValue = new HashMap<String, Object>();
mapValue.put("年份",exponent.getDT());
mapValue.put("地区",exponent.getAREA());
mapValue.put("作物名称",exponent.getFName());
mapValue.put("站名",exponent.getSName());
mapValue.put("站号",exponent.getSNO());
mapValue.put("发育期",exponent.getPhase());
mapValue.put("24小时生长适宜性",exponent.getI24());
mapValue.put("48小时生长适宜性",exponent.getI48());
mapValue.put("72小时生长适宜性",exponent.getI72());
mapValue.put("96小时生长适宜性",exponent.getI96());
listmap.add(mapValue);
}
String columnNames[] = {"年份","地区","作物名称","站名","站号","发育期","24小时生长适宜性","48小时生长适宜性",
"72小时生长适宜性","96小时生长适宜性"};// 列名
String keys[] = {"年份","地区","作物名称","站名","站号","发育期","24小时生长适宜性","48小时生长适宜性",
"72小时生长适宜性","96小时生长适宜性"};// map中的key
try {
ExportExcel.download(request, response, listmap, fileName, columnNames, keys);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
js代码:
//导出Exccel
function pmgressbar(){//进度条
var win = $.messager.progress({
title : '请稍等',
msg : '正在导出中...',
});
setTimeout(function(){
$.messager.progress("close");
},600)
}
function onClick_download(){
//alert(11)
$.messager.confirm("确认","确认将搜索到的数据导出为Excel表格?",function(r){
if(r){
url="/SX_LGQX/exponent/toExcel.do";
location.href=url;
pmgressbar();
}
});
}