SSM框架使用POI的技术导出Excel.docx

POI框架是Apache开源的可以导出导入Excel表的，本博客介绍在SSM(Spring+SpringMVC+Mybatis)项目里，如何使用POI框架，导出Excel表这里我们先要去Apache官网下载jar然后，就可以先编程了先提供一个封装的httpservlet请求和添加数据的类[java]?view plain?copy?/snippets/1879196/snippets/1879196/forkpublic?class?PageData?extends?HashMap?implements?Map{????private?static?final?long?serialVersionUID?=?1L;????Map?map?=?null;???HttpServletRequest?request;????public?PageData(HttpServletRequest?request){???this.request?=?request;???Map?properties?=?request.getParameterMap();???Map?returnMap?=?new?HashMap();?Iterator?entries?=?properties.entrySet().iterator();?Map.Entry?entry;?String?name?=?;?String?value?=?;?while?(entries.hasNext())?{???entry?=?(Map.Entry)?entries.next();?name?=?(String)?entry.getKey();?Object?valueObj?=?entry.getValue();?if(null?==?valueObj){?value?=?;?}else?if(valueObj?instanceof?String[]){?String[]?values?=?(String[])valueObj;???for(int?i=0;ivalues.length;i++){?value?=?values[i]?+?,;???}???value?=?value.substring(0,?value.length()-1);?}else{???value?=?valueObj.toString();?}???returnMap.put(name,?value);?}???map?=?returnMap;???}????public?PageData()?{???map?=?new?HashMap();???}????@Override??public?Object?get(Object?key)?{???Object?obj?=?null;???if(map.get(key)?instanceof?Object[])?{???Object[]?arr?=?(Object[])map.get(key);???obj?=?request?==?null???arr:(request.getParameter((String)key)?==?null???arr:arr[0]);???}?else?{???obj?=?map.get(key);???}???return?obj;???}????public?String?getString(Object?key)?{???return?(String)get(key);???}????@SuppressWarnings(unchecked)???@Override??public?Object?put(Object?key,?Object?value)?{???return?map.put(key,?value);???}????@Override??public?Object?remove(Object?key)?{???return?map.remove(key);???}????public?void?clear()?{???map.clear();???}????public?boolean?containsKey(Object?key)?{???//?TODO?Auto-generated?method?stub??return?map.containsKey(key);???}????public?boolean?containsValue(Object?value)?{???//?TODO?Auto-generated?method?stub??return?map.containsValue(value);???}????public?Set?entrySet()?{???//?TO