导出Excel
//导出方法
public ExcelOption getOption(String data) {
bbttVO vo =(bbttVO) VOUtils.getBeanFromJsonData(data, bbttVO.class);
ExcelOption returnVO = new ExcelOption();
// 构造表头
LinkedHashMap<String, String> linkedHashMap = new LinkedHashMap<String, String>();
List<Map<String, Object>> list=null;
linkedHashMap.put("grbh", "个人编号");
linkedHashMap.put("sfzh", "身份证号");
linkedHashMap.put("xm", "姓名");
linkedHashMap.put("fpzs", "发票张数");
linkedHashMap.put("ylfyze_hj", "医疗费用总额");
returnVO.setHeads(linkedHashMap);
String sql="";
sql="SELECT * from tablename";
list = CommonJdbcDaoUtils.queryForList(sql.toString(), new Object[] {});
double ylfyze_hj=0.0;
int fpzs=0;
int j=0;
for( Map<String, Object> m:list){
if(!"-".equals(m.get("fpzs").toString()) ){
fpzs+=Integer.valueOf( m.get("fpzs").toString() );
}
ylfyze_hj=NumberTools.add( ylfyze_hj, Double.valueOf(m.get("ylfyze_hj").toString()) );
j++;
}
Map<String, Object> map_hj= new LinkedHashMap<String, Object>();
map_hj.put("grbh", " ");
map_hj.put("sfzh", "人数:"+j);
map_hj.put("xm", " ");
map_hj.put("fpzs", fpzs);
map_hj.put("ylfyze_hj", ylfyze_hj);
list.add(map_hj);
/**数据处理
Integer i=0;
int j=0;
for(Map<String, Object> m:list){
if("9999999999".equalsIgnoreCase(m.get("xh").toString())) {
list.get(j).put("xh", "");
}else{
i++;
list.get(j).put("xh", i.toString());
}
j++;
}
*/
returnVO.setList(list);
Calendar c = Calendar.getInstance();
SimpleDateFormat s=new SimpleDateFormat("yyyyMMddHHmmss");
String curDate = s.format(c.getTime());
String fileName = curDate+".xls";
returnVO.setFilename(fileName);
String title = "";
returnVO.setTitle(title);
return returnVO;
}