atitit.导出excel的设计----查询结果导出为excel的实现php总结

1.主要的流程

查询获得list

读取jsp的table获得标题and字段的map

toexcel(map,list)

2.提交的html数据结构

_meth=sqldwr的元数据

_metadata=xxxx

reqDatas....

作者::老哇的爪子Attilax艾龙，EMAIL:1466519819@

转载请注明来源：/attilax

3.处理代码

prj:wechatadm4prp

Command.reg("export",newClosure2(){

@Override

publicObjectexecute(Objectarg0){

Mapm2=convert2atiormMap(m);

Objectsql=newOrmX().convert2sql(JsonX.toJsonStrO88(m2));

Hbxhbx=AaaCfg.IocX.getBean(Hbx.class);

try{

Listli=hbx.exe(sql);

Mapm3=newHashMap();

m3.put("size",li.size());

JSONObjectmetadata=JSONObject.fromObject(m.get("_metadata"));

Stringjsppath=metadata.getString("titleMapFile");

List<Map>titlesMap=HtmlX.getTitlesMap(jsppath,"tabid1","utf-8");

m3.put("url",geneExportExcel(li,titlesMap));

returnm3;

}catch(SQLGrammarExceptione){

filex.saveLog(sql.toString(),"c:\\e");

thrownewRuntimeException(sql.toString(),e);

}

//returns;

}

});

protectedObjectgeneExportExcel(Listlist,List<Map>titlesMap){

StringfileName=filex.getUUidName()+".xls";

Stringf=pathx.webAppPath()+"\\uploadf\\"+fileName;

excelUtil.toExcel(titlesMap,list,f);

return"uploadf/"+fileName;

}